Skip Levels

From Version 9 you can use this feature to remove levels from your report, which can be useful when drilling.

This can be used in Grid, Small Multiple Charts and tree Dimension Slicers.

Grids

In this example, we have a hierarchy that contains:

• Year
• Semester
• Quarter
• Month
• Day

And we want to skip past the semesters, and go directly to the quarters.

In the member selector for Date we go to the Advanced section, and in the Skip Levels screen untick the Calendar Semester level.

The result is that when we drill years we next see quarters

Slicers

We will make the same changes in a slicer, remembering to select "Use query restrictions for children".

the result is a tree that again goes directly from year to quarter.