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