Hi all,
Hopefully this is a straight forward question.
I currently have a cost center listing, where I am linking live into TM1 to bring back their attributes.
For example 256000, will have the following code =DBRA("Reporting cube:Cost Center",$A2,"Code - Desc")
This will then bring back the correct full description, being 256000 - OCP HM DG HIN02.
In this cost center dimension, there are 7 levels in the structure above this department.
However, I cannot seem to find out, how you bring back each level via the code?
Any ideas, generally around how I could bring back each level attributed to a department?
Many thanks
DBRA Code Query
-
MarenC
- Regular Participant
- Posts: 350
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: DBRA Code Query
Hi,
Use ELPAR and nest to the previous level, or let us say you have the cost center and then parents in rows,
So an example of first row, let us say first cost centre element is in cell B2, parent level 1 is in C2 etc:
ELPAR('Cost Centre', $B$2, 1) ELPAR('Cost Centre', $C$2, 1) ELPAR('Cost Centre', $D$2, 1) etc etc etc etc
Maren
Use ELPAR and nest to the previous level, or let us say you have the cost center and then parents in rows,
So an example of first row, let us say first cost centre element is in cell B2, parent level 1 is in C2 etc:
ELPAR('Cost Centre', $B$2, 1) ELPAR('Cost Centre', $C$2, 1) ELPAR('Cost Centre', $D$2, 1) etc etc etc etc
Maren