Pick List through Control Picklist Cube

[dharav]

Hello All

I have a cube A Where there are 4 dimension P,Q,R, and S respectively.

I want to create a dynamic pick list. I want my pick list to be filter based on the element (Metro Name) selected in P dimension.


I assigned the rule in pick list control cube for the cell['forecast','location','value']=S:'Subset:Z:PC';

Now, how could i populate this value in my regular cube.?

I wrote a db rule in regular cube than it had only bring the text 'Subset:Z:PC'. I want to see pick list.

Your direction would help.

Thanks

Dharav

[lotsaram]

You do not do anything in the regular cube. A picklist rule is just the same as a drill rule. When a cell is selecterd in the target cube then based on the context of the cells the control cube is checked and it returns a list of text. When a cell is selected that matches the picklist rule area then a picklist dropdown will be displayed. Provided that a subset "PC" exists in dimension "Z" then the subset will show as a picklist. If you write a rule in a cell then obviously no picklist will display since picklists are to guide data entry and if you have a rule then the cell value is pre-defined and so no picklist can be displayed.