The easiest way to create a pick list is to
define a text attribute named Picklist for a dimension. You can then
specify the members of a pick list for each element within the dimension,
using any of the pick list types described above. When an element
has a pick list defined, any cube cell identified by that element
displays a drop-down list containing the pick list values.
Procedure
- In the Server Explorer, right-click the dimension for which
you want to define pick lists, then click Edit Element
Attributes.
- In the Attributes Editor, click Edit, Add
New Attribute.
- In the New Attribute dialog box, enter Picklist as the
attribute name.
- Select Text as the attribute type.
- Click OK.
The Attributes
Editor now contains a new column titled Picklist.
- For each element for which you want to create a pick list,
enter a valid pick list definition at the intersection of the element
name and the Picklist column.
- To enter a static pick list, enter a comma-delimited
list of values using the syntax
static:value1:value2:value3:value4
.
- To enter a pick list that contains the members of a regular dimension, enter the pick
list definition using the syntax
dimension:dimension_name
.
- To enter a pick list that contains the members of a named dimension hierarchy, enter
the pick list definition using the syntax
dimension:dimension_name\:hierarchy_name
.
- To enter a pick list that contains the members of a regular subset, enter the pick
list definition using the syntax
subset:dimension_name:subset_name
.
- To enter a pick list that contains the members of a subset of a named dimension
hierarchy, enter the pick list definition using the syntax
subset:dimension_name\:hierarchy_name:subset_name
.
- Click OK to close the Attributes
Editor and save the pick list definitions.