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
Rules using a Picklist Element as a Dimension
-
- Posts: 4
- Joined: Wed Mar 13, 2013 11:59 am
- OLAP Product: PAL
- Version: 2.0.6
- Excel Version: 365
-
- 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
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
Might be worth a try