ramesh.borra

Previous post Next post
Currently Being Moderated

Introduction

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

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.

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

Procedure

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.

Choose Periodic

Do not change the default values for Job class, Status, and Exec. Target

 Image1

If Backend system is ERP, step should be:

Image2

If Backend system is BW, you need to add additional step RSRD_BROADCAST_FOR_TIMEPOINT:

Image3

 image

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.

Image4

Check the “Active” checkbox and the time point should be ready for use.

Image5

Status should be “Active” now.

Image6

In my system, I have created 4 time points that run every 15mins, Daily, Weekly, and Monthly.

Image7

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.

Image8

Now in Share Point Duet Reporting Site, go to Report settings and edit the properties:

Image9

Select “Schedule Report” and click on Edit.

IMage10

Now choose the Time point “Daily” that we created earlier

Image11

Save the report with a new name.

Image12

The report is saved as “ Inquiries List – Daily Run”

Image13

Now once the Time Point job is executed in backend (daily), the report output is seen in Share Point.

Image14

In this way, end user can use the system time points defined by Duet Administrator to schedule his jobs periodically.

Comments

Actions

Filter Blog

By date: