lists

The dimensions and elements of a multidimensional database are held in lists. A list represents a list of element names in a database. You can filter or sort them as required. You can use lists in a report, for example, in hyperblocks or combo boxes/list views. When a repository is created, a list is automatically generated for each dimension. A list is a subset of the dimension, defined by various rules and criteria. There are different types of list and the type is determined by the database alias being used (for example, relational lists are used with relational databases). These two fundamental differences distinguish different types of list.

• The first is where the rules which define the list are calculated. For server and relational (SQL) lists, the calculation is done on the server. For client lists and custom lists, it is done on the client.
• The second fundamental difference is whether the list is global or local. Changes to a global list affect all reports and objects that reference it. Changes to local lists only affect the objects in the report in which the list is used. Both global and local lists can be client or server based.