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.
The effect of selecting a Scope hierarchy
When leveraging scope hierarchies, reports can retrieve rollup calculations.
| Scope hierarchy | Initialized on | Rollup based on Original Reporting Unit dimension | Rollup based on Reporting Unit dimension |
|---|---|---|---|
| Original Reporting Unit dimension | Full contribution to Group | Eliminations are posted to the direct parent | Eliminations are posted to the direct parent |
| Contribution by level | Eliminations are posted to the first common parent | Eliminations are posted to the first common parent | |
| Reporting Unit dimension | Full contribution to Group | Eliminations are posted to the direct parent | Eliminations are posted to the direct parent |
| Contribution by level | Eliminations are posted to the first common parent | Eliminations are posted to the first common parent |
