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 run, the following review and reporting activities can be executed:

  • Product Net Profit Margin

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

  • Product Results by Channel

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

  • Activity Results

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

  • Profit Center Results per Region

    This Query function is used to provide read data access to the results of Mining Profitability and Cost Management at region and profit center level.

  • Review Results

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

  • Review Results Simulation

    This Query function is used to provide read data access to the final results of Mining Profitability and Cost Management at GL account level, and is used for simulation in Neo UI.

  • Value Flow

    This Query function is used to provide a graphical representation of the final results of Mining Profitability and Cost Management at resource, activity, and product and service level.

    Field Amount [TC] is shown at resource, activity, and product and service level.

    The display option Show Result Rows is set to “No” for every field in the report. The predefined layout is set to “Data Grid”. However, the purpose of the query is to show data using a Sankey diagram.

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.