Structure Selection functions
Click in the Structure Selection toolbar. These functions are listed:
Range
Use the Range function to select elements from one point in the hierarchy to another point below it and include all the elements in between. Select the Range function and then select the From and To elements in the Selection Settings section.
Elements underneath
You can select a parent and display the elements at a selected level below it (for example, you might select a year as the parent and the quarters and months as levels below it).
Click and select . Select a level. In the Selection Settings section, select a parent from the Element list.
| Function | Description |
|---|---|
| All Including parent | Adds the parent and its children to the list |
| All Excluding parent | Adds the children to the list but not the parent |
| All Base elements | If the parent has only individual (base) elements beneath it in the hierarchy, this option has the same effect as All Excluding Parent. However, if the parent has further parents beneath it, as well as base elements, this option displays only the base elements. |
Descendants
Use the Descendants function to select a level as the parent and return its descendants. You can also choose the level at which the descendants are displayed.
For example, in the Best Practices OLAP database provided with Office Plus is the Product dimension. You could select the product group, Summer Tires as the parent and use the Descendants function to return its descendants at the Tire level. This would return the two product sub groups - S7000 Powergy and S8000 Energy.
Or, you could return the descendants at the Size level to return the six individual products in the two product sub groups.
| Flag | Description | Example |
|---|---|---|
| After | Displays the descendants from all levels below the selected level. | Select Car Tires Summer as the Parent and
Product Group as the level.
This returns the two Tire groups(S7000 Powergy and S8000 Energy), each expanded to show its three Sizes. |
| Before | Displays the descendants from all levels above the selected level but not from the level itself. | Example: Select All Tires as the Parent
and Size as the level.
As they are all above the selected level, this returns All Tires and the five Product Groups with drill down to their Tires. The individual tire sizes are not returned. |
| Before & After | Displays the descendants from all levels subordinate to the parent level but not from the level itself. | Example: Select All Tires as the Parent
and Product Group as the level.
Product Group, Tire and Size are all below All Tires but, as Product Group is the selected level, the product groups are not displayed. The Tires are displayed and expanded to display the Sizes they contain. |
| Base Elements | Displays all the elements at the selected level. | Example: Select All Tires as the Parent
and Tire as the Level.
This displays all the tire sizes. |
| Self | Displays all elements at the selected level within the selected parent. | Example: Select Winter Tires as the Parent
and Size as the Level.
This displays the sizes within Winter Tires but not the three Tire groups. |
| Self & After | Displays the descendants of the selected level and of the levels below. | Example: Select Summer Tires as the Parent
and Product Group as the Level.
This returns the Parent, expanded both its Tire groups and their sizes. |
| Self & Before | Displays all elements of the selected level and of the levels above it. | Example: Select All Tires as the Parent
and Tire as the Level.
This displays all the Tire groups and the levels above them - Product Groups and All Tires. |
| Self & Before & After | Displays the descendants from all levels above the selected level but not from the level itself. | Example: Select All Tires as the Parent
and Tire as the Level.
This returns the Tire groups and the Product Groups above them and the tire sizes below them. |
To add parents to a list level, click and select . Select the parent, the level and the flag from the lists in the Selection Settings section.
Periods to date
Used with time-based lists, this function adds siblings from the same level as an element you select. The selection returns all elements at the same level, including, the selected element.
Click and select . Select the parent and the level from the list in the Selection Settings section.
Previous periods
To add elements before and including a specified element to a time-based list, click and select . Select the starting element and the Index (that is, the number of elements you want to add).