Data selection methods for dimensions

The following data selection methods are available in the Variables Wizard:

Used to initialize a dimension using...

Selection method

a formula containing several dimensions Formula

Used to initialize a dimension using...

Selection method Symbol

All values not included in the filter.

All values except from filter

all of its values All Values

non-defined values No Values

all of its values and non-defined values All or no values

a value in the hierarchy Hierarchy

a product characteristic a user-defined characteristic a subcharacteristic

Note:

The Journal Entry Number dimension cannot use the Filter, Characteristic or One value only methods.

Depending on the method chosen, you can also use the following:

• an elementary value

• a filter

• a formula

• a characteristic value Related Topics

•Hierarchies in report schedules

•Characteristics and Properties

•One Value Only method

•Filter selection method

•Formula selection method

•To remove accounts from account families

•All Values selection method

•No Value selection method

•Hierarchy selection method

3.2.4.2.1 Hierarchies in report schedules

A hierarchy is a group of dimension members organized in a manner determining the relationship between members.

Based on the access limits set, you can initialize the following hierarchies for the Reporting Unit and Original Reporting Unit dimensions:

• Dimension Builder hierarchies

Dimension Builder hierarchies can only retrieve eliminations according to the full contribution to group.

• Scope hierarchies

For hierarchies based on Account dimensions, when the schedule is run, the hierarchy retrieved is the one used in the consolidation whose schedule displays the data.

The hierarchies used for all other dimensions are hierarchies defined in the structure based on characteristics.

Note:

When you have a block that is initialized with a multi-period, the report may not work with multi-hierarchy consolidations.

The effect of selecting a Scope hierarchy

When leveraging scope hierarchies, reports can retrieve rollup calculations.

Rollup based on Reporting Unit dimension

Rollup based on Original Report-ing Unit dimension

Initialized on Scope

hierar-chy

Eliminations are posted to the direct parent

Eliminations are posted to the direct parent

Full contribution to Group Original

Report-ing Unit

dimen-sion Eliminations are posted to

the first common parent Eliminations are posted to the

first common parent Contribution by

level

Eliminations are posted to the direct parent

Eliminations are posted to the direct parent

Full contribution to Group Reporting Unit

dimension Eliminations are posted to

the first common parent Eliminations are posted to the

first common parent Contribution by

level

Related Topics

•Selecting data

To select a hierarchy

1. In the "Set Hierarchy for dimension" dialog box, select a hierarchy from the Hierarchy to be applied when schedule is run list.

2. Select a starting point from which data will be retrieved.

The starting point is the highest level node in the hierarchy.

• If you selected a Dimension Builder hierarchy, then you can only choose a starting point from within that hierarchy.

• If you selected an account or scope hierarchy, then the starting point hierarchy you select is used for reference purposes only, as the application cannot detect at this point which scope hierarchy will eventually be applied.

Note:

When the report is run using a shared starting point, you cannot select a starting point in this dialog box.

3. Select an elimination retrieval method.

Use the Retrieve eliminations option to post eliminations to either a direct or common parent. From the list, select how eliminations will be displayed when the schedule is run.

Select one of the following:

• Full contribution to Group, which retrieves the flat-list of amounts from a consolidation in a hierarchy. Elimination rows do not appear and elimination calculations are integrated into the reporting unit amounts.

• Contribution by Level, which retrieves the elimination of internal transactions between reporting units from the same hierarchy level for each reporting unit in the scope. An elimination row appears for each hierarchy node.

Note:

• Elimination rows can be retrieved only if a reporting unit rollup rule is included in the consolidation.

• This mode is not compatible with a Dimension Builder type hierarchy.

• The Contribution by level and Reference Hierarchy modes are not compatible.

Note:

If a Dimension Builder hierarchy was set or if you selected an account hierarchy, the Retrieve eliminations option is unavailable.

4. Select a multi-hierarchy retrieval mode.

Use the Retrieve multi-hierarchy option to use different hierarchical scopes for each period. Only one hierarchy can be retrieved when the schedule is run. If several hierarchies were used by several consolidations, you should choose the hierarchy to be retrieved.

Select one of the following:

• Merged Hierarchy, so that the hierarchies are merged into one hierarchy.

• Reference Hierarchy, so that the first hierarchy of the report found by the application is displayed.

If a Dimension Builder hierarchy was set, the Retrieve multi-hierarchy option is unavailable.

5. Choose a hierarchy selection mode.

The following selection modes are available:

• By hierarchy level, to select the beginning and ending hierarchy levels for which data is retrieved.

• By hierarchy link, to automatically select items based on the link with the selected starting point.

You can, for example, select all children for a starting point. You can also select a starting point and all descendants.

Note:

Contribution to parent eliminations is available when you select Contribution by level for eliminations. If you select Contribution to parent eliminations, the item and its parents' eliminations are selected and data is filtered using a Report Unit.

6. Use the View hierarchy option to specify whether the parent node is displayed before or after the