Reporting
In this section, you define additional query functions to enable execution users to conveniently review results.
Once the profitability and cost management, KPI and plant carbon emission calculations have been completed, the following review and reporting activities can be run:
-
Material Movements
This Query function is used to provide read data access to the main results.
-
Activity Results
This Query function is used to provide read data access to activity result reports per quarter.
-
Review Results
This Query function is used to provide read data access to the profit and loss result report for each quarter.
-
KPI Results
This Query function is used to provide read data access to the KPI results per plant and product.
-
Inventory KPIs
This Query function is used to provide read data access to the inventory KPI results per plant and product.
-
Out of Stock Rate
This Query function is used to provide read data access to the out of stock rate per plant and product.
-
Carbon Emission Results
This Query function is used to provide read data access to the CO2 emissions per plant.
-
Value Flow
This Query function is used to provide a granular traceability result report showing the end-to-end value flow.
-
Quarterly Result [Baseline Scenario]
This Query function provides profitability results at product level by quarters, and is used as baseline scenario.
-
Quarterly Result [Simulation Scenario]
This Query function provides profitability results at product level by quarters, and is used as simulation scenario.
Procedure
Follow the steps below to see the available fields of the Query functions listed above:
-
Expand the Reporting node in the navigation structure on the left-hand side of the screen.
-
Choose the function that you want to open.
-
Choose the Sheet Definition tab on the right-hand side of the screen.
-
In the Columns and Rows sections, you can find all fields that are preconfigured for the selected report.
-
In the Free section, the system displays all free fields that are also available for this report.