Creating a Pick list

There are two ways of creating a Pick list.

1) Creating Pick list with Element Attributes
2) Creating Pick list with Control Cubes

1) Creating Pick list with Element Attributes

a) In the Server Explorer, right-click on the dimension for which the pick lists is required and then click Edit Element Attributes.

b) In the Attributes Editor, click Edit > Add New Attribute.

c) In the New Attribute dialog box, enter Picklist as the attribute name.

d) Select Text as the attribute type.

e) Click ok. The Attributes Editor now contains a new column titled Picklist.

f) For each element for which the pick list is required, enter a valid pick list definition at the intersection of the element name and the Picklist column.

g) Click ok to close the Attributes Editor and save the pick list definitions.

2) Creating Pick list with Control Cubes

a) The pick list can be created with control cubes. This gives control over which cube cells should contain pick list and allows flexibility in defining picklist of individual cells.

b) We can also create rules for the pick list cube, which allows us to define pick lists for any section of cube.

c) A pick list control cube is composed of the same dimensions as the regular cube and in addition it gets one more dimension named }picklist.

d) The }Picklist dimension contains a single string element, named value.

Steps

i) In the ServerExplorer, right-click the cube for which the picklist is required, then Create Pick List Cube.

ii) A new control cube is created, using the naming convention }PickList_cubename. For example, when we create a pick list control cube for the Expenses cube, the control cube is named }Picklist_Expenses.

iv) If the control cube is not displayed in the Server Explorer, click View, Display Control Objects to enable the display of control cubes and other control objects.

v) Defining Pick Lists for Individual Cells in a Control Cube

vi) Below are the steps to define pick lists for individual cells in a control cube. The pick lists defined in the control cube are used to display pick list values in the associated regular cube.

      1.Double-click the control cube in the Server Explorer. The control cube opens in the Cube Viewer.

     2.Configure the view of the control cube as necessary to view the cells for which we want do define pick lists.

     3.In each cell for which we want to create a pick list, enter a pick list definition. We can enter any of the pick list types in the control cube: static, subset, or dimension.

    4.Click File, Recalculate to recalculate the cube view.