Show TOC

Calculate Parents in HierarchiesLocate this document in the navigation structure

For simulation purposes, you can perform a sum on each parent in the hierarchies included in a report. The data on each parent is replaced by a sum formula. You can then enter data on the children and the sum is calculated on the parent nodes.

To do so, select the Calculate Parents in Hierarchies and perform a refresh.
Note
  • A sum is performed on a parent only if all the children of a parent are displayed in the report.
  • In a nested axis, the sum is performed on the parents that are placed in the outer and the inner dimension.
Note You can modify these options for a specific report in the Options tab of the Report Editor.

Example

Example with several dimensions in an axis
    Financial Accounts
EUR - Euro All 30
  FC00-Opening 10
  FC01 - Net Equity 20
USD - US Dollar All 60
  FC00-Opening 15
  FC01 - Net Equity 45
All All 90
  FC00-Opening 25
  FC01 - Net Equity 65

A sum formula is added on each node of the hierarchies.