Loop Unrolling - Optimal Unrolling Factor?

[drewdavis]

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

[Steve Rowe]

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,