Referencing list objects

List objects are named ListViewN, where N is a sequential number.

Use the name to reference the object in formulas. For example, the formula =ListView3.attribute returns an attribute of the object.

You can rename objects to make them easier to identify when defining actions, for example.

This table shows the attributes of list objects that can be displayed:


Name	Function	Example
=ListView[No].Alias	Displays the caption of a list element	All Stores
=ListView[No].Text	Displays the unique name of the list element	[Store].[All Stores]
=ListView[No].Attribute	Displays an attribute of the list element. The attribute must first be selected in the Attributes pane of the List Designer
=ListView[No].ElementCount	Returns the number of elements displayed by the ListView object. It increases and decreases as the list is expanded and collapsed
=ListView[No].ElementIndex	Returns the position in the list of whichever element is selected
=ListView[No].Set	Returns the MDX of a list, in Design Mode only
=ListView[No].StructureSet	Returns the MDX of the structure selection of a list, in Design Mode only

ElementCount and ElementIndex

In Design mode, link a list to a list object other than a hyperblock.
Click an adjacent cell and specify =ListViewN.ElementCount.
In another cell, specify =ListViewN.ElementIndex.

In View mode, the element count increases and decreases as the list is expanded and collapsed. The element index changes as you select different elements in the list.

Set and StructureSet

This example uses the Samples application.

Drag the Product dimension from the SALES cube onto the worksheet to create a hyperblock.
In the List Designer select the All Tires check box in Structure Selection.
In a worksheet cell, specify =[hyperblock_name].Set.
The cell displays the MDX of the list:
```
Distinct({{[PRODUCT].[All Tires]}})
	 
```
In another cell, specify =[hyperblock name].StructureSet

The cell displays the MDX of the structure selection:

{{[PRODUCT].[All Tires]}}