Dimension Setup in Dimension Library

Set up dimensions for legal consolidation.

For the consolidation model, the dimensions listed in the tables below are mandatory requirements. Therefore, it is recommended that you verify that all the dimensions are available in the dimension library of your consolidation environment created from EnvironmentShell.

Note
Whereas the dimension names can be chosen as desired, it is mandatory that the dimension types match with the ones described below for the corresponding models.

Consolidation (MAIN) Model

Any consolidation type model must refer to a RATE and OWNERSHIP model.

The Consolidation (MAIN) model requires the following dimensions:

Dimension

Description

ACCOUNT

Members of this dimension are, for example, Revenue or Salaries.

CATEGORY

Contains the types of data you are going to track, such as Actual, Budget, and Forecast. You can also set up categories to store versions, such as BudgetV1, and BudgetV2.

Audit

Used in the business rules of a reporting consolidation model to segregate input data.

Subtable (Flow)

Breaks down account activity or flow into subunits.

Entity

Contains the business units that are used to drive the business process.

Depending on your model design, the Entity type can be for example an operating unit, a cost center, or a geographic entity.

Intco

Contains the intercompany codes for the entities.

Time

Contains the periods for which you store data.

Currency

The currency type dimension is required if the customer reports on local currency and translated values.

Groups

The group represents the relationship of entities and consolidation scopes for a given consolidation result.

Rate Model

The RATE model is delivered with EnvironmentShell. Most dimension properties required for the consolidation setup are delivered with the dimensions in the model. However, it is recommended that you verify this before proceeding further. Also you need to make sure the reporting models using the Rate model to store their foreign currency exchange rates share the same Time dimension with the Rate model.

The RATE model containing exchange rates requires the following dimensions:

Dimension

Description

ACCOUNT

This dimension is specific to RATE model. Members of this dimension are used to detail the different types of rate (for example, Average or End-of-period).

CATEGORY

Contains the types of data you are going to track, such as Actual, Budget, and Forecast. You can also set up categories to store versions, such as BudgetV1, and BudgetV2.

Entity

This is used to store multiple tables of rates, if desired; otherwise, the R_Entity dimension may just be limited to one dummy member, typically named GLOBAL. For example, if there is an entity C1000 for which a special exchange rate needs to be applied, it is defined here and the special rates are applied.

Entity is specific to and used only by a RATE model.

Time

Contains the time periods for which you store data.

Currency

This dimension is used to store each applicable local currency.
Note

Time and Category dimensions must be shared by all the models involved in consolidation.

Ownership Model

EnvironmentShell is delivered only with PLANNING and RATE models. Therefore, the OWNERSHIP model needs to be created before you can create the consolidation model. Refer to the model creation wizard to understand the steps of the creation process.

The business rule process uses an ownership type model when calculating the ultimate ownership or during the minority interest calculation. This model must be associated with a consolidation type model. The OWNERSHIP model contains the values of each consolidation parameter. In particular, such definitions may include:

  • The list of companies being consolidated in each group

  • The consolidation method for each company

  • The consolidation percentage for each company

  • Their ownership percentage (how much each company is owned by the group)

  • The control percentage (how much each company is controlled by the group)

The OWNERSHIP model storing the ownership details requires the following dimensions:

Dimension

Description

ACCOUNT

This dimension is specific to OWNERSHIP model. Members of this dimension should include METHOD (consolidation method),POWN (ownership percentage), PCON (control percentage) and PCTRL (percentage of control).

CATEGORY

Contains the types of data you are going to track, such as Actual, Budget, and Forecast. You can also set up categories to store versions, such as BudgetV1 and BudgetV2.

Entity

Contains the business units that are used to drive the business process. Depending on your model design, the Entity type can be for example an operating unit, a cost center, or a geographic entity.

Intco

Contains the intercompany codes for the entities.

Time

Contains the periods for which you store data.

Groups

The group represents the relationship of entities and consolidation scopes for a given consolidation result.

The following table indicates the dimensions required in various models:

Name

Type

MAIN

OWNERSHIP

RATE

Account (Consolidation)

A

X

    

Account (Ownership)

A

  

X

  

Account (Rate)

A

    

X

Flow

S

X

    

Category

C

X

X

X

Entity

E

X

X

  

Entity (Rate)

E

    

X

Intercompany

I

X

X

  

Time

T

X

X

X

Group

G

X

X

  

InputCurrency

R

    

X

Audit

D

X

    

Currency

R

X

    

Activities

  • Create a new dimension

    1. In the navigation panel, go to Administration and under the Modeling section, choose Dimensions.

    2. Click New.

    3. Choose a unique ID, provide a description, and select the dimension type.