Picklist

1) Pick list is a list of values for specific element or cube cell. When we set up the Pick list, it'll show a drop down menu containing of the list of defined values.

2) User can select the required value from the Picklist and if user tries to enter an element which is not listed in the pick list, system will throw an error.

Pick List Types

There are three types of pick list.

1) Static Pick list
2) Subset Pick list
3) Dimension Pick list

1) Static Pick list

a) A static pick list is composed of a colon-delimited list of values using the below syntax.

     static:value1:value2:value3

For ex; static:Newyork:Chicago:Washington results in a pick list containing the values Newyork, Chicago, and Washington when browing the cube.

b) To inlcude a NULL value in the pick list, we need to have two consuective colons as shown below.

      static:value1:value2:value3:: . This will result in a pick list with NULL value at the end.

2) Subset Pick list

a) A subset list contains values corresponding to all elements of a named subset. If the elements of the subset change, the values available in the pick list will automatically change.

b) The syntax for subset pick list is as follows:

      subset:dimension_name:subset_name

For ex; subset:Account:IT results in a pick list containing all elements from IT of Account dimension.

3) Dimension Pick list

1) A dimension pick list contains values corresponding to all elements of a dimension. if the elements of the dimension change, the pick will automatically change.

2) The syntax of dimension pick list is as follows:

     dimension:dimension_name

For ex; dimension:months results in a pick list containing all elements of Month dimension.