GL - Cash Ratio
This KPI provides the following default drill paths:
-
GL chart
-
division
-
territory
The metricA measure used to assess performance in a key area of a business. rank values displayed in the KPI History and KPI Definition screens is the aggregated value of the first item for the first drill path only. Additionally, displayed rank-based metric values in these screens are not applicable.
To viewA set of data connected to a cube, deliberately laid out to communicate business information. the actual values for each KPI drill path, click History, select a snapshot date, and click Drill Down.
The displayed value of each metric is an aggregation of the data, up to the viewed levelIn a hierarchy, a level indicates a group of common or related members. For example, in a Time level, members may include Year, Month, Day or Fiscal Year, Calendar Year, etc. of the selected drill path, as of the As At snapshot date.
| Metric | Definition |
|---|---|
|
The actual parameters making up the ratios are as defined in the specified GL hierarchyIn Analytics Dashboards, regular dimensions contain descriptive and business key information and this information is organised into a hierarchy; from it's highest level of granularity, to its lowest. The hierarchy contains multiple levels. For example, a hierarchy that has three levels such as "All Products", "Product Group", and "Products".. The formula for the cash ratio is:
|
|
|
OB - Cash Ratio |
The cash ratio opening balanceopening balance at the start of the current financial year. |
|
MTD - Cash Ratio |
The cash ratio end mtdon the last day of the current financial period. |
|
YTD - Cash Ratio |
The cash ratio end ytdon the last day of the current financial year. |
|
QTR - Cash Ratio |
The cash ratio end quarteron the last day of the current financial quarter. |
|
HY - Cash Ratio |
The cash ratio end half yearon the last day of the current financial half year. |
|
LY MTD - Cash Ratio |
The cash ratio end ly mtdon the last day of the same period of the previous financial year. |
|
LY YTD - Cash Ratio |
The cash ratio end ly ytdon the last day of the previous financial year. |
|
LY QTR - Cash Ratio |
The cash ratio end ly qtron the last day of the same quarter of the previous financial year. |
|
LY HY - Cash Ratio |
The cash ratio end ly hyon the last day of the same half year of the previous financial year. |
|
LY Full Year - Cash Ratio |
The cash ratio end ly ytdon the last day of the previous financial year. |
|
OB - Cash |
The cash opening balanceopening balance at the start of the current financial year |
|
MTD - Cash |
The cash end mtdon the last day of the current financial period. |
|
YTD - Cash |
The cash end ytdon the last day of the current financial year. |
|
QTR - Cash |
The cash end quarteron the last day of the current financial quarter. |
|
HY - Cash |
The cash end half yearon the last day of the current financial half year. |
|
LY MTD - Cash |
The cash end ly mtdon the last day of the same period of the previous financial year. |
|
LY YTD - Cash |
The cash end ly ytdon the last day of the previous financial year. |
|
LY QTR - Cash |
The cash end ly qtron the last day of the same quarter of the previous financial year. |
|
LY HY - Cash |
The cash end ly hyon the last day of the same half year of the previous financial year. |
|
LY Full Year - Cash |
The cash end ly ytdon the last day of the previous financial year. |
|
OB - Current Liabilities |
The current liabilities opening balanceopening balance at the start of the current financial year. |
|
MTD - Current Liabilities |
The current liabilities end mtdon the last day of the current financial period. |
|
YTD - Current Liabilities |
The current liabilities end ytdon the last day of the current financial year. |
|
QTR - Current Liabilities |
The current liabilities end quarteron the last day of the current financial quarter. |
|
HY - Current Liabilities |
The current liabilities end half yearon the last day of the current financial half year. |
|
LY MTD - Current Liabilities |
The current liabilities end ly mtdon the last day of the same period of the previous financial year. |
|
LY YTD - Current Liabilities |
The current liabilities end ly ytdon the last day of the previous financial year. |
|
LY QTR - Current Liabilities |
The current liabilities end ly qtron the last day of the same quarter of the previous financial year. |
|
LY HY - Current Liabilities |
The current liabilities end ly hyon the last day of the same half year of the previous financial year. |
|
LY Full Year - Current Liabilities |
The current liabilities end ly ytdon the last day of the previous financial year. |
