Duet Enterprise is a new product developed jointly by SAP & Microsoft to expose the SAP services/screens into Share Point 2010.
Duet Enterprise provides SSO functionality and out of box scenarios like: Workflow, Reporting, Starter Services etc. It enhances the end user expereince and provide a seemless interface. I will explain in this blog about the Reporting feature and how to schedule a report to run periodically from Share Point
Reporting is one of the Ready to Use capability which lets the end users schedule the back end system report from Share Point 2010. The report gets sent to the Duet SAP System, called as SCL system. Roles are checked in SCL system and then request is sent back to the backend system. The report is executed and the output is sent back to SCL system and then to Share Point in Excel format. Sounds easy and interesting for Ad-Hoc execution of reports, but ever wondered, how an end user can schedule a report to run periodically.
System Time Points
SYSTEM TIME POINTS is a feature provided to schedule a report periodically. Think of this as similar to scheduling a job from SM37 and choosing periodic. I will explain in this blog, the procedure to create, edit, use of system time points for Reporting scenario in Duet Enterprise. I will show how to make use of them from Share Point 2010. This blog assumes that Reporting scenario is already configured and working end to end in Duet Enterprise 1.0 environment.
Installed, Configured Duet enterprise for Reporting scenario. Sample reports or any other reports must be configured in the SCL system and able to execute them from SharePoint 2010
Backend system is ERP 6.0 EHP 4
SCL system is NW 7.02 with Duet Add-Ons Installed
SharePoint 2010 with Duet Enterprise Add-Ons Installed
Log in to backend system (ex: ERP) in working client and go to SM36
Schedule the Time Point Job with the following:
Job Name: TP_BROADCASTING_DAILY (Job name should be in format TP_BROADCASTING_XXXXX)
Job Step Name: /OSP/IW_TIMEPOINT_PROCESS (for ERP System)
Job Frequency: Choose your frequency. If the report needs to be executed every day, then choose daily.
Do not change the default values for Job class, Status, and Exec. Target
If Backend system is ERP, step should be:
If Backend system is BW, you need to add additional step RSRD_BROADCAST_FOR_TIMEPOINT:
We need to create additional time point jobs if we need to execute the Reports with different frequency in Share Point. Here we assume that we only need Reports to be executed daily; hence we have created only one job.
The job should at least run once successfully, to see the System Time Point in the SCL system.
In SCL system
Login to SCL system,
Tcode -> SIMGH
IMG Structure -> Service Consumption Layer Reporting Administration
Choose -> Manage System Time Points and Data Change Events
You should now see the system time point job.
Check the “Active” checkbox and the time point should be ready for use.
Status should be “Active” now.
In my system, I have created 4 time points that run every 15mins, Daily, Weekly, and Monthly.
Now go to “Manage reports and their properties”
Open the report for which you want to configure time points. Make sure “Based on Time Points” is checked.
Now in Share Point Duet Reporting Site, go to Report settings and edit the properties:
Select “Schedule Report” and click on Edit.
Now choose the Time point “Daily” that we created earlier
Save the report with a new name.
The report is saved as “ Inquiries List – Daily Run”
Now once the Time Point job is executed in backend (daily), the report output is seen in Share Point.
In this way, end user can use the system time points defined by Duet Administrator to schedule his jobs periodically.