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.

  • Review Results at Group Level [Side-by-Side Simulation]

    This Query function is used to provide read data access to the profit and loss results, comparing results per different scenarios.

  • Product Profitability Results

    This Query function is used to provide read data access to the profitability and cost management results at product and service level.

  • Product Results [Side-by-Side Simulation]

    This Query function is used to provide read data access to the final results of Retail Profitability and Cost Management at product and service level, comparing results per different scenarios.

  • Product Results [for QR Simulation]

    This Query function is used to provide read data access to the profitability and cost management results at activity level.

  • Activity Results

    This Query function is used to provide read data access to the final results of Retail Profitability and Cost Management at activity level.

  • Product Profitability by Channels

    This Query function is used to provide read data access to the final results of Retail Profitability and Cost Management at product and service level by channels.

  • Channels Profitability [for QR Simulation]

    This Query function is used to provide read data access to the profitability and cost management results at product and service level by channels.

  • Contribution Margin Scheme Report

    This Query function is used to provide read data access to the profit and loss results hierarchically, showing profit and loss results.

  • Supplier Profitability for Food and Beverage Segment

    This Query function is used to provide read data access to the profitability and cost management results at food and beverage product segment level and supplier level.

  • ROI per Supplier for Health and Personal Care Segment [%]

    This Query function is used to provide read data access to the profitability and cost management results at product level in the health and personal care segment, calculating return on investment per supplier.

    Field Amount [TC] is shown at product and service level, categorized by posting dates. The net profit margin (in percentages) is calculated using a formula and displayed in the report.

  • Net Profit Margin per Product and Service Segment [%]

    This Query function is used to provide read data access to the profitability and cost management results at product and service level, calculating the net profit margin on top of the final results.

    Field Amount [TC] is shown at product and service level, categorized by posting dates. The net profit margin (in percentages) is calculated using a formula and shown in the report.

  • Value Flow

    This Query function is used to provide read data access to a traceability result report, showing the end-to-end value flow.

Procedure

Follow the steps below to see the available fields of the Query functions listed above:

  1. Expand the Reporting node in the navigation structure on the left-hand side of the screen.

  2. Choose the function that you want to open.

  3. Choose the Sheet Definition tab on the right-hand side of the screen.

  4. In the Columns and Rows sections, you can find all fields that are preconfigured for the selected report.

  5. In the Free section, the system displays all free fields that are also available for this report.