7.1.8.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 7-166 FE Reporting Line selection Option “A”
Figure 7-167 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