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
Parent Element in Subset
- 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
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.
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
-
- MVP
- Posts: 3120
- 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
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
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
-
- 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
Thanks both, I suspected as much. I'd been heading down the attribute route since I posted this.