Reporting
In this section, you define additional query functions to enable execution users to review results.
Once the profitability and cost management calculation has been completed, the following review and reporting activities can be run:
-
Review Results
This Query function is used to provide read data access to the profit and loss results.
-
Profitability per Region and Posting Date
This Query function is used to provide read data access to the main results for different regions and posting dates.
-
Product Result [Baseline Scenario]
This Query function provides profitability results on product and service level, and is used as baseline scenario.
-
Product Result [Simulation Scenario]
This Query function provides profitability results on product and service level, and is used as simulation scenario.
-
Quarterly Result [Baseline Scenario]
This Query function provides profitability results on product and service level by quarters, and is used as baseline scenario.
-
Quarterly Result [Simulation Scenario]
This Query function provides profitability results on product and service level by quarters, and is used as simulation scenario.
-
Net Profit Margin per Product and Scenario [%]
This Query function is used to provide read data access to the main results and to calculate the net profit margin by dividing profit and loss with revenue results directly in this Query function.
-
Activity Results
This Query function is used to provide read data access to the main results.
-
Activity Utilization by Product
The Query function is used to provide read data access to the main results.
-
Channel Profitability by Product
The Query function is used to provide read data access to the main results.
-
Value Flow
This Query function is used to provide read data access to the main results.
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.