dynamic pick lists

[cdhodge2002]

I have a cube where I give my client blank line items in order to select people that are going to be budgeted for the coming year. One of the measures in this cube is a measure that will have a pick list that will have a list of employees for them to choose from. Is there a dynamic way to have this pick list change based upon what department they are planning in? I have created the different subsets in the employee pick list for the different departments. So basically I have 30 to 40 subsets that are named based upon an element in the department dimension. is there a way to write the code in the pick list cube rules file to pick up these subsets based upon a dimensional element, or will i need to hard code this.

[lotsaram]

This came up only a day or 2 ago but the thread was rather misleading, something like "help with MDX"

[cdhodge2002]

I try to avoid MDX because I find there is a slowdown in contributor. So I manually edit the subsets when the dimensions are updated. I have been looking at MDX though, but I am not sure if there would be an easier way.

[JDLove]

I would think this is fairly standard, if I understand you correctly.

For example we used this example to have the Picklist based on applicable cashflow options depending on the account type attribute.

['Cashflow Element']=S:IF(ATTRS('GL TB',!GL TB,'Account Type')@='Asset','subset:GL TB:Account Type Cashflow Cash IN',CONTINUE);
['Cashflow Element']=S:IF(ATTRS('GL TB',!GL TB,'Account Type')@='Liability','subset:GL TB:Account Type Cashflow Cash OUT',CONTINUE);
['Cashflow Element']=S:IF(ATTRS('GL TB',!GL TB,'Account Type')@='Equity','subset:GL TB:Account Type Cashflow Cash OUT',CONTINUE);

In the above example we are looking at another measure "Account Type" to determine what subset the Picklist will be based on, but you can just as easily base this on an element.

Many ways to approach this and depends on your situation. You could use attributes to store the subset ! then its one rule in the Picklist rule cube, thats not needing maintaining as you would just edit the attribute on the department dim.