Cube - Group Consolidation

Contents

Usage/Purpose

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.

Overview Facts

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

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

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

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

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.

Overview Dimensions

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  

Configurations

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.

Limitations

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).

Fact and Dimension Connections

The following picture shows how different facts in the cube are connected to the available dimensions.

Measures

General

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.

Basic Measure

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

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

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].

Included Example Reports and Dashboards

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

Required Components

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