Skip to Content
Author's profile photo Abhijeet Mukkawar

Real-time reporting on multiple BPM datasources in Visual Composer

Recently, with imminent release, we came across a requirement where end user wanted to know processes with particular task subject. Though we have all the Reporting on standard and custom data sources in BW, accommodating it there via custom datasource at last moment would have triggered newer version of Reporting datasource and thereby triggering changes in BW side as well (Uncertain if this limitation - of getting new version created- is fixed in 7.31, we are working on 7.2 SP 5 at the moment). Also, we were not able to find “Subject” field in “BPM_TASKS_DS” which can be pulled in BW (It’s available in “BPM_MY_TASK_DS” which cannot be pulled in BW though), leaving us behind with only option of Visual Composer.

However, showing the processes with particular tasks name/subject requires JOIN operation on the 2 (BPM_MY_TASK_DS and BPM_MY_PROCESS_DS) datasources and whatever searches we did, said that JOIN is not supported in Visual Composer(Would be great to know if there is any alternate way). Nonetheless, with the mandate of fulfilling the requirement we somehow did it using concept of “Entry List”. Though this doesn’t let us go deep down in process’ attributes, we can identify the process names against particular tasks. Thankfully, that was sufficient for the requirement.

Security role requiredFor having a reporting view on these datasources, you can display data if your user is assigned to the SAP_BPM_SuperDisplay or SAP_BPM_SuperAdmin roles.

(Because, for BPM_MY_PROCESSES_DS, your user needs to be assigned to a role which gives you access to the particular process instance, e.g. Business Process Administratorrole and for BPM_MY_TASKS_DS, your user needs to be assigned to a role which gives you access to the particular task instance, for example Potential Owner, Actual Owner, Business Administrator, and so on.)

Scenario: Taking a simple process example – Scheduler Process - having 3 tasks viz. Sales Approval, Finance Approval and HR Approval, we will try to fetch the list of processes having “Finance Approval” task in it.


1.     Create a new Service Component in VC using datasource “BPM_MY_PROCESSES_DS” with simple “In” and “Out” Port. Choose appropriate fields, here we selected ID, Parent_ID, Status, Subject and Description. Save.

2.5 Service Component.JPG

2.     Create New Model -> Composite view with datasource “BPM_MY_TASKS_DS” and “In” and “Out” Port. Select appropriate fields, here we selected ID, Parent_ID, Status and Subject.

     4 Drag and Drop Task DS.JPG

3.     Create a just a “Start” event to start the model and select a “filter” from Out port.

     5 Start In and filter Out.JPG

4.     Define filter operator to filter on tasks with “Subject” containing “Finance” (Right click on Filter -> Define Operator)

     6 Define Filter.JPG

5.     Create a “Table View” from a filter.

     7 Create Table from Filter.JPG

6.     Go To Layout-> Change the Control type of “Parent Id” field to “DropDown List”( Parent Id specifies the process ID the task is part of)

     8 Change Control type.JPG

7.     Create a Dynamic “Entry list” on “Parent ID” field. (right click -> Entry List)

     9 dynamic Entry List.JPG

8.     On next screen, choose “Visual Composer components” in provider and search for the service component we created in Step 1.

     10 Search Service Component.JPG

9.     Skip “Configure Input” and proceed to “Configure Output”. Select “Id” in Value which specifies the process Id in service component (represented here as Parent_Id). Choose “Subject” in Display text which will show the Process Subject of particular tasks.

     11 Configure Output.JPG

10.    Make the “Parent_Id” field or perhaps the whole table as Read Only, adjust column’s properties of table as required. Save, Deploy and Run the model.

     12 Run the model.JPG

11.    “Export" option can be selected in VC for giving way to export the list to Excel file.

     13 Export option.JPG

I am not an expert in Visual Composer, hence any views from experts are most welcome to do this in simpler way Or some better way to have reporting on multiple datasources.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Kunal Saggar
      Kunal Saggar

      Thanks for the detailed blog. it was really helpful for me.

      Author's profile photo Piyas Kumar Das
      Piyas Kumar Das

      Hi Abhi,

      Excellent Document but it would be great if you could have started from the BPM