Main analysis scenarios are:
To see which dimensions that can be used together with each fact in, for example, Excel pivot analysis, see sections Fact and Dimension Connections below.
Cube Fact (DSV name) | Measure Group | Referenced Information Source | BI Access View | Access Type |
FACT_CONSOL_BALANCE | CONSOLIDATION BALANCE | FACT_CONSOL_BALANCE | FACT_CONSOL_BALANCE_BI | On Line |
FACT_CONSOL_BALANCE_DETAIL* | CONSOLIDATION BALANCE DETAILS | FACT_CONSOL_BALANCE | FACT_CONSOL_BALANCE_BI | On Line |
FACT_CONSOL_PAR_BALANCE | CONSOLIDATION PARALLEL BALANCE | FACT_CONSOL_PAR_BALANCE | FACT_CONSOL_PAR_BALANCE_BI | On Line |
FACT_CONSOL_PAR_BALANCE_DETAIL* | CONSOLIDATION PARALLEL BALANCE DETAILS | FACT_CONSOL_PAR_BALANCE | FACT_CONSOL_PAR_BALANCE_BI | On Line |
FACT_CONSOL_REP_BALANCE | CONSOLIDATION PARALLEL BALANCE | FACT_CONSOL_PAR_BALANCE | FACT_CONSOL_PAR_BALANCE_BI | On Line |
FACT_CONSOL_BAL_SET_ANALYS | CONSOLIDATION BALANCE SET | FACT_CONSOL_BAL_SET_ANALYS | FACT_CONSOL_BAL_SET_ANALYS_BI | On Line |
FACT_CONSOL_BAL_SET_CONF_ANALYS* | CONSOLIDATION ANALYSIS | FACT_GL_BAL_SET_ANALYS | FACT_GL_BAL_SET_ANALYS_BI_OPT | On Line |
FACT_REPORTING_CURRENCY_RATES | CURRENCY RATES | FACT_CURRENCY_RATES | FACT_CURRENCY_RATES_BI_OPT | On Line |
* FACT_CONSOL_BAL_SET_CONF_ANALYS is based on
FACT_CONSOL_BAL_SET_ANALYS and described in the same document.
FACT_CONSOL_BALANCE_DETAIL is based on FACT_CONSOL_BALANCE and described in the
same document
FACT_CONSOL_PAR_BALANCE_DETAIL is based on
FACT_CONSOL_PAR_BALANCE and described in the same document
Each measure in the facts are described in chapter Measures. Corresponding Information Sources are described below.
Consolidated Balances information source is based on IFS/Group Consolidation. This information source can be used to design reports/analysis based on consolidated balances which are the result of the Group Consolidation process.
The information about consolidated balances can be analyzed based on consolidation structure, period, balance version, structure node, sublevel node and reporting entity etc. The analysis can be performed for the balances which resulted in different steps of the consolidation process.
Note: There are several consolidation transaction types generated during the consolidation process such as Consolidated Balances, Translated Balances, Profit Elimination, Ownership Elimination, Intercomany Elimination. Therefore, the reports should be based on the appropriate selection of consolidation transaction types. Eg: Consolidated Balance Sheet should be based on consolidation transaction type 'Consolidated Balances'. If not the balances could be duplicated.
Consolidation Reported Balances information source is based on IFS/Group Consolidation. This information source can be used to design reports/analysis based on reporting and adjustment journals that are to be used in the Group Consolidation process.
Consolidated Parallel Balances information source is based on IFS/Group Consolidation. This information source can be used to design reports/analysis based on parallel consolidated balances which are the result of Parallel Consolidation process.
The information about parallel consolidated balances can be analyzed based on consolidation structure, parallel consolidation structure, period, balance version, structure node, sublevel node and reporting entity, parallel structure node, parallel structure sub node/dimension value etc. The analysis can be performed for the balances which resulted in different steps of the parallel consolidation process.
Note: There are several consolidation transaction types generated during the Parallel Consolidation process such as Parallel Consolidated Balances, Parallel Transferred Balances, Rollback Intercompany Elimination, Parallel Dimension Elimination. Therefore, the reports should be based on the appropriate selection of consolidation transaction types. If not the balances could be duplicated.
Consolidated Balance Set Analysis information source is based on IFS/Group Consolidation. This information source can be used to design reports/analysis based on consolidated balances which are the result of the Group Consolidation process.
The consolidated balances generated as a result of the Group Consolidation process are generated as accumulated balances for a given period. Therefore, these accumulated balances should be segregated to each period by using Calculate Period Balances process before used to design reports/analysis.
The information about period consolidated balances can be analyzed based on consolidation structure, period, balance version, structure node, sublevel node and reporting entity etc. The analysis can be performed only for the period balances with the transaction type Consolidated Balances.
The report/analysis will retrieve data according to the configuration set by the BI Consolidation Balance Set Period Analysis Configuration in the IFS Applications. User can predefine which information should be retrieved to each accounting period using the BI Consolidation Balance Set Period Configuration, using the different balance versions based on budget or actual. The ETL process must also be configured to define GL Balance Sets representing measures like Actual (ACT), Budget (Bud), Current Forecast (CFC) and Next Forecast (NFC). All amounts are in base currency.
Cube Dimension | Note |
ACC ATTR ACCOUNT | Account related Accounting Attribute dimension. Requires that all companies to be analyzed have an Account related accounting attribute with an identity as defined in the Configuration tool. The identity is defined in Accounting Attr Lookup tab for Code Part Type=ACCOUNT. |
ACC ATTR CODE B | Code Part B related Accounting Attribute dimension. Requires that all companies to be analyzed have a Code B related accounting attribute with an identity as defined in the Configuration tool. The identity is defined in Accounting Attr Lookup tab for Code Part Type=CODE_B. |
ACC STRUCT BS | Balance Sheet Account related Accounting Structure dimension. Requires that all companies to be analyzed have an Account related structure with an identity as defined in the Configuration tool. The identity is defined in Accounting Struct Lookup tab for Code Part Type=ACCOUNT_BS. |
ACC STRUCT CODE B | Code Part B related Accounting Structure dimension. Requires that all companies to be analyzed have a Code B related structure with an identity as defined in the Configuration tool. The identity is defined in Accounting Struct Lookup tab for Code Part Type=CODE_B. |
ACC STRUCT IS | Income Statement Account rerlated Accounting Structure dimension. Requires that all companies to be analyzed have an Account related structure with an identity as defined in the Configuration tool. The identity is defined in Accounting Struct Lookup tab for Code Part Type=ACCOUNT_IS. |
ACCOUNT | |
ACCOUNTING PERIOD | |
BALANCE VERSION | |
BALANCE SET | This is a cube-only dimension, i.e. not supported by a standard dimension. |
CODE B | |
CODE C | |
CODE D | |
CODE E | |
CODE F | |
CODE G | |
CODE H | |
CODE I | |
CODE J | |
CODE N | |
CODE O | |
CODE P | |
CODE Q | |
CODE R | |
CODE S | |
CODE T | |
COMPANY | |
CONSOLIDATED BALANCE DETAIL FHY | Fact based dimension including hierarchy for browsing Structure ID - Balance Version ID - Year Period - Structure Node - Structure Node Sub Level |
CONSOLIDATED BALANCE DETAIL SHY | Hierarchy-only dimension for browsing Consolidation Structure Structure ID - Balance Version ID - Structure Node - Structure Node Sub Level |
CONSOLIDATED PARALLEL BALANCE DETAIL FHY | Hierarchy-only dimension used for browsing Consolidation Parallel Structure ID - Balance Version ID - Year Period - Par Structure Node - Par Structure Node Sub Level |
CONSOLIDATED PARALLEL BALANCE DETAIL SHY | Hierarchy-only dimension used for browsing Consolidation Parallel Structure ID - Balance Version ID - Par Structure Node - Par Structure Node Sub Level |
CONSOLIDATION TRANS TYPE | |
CONSOLIDATED BALANCE | This is a cube-only dimension, i.e. not supported by a standard dimension. |
CONSOLIDATION REPORTED BALANCE | This is a cube-only dimension, i.e. not supported by a standard dimension. |
COUNTERPART ONE | |
COUNTERPART TWO | |
CURRENCY | |
INTERCOMPANY ELIM RULE | |
PARALLEL STRUCTURE | |
PARALLEL STRUCTURE NODE | |
PARALLEL STRUCTURE SUB LEVEL | |
POSTING TYPE | |
REPORTING COMPANY | |
REPORTING CURRENCY | This dimension as well as the fact CURRENCY_RATES are used to support calculations in reporting currency. Please lookup more information in the fact specific documentation. Not implemented TBD |
REPORTING DATE | Time dimension based on the reporting date, i.e. the from date of the accounting period associated with a fact transaction |
REPORTING ENTITY | |
REPORTING TRANS TYPE | |
STRUCTURE | |
STRUCTURE NODE | |
STRUCTURE NODE SUB LEVEL |
The Group Consolidation cube is designed to use only one master company which means that it is necessary configure a specific master company to be used by this cube. The created/selected identity must also be defined in the configuration Consolidation Master Company. Config should be made for record IFS_BI_GroupConsolidation_Orig. The configuration tools has been prepared to set up three different cubes using records IFS_BI_GroupConsolidation_Alt1 and _Alt2 for additional cubes.
Configurations for Accounting Structures and - Attributes are made in tabs Consol Accounting Struct Lookup and - Attr Lookup respectively.
The cube supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined. TBD if implemented
Please refer technical documentation for more informtation.
The cube is limited to use only one master company. See previous section.
Combinations of facts and dimensions that do not match will not give any results (See chapter Fact and Dimension Connections).
The following picture shows how different facts in the cube are connected to the available dimensions.
Aggregation of measures is based on SUM if not explicitly noted.
Balances/Amounts do not include Period 0 or periods >12. These are only visible using measure Balance Orig. It can be chosen whether to use Reverse Income Statement balances for Cost and Revenue accounts. In this case db-column Balance_RIS is used. This setting is done in SSIS Config Utility per Fact table. This behaviour is common for all balances and amounts.
Note!
All measures are described in Node Currency Amounts if nothing else
stated. Other types of measures are Group Currency, GC or Currency amounts,
using suffix Curr.
This sections describes the basic measures in the cube. These are either measures defined in the core Information Source or in the ETL process. The columns have the following meaning:
Measure | Measure Group |
Core Measure | ETL Measure |
Cube Measure |
Measure Expression | Reporting Currency Measure |
Aggregated Method | Note |
Balance YTD | CONSOLIDATION BALANCE | NO | NO | YES | NO | NO | SUM | Balance |
Deb Balance YTD | CONSOLIDATION BALANCE | YES | NO | NO | NO | NO | SUM | |
Cred Balance YTD | CONSOLIDATION BALANCE | YES | NO | NO | NO | NO | SUM | |
Curr Balance YTD | CONSOLIDATION BALANCE | YES | NO | NO | NO | NO | SUM | |
Balance YTD OB | CONSOLIDATION BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. |
Balance OBY | CONSOLIDATION BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Only used in calculations. Hidden. |
Curr Balance YTD OB | CONSOLIDATION BALANCE | NO | YES | YES | NO | NO | SUM | Year Opening Curr Balance. Only used in calculations. Hidden. |
Curr Balance OBY | CONSOLIDATION BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Curr Balance. Only used in calculations. Hidden. |
Balance GC | CONSOLIDATION BALANCE | NO | NO | YES | YES | YES | SUM | Balance in group currency. |
Deb Balance YTD GC | CONSOLIDATION BALANCE | YES | NO | NO | NO | NO | SUM | |
Cred Balance YTD GC | CONSOLIDATION BALANCE | YES | NO | NO | NO | NO | SUM | |
Balance OBY GC | CONSOLIDATION BALANCE | NO | YES | NO | YES | YES | SUM | Balance OBY in group currency. Only used in calculations. Hidden. |
Count Consolidation Balance | CONSOLIDATION BALANCE | NO | NO | YES | NO | NO | COUNT | Count of records |
Par Balance YTD | CONSOLIDATION PARALLEL BALANCE | NO | NO | YES | NO | NO | SUM | Par Balance |
Par Balance OBY | CONSOLIDATION PARALLEL BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Only used in calculations. Hidden. |
Par Curr Balance YTD | CONSOLIDATION PARALLEL BALANCE | NO | NO | YES | NO | NO | SUM | Par Balance Currency Amount |
Par Curr Balance OBY | CONSOLIDATION PARALLEL BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Par Balance Currency Amount.Only used in calculations. Hidden. |
Par Balance YTD GC | CONSOLIDATION PARALLEL BALANCE | NO | NO | YES | YES | YES | SUM | Balance in group currency. |
Par Balance OBY GC | CONSOLIDATION PARALLEL BALANCE | NO | YES | NO | YES | YES | SUM | Balance OBY in reporting currency. Only used in calculations. Hidden. |
Count Consolidation Par Balance | CONSOLIDATION PARALLEL BALANCE | NO | NO | YES | NO | NO | COUNT | Count of records |
Rep Balance YTD | CONSOLIDATION REPORTED BALANCE | NO | NO | YES | NO | NO | SUM | Rep Balance |
Rep Debit Balance YTD | CONSOLIDATION REPORTED BALANCE | YES | NO | NO | NO | NO | SUM | |
Rep Credit Balance YTD | CONSOLIDATION REPORTED BALANCE | YES | NO | NO | NO | NO | SUM | |
Rep Balance OBY | CONSOLIDATION REPORTED BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Only used in calculations. Hidden. |
Rep Curr Balance YTD | CONSOLIDATION REPORTED BALANCE | NO | NO | YES | NO | NO | SUM | Rep Balance Transaction Currency |
Rep Curr Balance OBY | CONSOLIDATION REPORTED BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Only used in calculations. Hidden. |
Count Consolidation Rep Balance | CONSOLIDATION REPORTED BALANCE | NO | NO | YES | NO | NO | COUNT | Count of records |
BS Balance | CONSOLIDATION BALANCE SET | NO | NO | YES | NO | NO | SUM | BS Balance |
BS Balance Orig | CONSOLIDATION BALANCE SET | YES | NO | NO | NO | NO | SUM | BS Balance Orig |
BS Balance OBY | CONSOLIDATION BALANCE SET | NO | YES | NO | NO | NO | SUM | Year Opening BS Balance. Only used in calculations. Hidden. |
Count Consolidation Balance Set | CONSOLIDATION BALANCE SET | NO | NO | YES | NO | NO | COUNT | Count of records |
BS Balance Curr | CONSOLIDATION BALANCE SET | NO | NO | YES | NO | NO | SUM | BS Balance Currency Amount |
BS Balance Orig Curr | CONSOLIDATION BALANCE SET | YES | NO | NO | NO | NO | SUM | BS Balance Orig Currency Amount |
BS Balance OBY Curr | CONSOLIDATION BALANCE SET | NO | YES | NO | NO | NO | SUM | Year Opening BS Balance Currency Amount. Only used in calculations. Hidden. |
BS Balance GC | CONSOLIDATION BALANCE SET | NO | NO | YES | NO | NO | SUM | BS Balance Group Currency |
BS Balance Orig GC | CONSOLIDATION BALANCE SET | YES | NO | NO | NO | NO | SUM | BS Balance Orig Group Currency |
BS Balance OBY GC | CONSOLIDATION BALANCE SET | NO | YES | NO | NO | NO | SUM | Year Opening BS Balance Group Currency. Only used in calculations. Hidden. |
Act (Actual) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | Act |
Act Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | Act Orig |
Act OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening Act. Only used in calculations. Hidden. |
Act RC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | Act in reporting currency. |
Act OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Act OBY in Group currency. Only used in calculations. Hidden. |
Act Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | Act Currency Amount |
Act OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening Act, Currency Amount. Only used in calculations. Hidden. |
Bud (Budget) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | Bud |
Bud Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | Bud Orig |
Bud OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening Bud. Only used in calculations. Hidden. |
Bud GC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | Bud in Group currency. |
Bud OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Bud OBY in Group currency. Only used in calculations. Hidden. |
Bud Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | Bud, Currency Amount |
Bud OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening Bud, Currency Amount. Only used in calculations. Hidden. |
CFC(Current Forecast) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | CFC |
CFC Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | CFC Orig |
CFC OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening CFC. Only used in calculations. Hidden. |
CFC GC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | CFC in Group currency. |
CFC OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | CFC OBY in Group currency. Only used in calculations. Hidden. |
CFC Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | CFC, Currency Amount |
CFC OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening CFC, Currency Amount. Only used in calculations. Hidden. |
NFC (Next Forecast) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | NFC |
NFC Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | NFC Orig |
NFC OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening NFC. Only used in calculations. Hidden. |
NFC GC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | NFC in Group currency. |
NFC OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | NFC OBY in Group currency. Only used in calculations. Hidden. |
NFC Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | NFC, Currency Amount |
NFC OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening NFC, Currency Amount. Only used in calculations. Hidden. |
X1 (Extra measure1) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | X1 |
X1 Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | X1 Orig |
X1 OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening X1. Only used in calculations. Hidden. |
X1 GC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | X1 in Group currency. |
X1 OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | X1 OBY in Group currency. Only used in calculations. Hidden. |
X1 Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | X1, Currency Amount |
X1 OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening X1, Currency Amount. Only used in calculations. Hidden. |
X2 (Extra measure2) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | X2 |
X2 Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | X2 Orig |
X2 OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening X2. Only used in calculations. Hidden. |
X2 GC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | X2 in Group currency. |
X2 OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | X2 OBY in Group currency. Only used in calculations. Hidden. |
X2 Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | X2, Currency Amount |
X2 OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening X2, Currency Amount. Only used in calculations. Hidden. |
X3 (Extra measure2) | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | X3 |
X3 Orig | CONSOLIDATION ANALYSIS | YES | NO | NO | NO | NO | SUM | X3 Orig |
X3 OBY | CONSOLIDATION ANALYSIS | NO | YES | NO | NO | NO | SUM | Year Opening X3. Only used in calculations. Hidden. |
X3 GC | CONSOLIDATION ANALYSIS | NO | NO | YES | YES | YES | SUM | X3 in Group currency. |
X3 OBY GC | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | X3 OBY in Group currency. Only used in calculations. Hidden. |
X3 Curr | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | SUM | X3, Currency Amount |
X3 OBY Curr | CONSOLIDATION ANALYSIS | NO | YES | NO | YES | YES | SUM | Year Opening X3, Currency Amount. Only used in calculations. Hidden. |
Count Consolidation Analysis | CONSOLIDATION ANALYSIS | NO | NO | YES | NO | NO | COUNT | Count of records |
Det Balance YTD | CONSOLIDATION BALANCE DETAILS | NO | NO | YES | NO | NO | SUM | Balance |
Det Debit Balance YTD | CONSOLIDATION BALANCE DETAILS | YES | NO | NO | NO | NO | SUM | |
Det Credit Balance YTD | CONSOLIDATION BALANCE DETAILS | YES | NO | NO | NO | NO | SUM | |
Curr Balance YTD | CONSOLIDATION BALANCE DETAILS | YES | NO | NO | NO | NO | SUM | Currency Amount Balance |
Det Balance OBY | CONSOLIDATION BALANCE DETAILS | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Only used in calculations. Hidden. |
Det Curr Balance YTD | CONSOLIDATION BALANCE DETAILS | NO | YES | YES | NO | NO | SUM | Year Opening Currency Amount. Only used in calculations. Hidden. |
Det Curr Balance OBY | CONSOLIDATION BALANCE DETAILS | NO | YES | NO | NO | NO | SUM | Year Opening Currency Amount. Only used in calculations. Hidden. |
Det Balance YTD GC | CONSOLIDATION BALANCE | NO | NO | YES | YES | YES | SUM | Balance in group currency. |
Det Debit Balance YTD GC | CONSOLIDATION BALANCE DETAILS | YES | NO | NO | NO | NO | SUM | |
Det Credit Balance YTD GC | CONSOLIDATION BALANCE DETAILS | YES | NO | NO | NO | NO | SUM | |
Det Balance OBY GC | CONSOLIDATION BALANCE DETAILS | NO | YES | NO | YES | YES | SUM | Balance OBY in group currency. Only used in calculations. Hidden. |
Count Consolidation Balance | CONSOLIDATION BALANCE DETAILS | NO | NO | YES | NO | NO | COUNT | Count of records |
Det Par Balance YTD | CONSOLIDATION PARALLEL BALANCE | NO | NO | YES | NO | NO | SUM | Par Balance |
Det Par Balance OBY | CONSOLIDATION PARALLEL BALANCE | NO | YES | NO | NO | NO | SUM | Year Opening Balance. Only used in calculations. Hidden. |
Det Curr Par Balance YTD | CONSOLIDATION PARALLEL BALANCE DETAILS | NO | NO | YES | NO | NO | SUM | Par Balance Currency Amount |
Det Curr Par Balance OBY | CONSOLIDATION PARALLEL BALANCE DETAILS | NO | YES | NO | NO | NO | SUM | Year Opening Balance Currency Amount. Only used in calculations. Hidden. |
Det Par Balance YTD GC | CONSOLIDATION PARALLEL BALANCE DETAILS | NO | NO | YES | YES | YES | SUM | Balance in group currency. |
Det Par Balance OBY GC | CONSOLIDATION PARALLEL BALANCE DETAILS | NO | YES | NO | YES | YES | SUM | Balance OBY in reporting currency. Only used in calculations. Hidden. |
Count Consolidation Par Balance Detail | CONSOLIDATION PARALLEL BALANCE DETAILS | NO | NO | YES | NO | NO | COUNT | Count of records |
Plan Amount Curr | BUSINESS PLANNING | NO | YES | NO | NO | NO | SUM | Planning Currency Amount |
Plan Amount OBY Curr | BUSINESS PLANNING | NO | YES | NO | NO | NO | SUM | Opening Year Balance Planning Currency Amount. Only used in calculations. Hidden |
Plan Amount OB Curr | BUSINESS PLANNING | NO | NO | YES | NO | NO | SUM | Opening Balance Planning Currency Amount. |
Plan Amount Avg Curr | BUSINESS PLANNING | NO | NO | YES | NO | NO | AVG | Average Planning Currency Amount. Calculated as Planning Amount / Number of periods. |
Plan Amount PlanRC | BUSINESS PLANNING | NO | YES | NO | NO | NO | SUM | Planning Amount in Planned Reporting Currency |
Plan Amount OBY PlanRC | BUSINESS PLANNING | NO | YES | NO | NO | NO | SUM | Opening Year Balance Planning Amount in Planned Reporting Currency. Only used in calculations. Hidden |
Plan Amount AC | BUSINESS PLANNING | NO | YES | NO | NO | NO | SUM | Planning Amount in Accounting Currency |
Plan Amount OBY AC | BUSINESS PLANNING | NO | YES | NO | NO | NO | SUM | Opening Year Balance Planning Amount in Accounting Currency. Only used in calculations. Hidden |
Plan Amount OB AC | BUSINESS PLANNING | NO | NO | YES | NO | NO | SUM | Opening Balance Planning Amount in Accounting Currency. |
Plan Amount Avg AC | BUSINESS PLANNING | NO | NO | YES | NO | NO | AVG | Average Planning Amount in Accounting Currency. Calculated as Planning Amount / Number of periods. |
Plan Amount RC | BUSINESS PLANNING | NO | YES | NO | YES | YES | SUM | Planning Amount in Reporting Currency |
Plan Amount OBY RC | BUSINESS PLANNING | NO | YES | NO | YES | YES | SUM | Opening Year Balance Planning Amount in Reporting Currency. Only used in calculations. Hidden |
Plan Amount OB RC | BUSINESS PLANNING | NO | NO | YES | NO | YES | SUM | Opening Balance Planning Amount in Reporting Currency. |
Plan Amount Avg RC | BUSINESS PLANNING | NO | NO | YES | NO | YES | AVG | Average Planning Amount in Reporting Currency. Calculated as Planning Amount / Number of periods. |
Count Business Planning | BUSINESS PLANNING |
NO | NO | YES | NO | NO | COUNT | Count of records |
Currency Rate | CURRENCY RATES | YES | YES | NO | NO | NO | SUM | Currency rate used to calculate amounts to reporting currency. The core measure is modified in ETL |
Calculated measures are in the cube calculated with respect to other measures. The table below defines the general meaning/definition of each calculated measure.
Measure | Meaning |
Diff <amount> - Budget <amount> | <amount> Balance - Budget <amount> |
% Diff of Budget (<amount>) | (<amount> Balance - Budget <amount>)/abs(Budget <amount>) |
Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of the different time measures. These measures need to be used with a specific time dimension hierarchy defined in the table below.
Measure | Meaning |
YTD | Aggregated value for current period in current accounting year. E.g.
for period 201210 YTD represents sum of periods 201201-201210. Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
YTD Avg | Average aggregated value for current period in current accounting year. E.g.
for period 201210 YTD Avg represents sum of periods 201201-201210 /
number of periods 201201-201210 e.g.10 periods Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
R12 - Rolling 12 | For a given period, the sum all periods from one year back up to the
current period. E.g. Rolling 12 for 201210 is the sum of periods 201111
- 201210 Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
PY - Previous Year | The value of the corresponding period one year back. E.g. for period
201210, the value of period 201110. Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
YTD PY - YTD Previous Year | Aggregated value for corresponding period one year back. E.g. for
period 201210 YTD Previous Year represents sum of periods 201101-201110. Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
YTD Avg PY - YTD Average Previous Year | Average Aggregated value for corresponding period one year back.
E.g. for period 201210 YTD Previous Year represents sum of periods
201101-201110 / number of periods 201101-201110 e.g.10 periods Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
R12 PY - Rolling 12 Previous Year | For a given period, first going one year back, then taking the sum
all periods from one (more) year back up to the previous period. E.g.
for period 201210 the sum of period 201011-201110 Based on hierarchies [REPORTING DATE].[RepAccPerFHy] or [RepAccPerSHy]. |
This section lists dashboards and reports in the example content for the BI Analysis Package that is using this cube:
UI Name | Type |
Income Statement | Excel Dashboard |
Actuals vs Budget by Accounting Period and Account | Report |
The BI specific and also related core components listed in this section are required, i.e. they must along with other dependent components, be part of the customer installation to successfully use this cube.
NOTE that only directly used components are listed. Each such component can have its own list of dependent components. Please refer to the Component Deployment Profile File for each component to get the full picture.
Component | Type | Component Name | Product |
APTOOL | BI | Common scripts and utilities, BI Anapac | Business Intelligence |
APPSDI | BI | Application Services Analysis Package Dimension | Business Intelligence |
ENTEDI | BI | Enterprise Analysis Package Dimensions | Business Intelligence |
ACCRDI | BI | Accounting Rules Analysis Package Dimensions | Business Intelligence |
ACCRFT | BI | Accounting Rules Analysis Package Facts | Business Intelligence |
GENLDI | BI | General Ledger Analysis Package Dimensions | Business Intelligence |
GROCOC | BI | Group Consolidation Cube | Business Intelligence |
GROCDI | BI | Group Consolidation Dimensions | Business Intelligence |
GROCFT | BI | Group Consolidation Facts | Business Intelligence |
ENTERP | CORE | Enterprise | Financials |
GROCON | CORE | Group Consolidation | Financials |
ACCRUL | CORE | Accounting Rules | Financials |
GENLED | CORE | General Ledger | Financials |
Note: BI Component used will be GROCOC