Entity Dimension Properties

The entity dimension defines the organizational structure of the business units for your model and how the units aggregate.

Any dimension that is assigned the type E is an entity dimension. Each model can have only one entity-type dimension.

An entity dimension has the following required properties:

Property Name

Description

CURRENCY

The currency used by the entity.

CTRL_CURRENCY_NOT_LC

Specifies the Reporting Currency dimension member against which a data control is performed. A control is an individual check for data accuracy and consistency. Controls are enabled or disabled at the model level.

The following are valid values:

  • Y - The generic LC (local currency) member is used.

  • N - The entity currency property is used, for example, EUR. This can be used when loading pre-translated data from a source system where currency translation has already been performed.

If no value is set, the default value is Y.

For more information, see Controls.

CONTROL_LEVEL

Specifies the controls that are relevant to an entity when a control set (a group of controls) is executed.

The following are valid values:

  • Level 1 - Basic controls

  • Level 2 - Standard controls

  • Level 3 - Advanced controls

  • Level 4 - Comprehensive controls

If 4 is selected, all controls having a level from 1 to 4 are executed. If blank or 0, no control is applicable.

For more information, see Controls.

The following properties are required only if the entity dimension is used in a consolidation model.

Property Name

Description

ELIM

Defines whether the entity is used to store the intercompany elimination for a given node in the hierarchy. Valid values are Y or N.

FX_TYPE

Defines the subset of Currency Conversion rules to apply to the entity, where FX_TYPE matches the Entity FX Type property of the rules.

INTCO

Defines the corresponding intercompany member for an entity.

More Information