7.1.6.1.8 Rates by KPDs

The “Rates by KPDs” Report provides the Cash Flow Output processes results related to the Rates measurements, you can drill down and roll up the results across hierarchies for the Key Processing Dimensions of Org Unit, Product, GL Account and Common COA.

You can use a series of Report Prompts, as previously described, to filter the data according to key attributes pertaining to the underlying Cash Flow Output results.

The report displays the underlying data according to the following Chart’ logic:

• Select Rate measurementThe chart provides you with a selection capability on the desired Cashflow Rate measurement.

• Select Org Unit HierarchyThe chart provides you with a selection capability for the desired Org Unit Hierarchical level.

• Select Product HierarchyThe chart provides you with a selection capability for the desired Product Hierarchical level.

• Select GL Account HierarchyThe chart provides you with a selection capability for the desired GL Account Hierarchical level.

• Select COA HierarchyThe chart provides you with a selection capability for the desired Common COA Hierarchical level.

• Selected Rate by Org UnitThe chart reports the generated Cashflow output Rate by Org Unit for each Cash Flow Output execution with respect to As of Date and Cash Flow Date (Month).

  The columns displayed in the chart are the following:

  • Legal Entity Leaf Name
  • Cashflow Process Name
  • Execution Run Identifier
  • As Of Date (Day)
  • Currency Name
  • Org Unit Hierarchy
  • Cash Flow Date (Month)
  • Rate

• Selected Rate by ProductThe chart reports the generated Cashflow output Rate by Product for each Cash Flow Output execution with respect to As of Date and Cash Flow Date (Month).

  The columns displayed in the chart are the following:

  • Legal Entity Leaf Name
  • Cashflow Process Name
  • Execution Run Identifier
  • As Of Date (Day)
  • Currency Name
  • Product Hierarchy
  • Cash Flow Date (Month)
  • Rate

• Selected Rate by GL Account

  The chart reports the generated Cashflow output Rate by GL Account for each Cash Flow Output execution with respect to As of Date and Cash Flow Date (Month).

  The columns displayed in the chart are the following:

  • Legal Entity Leaf Name
  • Cashflow Process Name
  • Execution Run Identifier
  • As Of Date (Day)
  • Currency Name
  • GL Account Hierarchy
  • Cash Flow Date (Month)
  • Rate

• Selected Rate by Common COA

  The chart reports the generated Cashflow output Rate by Common COA for each Cash Flow Output execution with respect to As of Date and Cash Flow Date (Month).

  The columns displayed in the chart are the following:

  • Legal Entity Leaf Name
  • Cashflow Process Name
  • Execution Run Identifier
  • As Of Date (Day)
  • Currency Name
  • COA Hierarchy
  • Cash Flow Date (Month)
  • Rate

Figure 7-126 “Rates by KPDs” Report