How to display Child and Parent in Hierarchy in Excel?

[cardantim]

Hello,

I'm using Perspective (TM1 9.5.2) and working with a dimension that has several levels to it. What I would like to do is have it such that once the child is selected what is displayed back is Parent / Child description. For example, my project is for clinical trials. In a study dimension I have the following levels; Therapeutic Area, Compound and then Study. What I want it to select a Study but have displayed "Compound / Study". Seems like it should be plausible?

Thanks

[lotsaram]

I can think of a bunch of ways you could do this, probably easiest is to have attributes of study for compound and thereapeutic area and call this in with DBRA formulas.

[cardantim]

I elected to use the ELPAR command and seems to work fine. So, where my worksheet originally contained only description of child I inserted two rows and ELPAR calls parent and grandparent descriptions.

In first of the newly inserted cell entered =ELPAR("blueprint:Study",C14,1) where blueprint is name of server, study is name of dimension, C14 is the cell that contains the child member and 1 indicates 1 parent of this child. In 2nd of the newly inserted cell entered =ELPAR("blueprint:Study",C14,2) where blueprint is name of server, study is name of dimension, C14 is the cell that contains the child member and 2 indicates grand parent of this child.

[lotsaram]

I would only use ELPAR if you have one and only one hierarchy in the dimension. Generally attributes are a better choice, you can find lots of discussion on this topic if you search.

[jstrygner]

In 2nd of the newly inserted cell entered =ELPAR("blueprint:Study",C14,2) where blueprint is name of server, study is name of dimension, C14 is the cell that contains the child member and 2 indicates grand parent of this child.

cardantim,

Code: Select all

ELPAR ( "blueprint:Study", C14, 2 )

returns second parent, not the grand parent (which I think you understand as parent of the parent).

To return grand parent you would need to type:

Code: Select all

ELPAR ( "blueprint:Study", ELPAR ( "blueprint:Study", C14, 1 ), 1 )

But as lotsaram mentioned, this might be tricky and return different results if in your dimension there are elements that have more than one parent.