Create a pick list by using the Picklist attribute

Create a pick list either by referencing a set or a dimension in a member attribute that is called Picklist, or by adding static values to the Picklist attribute.

A pick list that references a set or a dimension contains all the values that are in the set or dimension. If the members change, the values in the pick list also change. A pick list that contains static values contains only those values.

Note: A dimension that contains pick lists must be last in the cube. String type members and pick list members must be in the same dimension in a cube.

Procedure

Open the dimension that references the pick list in the dimension editor.
Click the Attributes tab.
Click Add attribute.
Create a string attribute called Picklist.
To reference a set, add the following Picklist attribute value:
```
Subset:dimensionname:setname
```
See the following example:
```
Subset:Years:months
```
To reference a dimension, add the following Picklist attribute value:
```
Dimension:dimensionname
```
For example:
```
Dimension:Employees
```
To reference the members of a named hierarchy within a dimension, add the following Picklist attribute value:
```
dimension:dimensionname\:hierarchyname
```
See the following example:
```
dimension:Products\:Europe
```
To create a static pick list, add the following Picklist attribute value:
```
static:value1:value2:value3:value4
```
See the following example:
```
static:none:January:February:March:April:May:June:July:August:September:October:November:December
```
To include a null value at the beginning or in the middle of a static pick list, use two consecutive colons in the pick list definition. For example, the code: static:value1:value2::value3:value4 results in a pick list with a null value between value2 and value3.

To include a null value at the end of a static pick list, insert a colon without a following value at the end of the pick list definition. For example, static:value1:value2::value3:value4: results in a pick list with a null value that follows value4.

What to do next

To test that the pick list is successfully created, add a view with the dimension that contains the pick list.