Parent Element in Subset

Post Reply
RSK
Posts: 49
Joined: Mon Oct 08, 2012 12:02 pm
OLAP Product: TM1 10.1.1
Version: TM1 10.1.1
Excel Version: 2010

Parent Element in Subset

Post by RSK »

Is there away of returning an element parent from a subset source within a TI?

The dimension I am using has multiple hierarchies contained within in it, therefore the standard Elpar function returns the parent for the 1st hierarchy it comes across.

Thanks
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Parent Element in Subset

Post by qml »

Subsets do not store any relationships between elements, so unless your subset is designed to encode relationships in the element order itself (e.g. the parent you're after is always directly before the child or something similar) then you're out of luck.

Of course, ELPAR can be used to get any parent, not just the first one. You could cycle through all parents, using ELPARN to give you their total number, and using some other information (attribute, naming convention etc.) to pick the right parent.
Kamil Arendt
Wim Gielis
MVP
Posts: 3117
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Parent Element in Subset

Post by Wim Gielis »

Can you populate an attribute and read the value ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
RSK
Posts: 49
Joined: Mon Oct 08, 2012 12:02 pm
OLAP Product: TM1 10.1.1
Version: TM1 10.1.1
Excel Version: 2010

Re: Parent Element in Subset

Post by RSK »

Thanks both, I suspected as much. I'd been heading down the attribute route since I posted this.
Post Reply