TM1 Forum

I've set a picklist in a dimension.
Now I have to transfer the data from one cube to another via a rule.
But I've no clue, how I can map the picklist element with my dimension in the other cube.

My first try was like this:

['Investitionsvolumen'] = n:DB('INVESTITIONSPLANUNG_IT', 'Aktuell', !EINZELPOSITIONEN, !KOSTENSTELLEN,'Genehmigtes Investitionsvolumen', DB('INVESTITIONSPLANUNG_IT', 'Aktuell', !EINZELPOSITIONEN, !KOSTENSTELLEN, !KOSTENSTELLEN_AFA, 'Kostenstelle Abschreibung'));

Can anyone tell me, how I can use the picklist element with a rule?

Thanks a lot
Splashmore

Does your picklist use an alias? If so you may need to convert the value pulled from the picklist into the PrincipalName of the element you want to match to. The way you have it written I didn't think you needed to do this however I ran into and issue where I was using an if [element] = DB(Picklist Item) and I had to convert to principal name to get it to work.

Might be worth a try