Supported parameters for manager and payee reports
This document details the beqom application parameters that can be used to filter process employee reports, process manager reports and Advanced Analytics reports.
Standard Process Filters
This is an note/information message.
The parameters described below do not apply to the "process form" type of process.
The following table lists the standard beqom parameters that can be used to filter process reports.
| Parameter | Manager Report (SSRS) | Employee Report (SSRS) | Advanced Analytics Report |
|---|---|---|---|
| idUser | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet)** |
| idProfile | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet)** |
| idPayee | (missing or bad snippet)* | (missing or bad snippet)* | (missing or bad snippet) |
| idStep | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| idTree | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| idType | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| id_simulation | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| planFilterLevel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| planFilterIsSelf | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| planFilterStartDate | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| planFilterEndDate | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| planFilterWorkflowStep | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| plaFilterCustom | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| planIndicatorFieldFilters | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
*In RNExplorerDetail, selectedPersonId is fetching the itemId of the node. In case the node corresponds to a structure, it then takes the structure ID.
For the manager report, this corresponds to the selected node in the tree
For the payee report, this corresponds to the selected payee in the process grid
**Report security parameters
Advanced Process Filters
Advanced process filters are extra filters used for Advanced Analytics and that can be managed by the application. However, they require a specific configuration in order to map the filter value with a specific column in the Advanced Analytics data model.
For more information about the procedure to link process parameters to an Advanced Analytics report, refer to BQM29 - [[[Undefined variable FAQ_Titles.BQM29]]].
| Filter | Description |
|---|---|
| Information columns | Any information column defined in the process |
| Indicator fields | Any indicator field available in the system |
| Min | Minimum value for indicator fields; define with Minimum |
| Max | Maximum value for indicator fields; define with Maximum |
| Start date | Start date of the process step |
| End date | End date of the process step |
| Workflow step | Workflow step |
| Workflow status | Workflow status |
| Level | Level |