List Designer
Lists are lists of elements that you use in Ad-hoc reports. They are created in the Database Structure where they are stored under the dimensions to which they relate. They are defined in the List Designer. It is in the List Designer that you specify which elements of a list are shown in the report, how they are sorted, what filters (if any) are applied to them and what attributes (if any) are used.
Lists in the Database Structure are global lists. They are valid for the entire report catalog. When they are inserted into reports, these global lists are copied into local lists which are valid only for the report. Global and local lists can be designed independently.
The List Designer has five panes:
- Structure Selection
- Filter
- Sorting
- Attributes
- Advanced.
In addition, you can see a preview of the changes you make to a list.
- To open a section, click its title.
- To close a section, click the double arrow icon.
- To disable a filter, a sort, or an attribute selection without deleting the definition, clear the check box.
Changes you make in the List Designer affect the display of data in a report. Similarly, changes you make in a report affect the structure of the list in the List Designer.
See Navigating in Ad-hoc reports)
Lists can become invalid if, for example, the cube to which they are assigned is deleted.
See Manage Invalid Lists and Calculations.
The List Designer opens when you:
- Click a list that is linked to a server list
- Right-click the title bar of a left-docked pane and select
- Select .