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
Loop Unrolling - Optimal Unrolling Factor?
- Steve Rowe
- Site Admin
- Posts: 2418
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Loop Unrolling - Optimal Unrolling Factor?
Hi,
The Elpar / ElementParent function will bring back an elements parent, so if you have the levels organised as structure in the dimension then you can use this.
Do take care though as if you have multiple consolidation structures in the dimension then you can't guarantee which structure you will get back.
If your structure is complex, then add the levels to attributes when the dimension is built or put the structure you want to be explicit about in it's own hierarchy so you can reference it exactly.
Cheers,
The Elpar / ElementParent function will bring back an elements parent, so if you have the levels organised as structure in the dimension then you can use this.
Do take care though as if you have multiple consolidation structures in the dimension then you can't guarantee which structure you will get back.
If your structure is complex, then add the levels to attributes when the dimension is built or put the structure you want to be explicit about in it's own hierarchy so you can reference it exactly.
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk