Group Dimension Properties

The group-type dimension represents the relationship of entities for a given consolidation result.

This group is consolidated in a single currency, so there is no need to have another dimension. You can continue to use the currency-type dimension for this purpose or you can split it into a group-type dimension (type G) and use a pure currency-type dimension (type R) to allow reporting in multiple group currencies.

A group dimension must be assigned to an ownership and a consolidation model. You should assign both a currency and a group dimension to a consolidation model but you should assign only the group dimension to the ownership model referred from the consolidation model. You cannot assign both a currency and a group dimension to the same ownership model.

Property Name

Description

CONSO_TYPE

Specifies which set of rules to apply to a group. Refers to group type filter in Adjustments and Eliminations.

CURRENCY_TYPE

Used for the currency conversion.

  • N - Non-group

  • G - Group

DATASRC_LEVEL

Stores the consolidation differences resulting from different % or methods along the group hierarchy

ENTITY

Blank or a valid entity ID. This is used to define the link between the Group and the Entity or to indicate the Entity where the aggregation should be stored.

If this property is filled with a valid entity ID, and the property STORE_ENTITY is set to Y, the results of the currency conversion for the current Group are also copied into this Entity. (Length = 20)

GROUP_CURRENCY

This can be any valid reporting currency, and is used for currency conversion.

This property can only be used on Currency members with the property CURRENCY_TYPE of G and, in this case, it must contain a valid ID from the Currency dimension with the property CURRENCY_TYPE value of R. (Length = 20)

PARENT_GROUP

Must be a valid ID from the Groups dimension. If you want to do the consolidation by level, you must indicate here the higher level from the group. If you want to use this property to define the hierarchy, enter the same code as the ID for your top group. If this property is blank, the dynamic hierarchy from the ownership application is used. (Length = 20)

STAGE_ONLY

-

STORE_ENTITY

Specifies whether to store the ID entered in the Entity property.

Y - If you want to store the ID entered in the Entity property.

Blank - If you do not want to store the ID entered in the Entity property.

STORE_GROUP_CURR

Used for currency conversion.

Y - By default the results of the conversion into a Group currency are written in both the Group member and in the Currency member of the currency dimension.

N (or blank) - If only the Group member is to be stored, set this property to N. (Length = 1)
More Information