Cube - General Ledger

Contents

• Usage/Purpose
• Overview Facts
• Overview Dimensions
• Configurations
• Limitations
• Fact and Dimension Connections
• Included Example Reports and Dashboards
• Measures
• Required Components

Usage/Purpose

Main analysis scenarios are:

• Actual values for Income Statement and Balance Sheet
•  Actual values compared to budgets, forecasts, previous years etc
• New forecast compared to actuals, previous budgets and forecasts
• Multi company analysis in a selected common currency
• Details from underlying transactions

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

* FACT_GL_BAL_SET_CONF_ANALYS is based on FACT_GL_BAL_SET_ANALYS and described in the same document.

Each measure in the facts are described in chapter Measures. Corresponding Information Sources are described below.

General Ledger Balance

General Ledger Balance Information Source is based on acconting balances in IFS/General Ledger. This Information Source can be used to design reports based on general ledger balances in accounting currency, transaction currency, and reporting currency for any accounting period, account and/or code parts. Quantity analysis based on accounts and code parts can also be performed. Detailed balance analysis can be carried out based on projects as well.

• General ledger balance analysis
• Profit and loss statement (yearly/period-wise)
• Balance sheet (yearly/period-wise)

General Ledger Period Budget

General Ledger Period Budget Information Source is based period budget in IFS/General Ledger. This information source can be used to design reports based on general ledger periodic budget amounts in accounting currency and reporting currency with quantities for any budget version. Analysis can be extended to include accounts and other code parts including projects.

• Used in combination with GL Balance Information Source for Variance Analysis

General Ledger Project Balance

General Ledger Project Balance information source is based on project balances in IFS/General Ledger. This Information Source can be used to design reports based on general ledger project balances in accounting currency, transaction currency, and reporting currency with or without quantity balances for any accounting period for each accounting project. Reports can be further analyzed based on accounts and other code parts.

• Project balance analysis
• Structure project analysis
• Project balance report
• Multi-company project balance analysis

General Ledger Transaction

General Ledger Transaction Information Source is based transactions in IFS/General Ledger. This Ínformation Source can be used to design reports based on general ledger transactions in accounting currency, transaction currency and third currency for any accounting period. These amounts can be analyzed based on accounting periods, accounts, code parts, journal numbers, voucher types and voucher numbers etc.

• General Ledger transaction report (per account/account group/year period/code parts/voucher types/currency)
• General Ledger voucher details analysis
• Multi-company GL transaction report
• Multi-company voucher analysis
• Journal report
• Profit and loss statement (yearly/period-wise)
• Balance sheet (yearly/period-wise)

General Ledger Balance Set Analysis

This Information Source is based on Budget Process transactions, GL Period Budget transactions and GL Balances. GL Balance Sets are defined and configured in IFS Applications, defining the source to affect a given period in an accounting year. 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

Configurations

The General Ledger cube is using the Company Reporting Period dimension, which means that it is necessary to create a specific Reporting Period Definition to be used by this cube. The created/selected identity must also be defined in the lookup configuration for the ETL process, using Source = 'Financials'. It is also necessary to define a master company that represents the Accounting Period calendar to be used.

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.

Please refer technical documentation for more informtation.

Limitations

The cube is also using Accounting Structures. The identities to use are predefined and cannot in the version be configured.

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.

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:

• Core Measure: A measure that has its origin in a core Information Source
• ETL Measure: A measures defined the the ETL process, in most cases by using existing core measures as input.
• Cube Measure: A measure specifically defined in the cube, e.g. count of rows etc.
• Measure Expression: Specifies if a measure expression has been used in the cube to modify a general measure. One special case is amounts calculated in Reporting Currency, where a basic measure is divided by the Currency Rate from the fact REPORTING CURRENCY RATES. This means that by using a filter on dimension REPORTING CURRENCY dimension, it is possible to present amounts in different companies in a common currency. For facts used by the General Ledger cube the currency rate is retrieved based on the from date of the accounting period for the transaction/balance.
• Reporting Currency Measure: Specifies if a measure supports presentation in reporting currency.

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.

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.

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:

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.

Note: BI Component used will be GLPNLC

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: