4.1.6.2.4.1 Working with Financial Statement Reporting Lines

The default canvas view displays all the FE’s under the “Financial Statement” canvas prompt filter, hence all the balances available in each of the canvas charts are showing the cumulative value of the balances across all the available FE’s.

Therefore, to perform a correct analysis, you should select a single FE Reporting Line that you want to use for your analysis.

You can either select a single FE Reporting Line via the “Financial Statement” canvas prompt filter (option “A”) or use the left-hand side “Select Financial Statements Metric” chart on the “Financial Element Leaf Name” column (option “B”).

Figure 4-117 FE Reporting Line selection Option “A”

Figure 4-118 FE Reporting Line Selection Option “B”

You can use a series of Report Prompts, as previously described, to filter the data according to key attributes pertaining to the underlying Management Ledger data.

The report displays the underlying management ledger data according to the following Charts’ logic:

• Select Sigma Value for STD Deviation: The chart provides you with a selection capability for the desired Sigma value to be used by the STD Deviation, the possible selection values are “Attributes.Sigma Factor 1”, “Attributes.Sigma Factor 2”, and “Attributes.Sigma Factor 3”.
• Select Org Unit Hierarchy level: The chart provides you with a selection capability for the desired Org Unit Hierarchical level.
• Select Product Hierarchy level: The chart provides you with a selection capability for the desired Product Hierarchical level.
• Select Financial Statements Metric: The chart provides you with a selection capability for the desired Financial Element reporting line. The Financial Element Leaf Name is the actual data on which the reporting is based whereas the chart provides with the parent levels for ease of finding out the Financial Element Leaf member.
  The columns displayed in the chart are the following:

  • Financial Element Level 1 Name
  • Financial Element Level 2 Name
  • Financial Element Level 3 Name
  • Financial Element Leaf Name
• Legal Entity Balance by Selected Financial Statements Metric trends: This chart deduces if a Financial data (that is the Functional Balance of a Financial Element Leaf Name) is a “Outlier” or “Non-Outlier” for a combination of As-of-Date, Currency (transaction currency) and Legal Entity. The columns displayed in the chart are the following:
  • Currency Code
  • Legal Entity Leaf Name
  • As Of Date
  • Financial Statement Outlier
  • Functional Balance
• Org Unit Hierarchy Balance by Selected Financial Statements Metric trends: This chart deduces if a Financial data (that is the Functional Balance of a Financial Element Leaf Name) is a “Outlier” or “Non-Outlier” for a combination of As-of-Date, Currency (transaction currency) and Org Unit (the Org Unit display is based on the Org Unit Hierarchy level you’re analyzing).
  The columns displayed in the chart are the following:

  • Currency Code
  • Org Unit Hierarchy
  • As Of Date
  • Financial Statement Outlier
  • Functional Balance
• Product Hierarchy Balance by Selected Financial Statements Metric trends: This chart deduces if a Financial data (that is the Functional Balance of a Financial Element Leaf Name) is a “Outlier” or “Non-Outlier” for a combination of As-of-Date, Currency (transaction currency) and Product (the Product display is based on the Product Hierarchy level you’re analyzing).
  The columns displayed in the chart are the following:

  • Currency Code
  • Product Hierarchy
  • As Of Date
  • Financial Statement Outlier
  • Functional Balance
• Account Currency Balance by Selected Financial Statements Metric trends: This chart deduces if a Financial data (that is the Functional Balance of a Financial Element Leaf Name) is a “Outlier” or “Non-Outlier” for a combination of As-of-Date and Account Currency (transaction currency).
  The columns displayed in the chart are the following:

  • Currency Code
  • As Of Date
  • Financial Statement Outlier
  • Functional Balance