Rules using a Picklist Element as a Dimension

Post Reply
Splashmore
Posts: 4
Joined: Wed Mar 13, 2013 11:59 am
OLAP Product: PAL
Version: 2.0.6
Excel Version: 365

Rules using a Picklist Element as a Dimension

Post by Splashmore »

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
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: Rules using a Picklist Element as a Dimension

Post by PlanningDev »

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
Post Reply