Sample report types
To make working with reports more convenient, we have created report templates that can be used with your own data. To compile a report using a template, do the following:
- Choose a report template and download it in XLSX format using the link:
- BusinessProcessingReport_BatchState. Current batch states.
- Processing batches. Batches currently being processed.
- SLA Violation. Number of batches that are in violation of SLA times. Sorted by batch creation date.
- Processed batches. Sorts batches 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 times accrued at each processing stage, sorted by different projects.
- Verified batches. The number of batches at the verification stage, sorted by operators.
- 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 will be sorted by creation date.
- Select Data > Refresh All in the toolbar to begin uploading data. In the status bar in the lower part of the screen, the Retrieving Data… status will be displayed while data is being uploaded.
- Select Power Pivot > Manage in the toolbar to view the data as a table in CSV format.
Note: Your particular version of Microsoft Excel may not have the Power Pivot add-in enabled. For detailed information about enabling this add-in, see the Microsoft website.
4/12/2024 6:16:02 PM