Page 1 of 1
How to display Child and Parent in Hierarchy in Excel?
Posted: Fri Feb 17, 2012 7:10 pm
by 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
Re: How to display Child and Parent in Hierarchy in Excel?
Posted: Fri Feb 17, 2012 8:02 pm
by 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.
Re: How to display Child and Parent in Hierarchy in Excel?
Posted: Mon Feb 20, 2012 9:27 pm
by 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.
Re: How to display Child and Parent in Hierarchy in Excel?
Posted: Tue Feb 21, 2012 8:26 am
by 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.
Re: How to display Child and Parent in Hierarchy in Excel?
Posted: Thu Feb 23, 2012 10:21 pm
by jstrygner
cardantim wrote: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.