Skip to Content

Creating a Data Source from Process Context for Reporting Purposes

Hi All,

It is not an unusual requirement for the need of creating a Report or a Dashboard based on the data residing in the process-context of a BPM Process.

It is not a lesser known fact that this is achieved by using a Reporting Activity in the BPM at design-time.

The question arises that the reports and any other type of data interpretation techniques require a data-source to function. The Reporting Activity does this job for us.

There are 4 basic steps to achieve this:

1.Create a BPM Process
2.Create a Reporting Activity in the BPM Process and pass the data required in the datasource

3.Create a datasource and integrate it into the Reporting Activity.

4.Deploy.

Lets see these steps in detail.

1.Create a BPM Process:

Refer this document I wrote for creating a BPM Process:   http://scn.sap.com/docs/DOC-47005

2. Create a Reporting Activity in the BPM Process:

Rep1.jpg

After adding, it should look like this:

Rep2.jpg

Open the properties of the reporting Activity:

Rep3.jpg

3.Create a datasource and integrate it into the Reporting Activity

In the ‘Reporting’ tab of the properties, select ‘New’ to create a new datasource:

Rep4.jpg

Name the Datasource and click on ‘Next’:

Rep5.jpg

Select the data for the datasource and click on ‘Finish’:

Rep6.jpg

The datasource is now created.

In the ‘Input Mapping’ tab of the properties of the Reporting Activity, map the process context data to the datasource:

Rep7.jpg

4. Now, build and deploy the BPM DC.

Accessing the datasource:

For example, if we take Visual Composer into consideration, we can access the datasource as follows:

Log in to Visual Composer (Web) –    http://<hostname>:<port>/VC

Rep8.jpg

Click on ‘New’ and create a new model DC:

Rep9.jpg

Once this DC is created, click on ‘Search’ on the extreme right and select ‘BI Data Sources’. Your datasource should be visible here as shown:

Rep9.jpg

Once this is imported into the VC development component, we can use it for any data interpretation purposes.

This worked for me.

However, if I did something wrong or miscommunicated something, please let me know and help me improve.

Hope this helps in some way.

Thanks.

Sid

1 Comment
You must be Logged on to comment or reply to a post.
  • Before trying this out, please make sure all the configurations related to your server and database connections are done and tested properly.