1
Download a report template
Choose a report template and download it in XLSX format:
- BusinessProcessingReport_BatchState – Current batch states:
- Processing batches – Batches currently being processed.
- SLA Violation – The number of batches that are in violation of SLA times, sorted by batch creation date.
- Processed batches – Batches sorted by processing stage and creation date.
- BusinessProcessingReport_BatchRouting – Batch processing history:
- Batches on stage – The number of batches that have passed the corresponding processing stage.
- Average stage time – The average and total time accrued at each processing stage, sorted by project.
- Verified batches – The number of batches at the verification stage, sorted by operator.
2
Specify the data source
In the Param tab, specify the path to the Business Process Reporting data storage catalog in the SourceDir field. If required, specify the start and end dates for the reporting period in the CreateDateFrom | CreateDateTo fields. The files are sorted by creation date.
3
Upload the data
Select Data → Refresh All in the toolbar to begin uploading data. While data is uploading, the status bar at the bottom of the screen shows
Retrieving Data….4
View the data
Select Power Pivot → Manage in the toolbar to view the data as a table in CSV format.
Your version of Microsoft Excel may not have the Power Pivot add-in enabled. For information about enabling this add-in, see the Microsoft website.
