Structure Filter tab
This has options for specifying which hierarchy levels or elements are added to the list and which are hidden. The effects are displayed in the Preview pane.
See Client list designer.
There are three main lists: Hierarchy selection, Level-based selection and Base element. Here you can specify, for example, that only hierarchy elements below a selected element are displayed.
In the Hierarchy selection and Base element lists you can select an element and include all the elements below it in the hierarchy. Or, you can display all the elements below it, but exclude the element itself.
In the Hierarchy selection list, select or .
The Level-based selection list contains the options No restriction, Hierarchy, Aggregate and Named levels.
The Hierarchy and Aggregate options are similar, but the Hierarchy option works down from the top of the hierarchy and the Aggregate option works up from the bottom. For example, if you select the Hierarchy option and specify levels 1 to 1, only elements at the highest level of the hierarchy are displayed. If you select the Aggregate option and specify level 1 to 1 then all the elements at the lowest level of the hierarchy are displayed.
The Named levels option lists all the levels of the hierarchy (for example, All, Group, Sub-group ). You can select one or more levels to display.
The Hide elements list works with both hierarchical and level-based selection. Select to display only aggregate elements of the hierarchy (all elements that have children). Select , to display only elements that have no children.
Revolving structure filter
A revolving structure filter works in a similar way for client lists as the SUBSET function for server lists.
The Enable revolving selection check box enables the three parameters, Start element, Start and End.
The Start element is a reference point. You specify the position in the hierarchy where the list should begin. Enter 0 to start the list with the Start element and 1 to start at the element immediately below it, etc. In the End field, specify the last element the list should contain.
Example
The Analysis cube of the Best Practices sample database supplied with Application Studio contains a Period dimension which contains the years 2002 to 2014. Select 2007 as the Start element, 0 as the start of the list (Start) and 3 as the number of elements (End).The list displays 2007, 2008, 2009 and 2010. Change the start to 1. The list starts one element below the base element and contains only 2008, 2009 and 2010.
If you select the check box, the All Years element is added to the list.
If you select the Add children element, all the quarters and months of each year are added to the list.
If you enter a figure in the End field that is greater than the number of elements that there are below the start point, the list does not change. But, if you select the check box, the list continues back to the beginning. So, if 2007 is the Start element, 1 is the Start and 4 is the End figure, a cyclic list displays 2006, 2008, 2009 and 2010. If you change the End to 5, the list displays 2006, 2007, 2008, 2009 and 2010.
Establishing a revolving list structure using variables
Variables can be used for Start element, Start and End.