Symptom
You are previewing the data source Approval Task Details or using a report based on it. You receive the following errors in the data source or report:
- 'Either the user does not have the relevant authorizations to execute the report or there are no approval task instances to display'
- 'No report data available to display; check the selection'
- 'Error reading the data of datasource'
Environment
- SAP Cloud for Customer
- SAP Business ByDesign
Reproducing the Issue
- Go to the work center Business Analytics and the view Design Data Sources.
- Search for Approval Task Details.
- Click Preview.
You face the above errors.
Cause
The data source Approval Task Details must always be used as a joined data source along with application created data source. Application created data source should act as an anchor data source. Approval Task Details data source should never be consumed independently since it does not show any data on its own. Also, if the business documents are not enabled for Multi-Step Approval process, then the report will never work.
For example:
Purchase order and supplier invoice are registered for Multi-Step Approval and the corresponding data source for the same is listed below, which should be set as an anchor data source.
- Approval of Purchase orders – Data source available for Purchase order header data.
- Approval of non-PO invoices – Data source available for Supplier invoice header data.
Resolution
-
Go to the Business Analytics work center, Design Data Sources view
- Create a joined data source
- Add Purchase Order Header Data source as anchor and select the necessary fields required for constructing the report as shown below
- Once the anchor data source is added, add the Approval Task Details data source and choose the necessary fields which must be displayed in the report as shown below
- Remove the UUID attribute of the Approval Task Details data source
- Create a join between the Purchase Order ID (UUID) and the UUID from the Approval Task Details data source:
On the created data source, create a report which will fetch all approval tasks for the purchase order(s).
- Go to Business Analytics work center, Design Reports view.
- After you have created the new report face (e.g. Purchase Order Approval Task), select all the required key, characteristics and complete the report creation guided activity
- Execute the report to fetch the approval tasks for the purchase orders, where you can find all the necessary details.
See Also
Background of this data source:
When conditions in the approval process step(s) are met, task(s) are created for the employee(s) responsible, which the employee responsible can then approve/reject. You would like to analyze the time it takes at each step to approve a document and explore the possibility to reduce the time taken. Scenarios could include:
- Who are the approvers who take more time to approve the document?
- Who needs a follow-up?
- What percentage of approvals get rejected?
- How many approvals get corrected before getting approved?
This can be achieved by using the Approval Task Details data source.
Keywords
Approval Task, data source, report, Either the user does not have the relevant authorizations to execute the report or there are no approval task instances to display, no report data, error reading the data of datasource, BTMAPPV01 , KBA , error reading the data of datasource , user does not have the relevant authoriz , no approval task instances to display , btmappv01 , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-CC-BTM , Business Task Management , How To