Working with Hierarchies

Break Hierarchies

If the report uses a hierarchy, you can "Break" it to basically remove it. This via the "More Sort Options" in the Sort Menu.

Filter Data via Hierarchies

1. Select the Hierarchy to filter

2. On the filter button, choose the « Filter By Member »  

3. Select then press OK.

Using the Compact Hierarchical Display

The option Compact Display allow to generate a hierarchical view of the dimensions of an axis (row & column)

• The purpose is to give an easier way to read crosstab in case of multiple dimensions
• This allow to navigate to the detail