Calling up Statistics via Resource Planning

As of version 1.7 of the FSM, it is possible to call up statistics via the resource planning. Filters from the resource planning can be transferred as parameters in the statistics. The entry points are configured in the "resourcePlanningScheduler.json". For this purpose, another "name-data" object is added to the "objects" array. The name of this object is "openExternalInfo". An object list is specified as "data". An object has the following structure:

Name

Description

title

Name/title of the entry point

statisticId

Id of the statistic to be called up

openInNewTab

Indicates whether the statistic should be opened in a new browser tab. If 'false' or no entry has been made here, the statistic will be opened in a new sheet.

mapping

The mapping between the filter variables from the RP and the parameters of the statistic

The variables and the parameters are case sensitive.

Filter variables

The following filter variables are available for mapping:

Name

Description

Start

Starting point of time

End

Ending point of time

OGrNrs

The OGrNrs of the filtered main groups

GrNrs

The GrNrs of the filtered groups

Restypes

The Ids of the filtered resource types

FilteredFlags

The Ids of the filtered flags

FilteredIcons

The Ids of the filtered icons


The list is not complete. The most important filters are listed.


Example:

{
"name": "openExternalInfo",
"data": [
{
"title": "Open in new sheet",
"statisticId": "eba5ca97-9ea2-44f5-a24a-0a4135210850",
"mapping": {
"OGrNrs": "user_ogrnr",
"GrNrs": "user_grnr",
"Start": "date_from",
"End": "date_to"
}
},
{
"title": "Open in new tab",
"statisticId": "eba5ca97-9ea2-44f5-a24a-0a4135210850",
"mapping": {
"OGrNrs": "user_ogrnr",
"GrNrs": "user_grnr",
"Start": "date_from",
"End": "date_to"
},
"openInNewTab": true
},
{
"title": "Something new, something blue, something borrowed",
"statisticId": "ed81f39b-68c1-4c0f-bd6a-a0a8f187cedf",
"mapping": {
"GrNrs": "user_grnr",
"Start": "date_from",
"End": "date_to"
}
}
]
}