Hi,
I have a list of zero level elements from a TM1 dim in Excel in column A. In column B, I would like to return the direct parent of the element in column A. What is the function to d this???
Thanks.
Determine Direct Element Ancestor From Element
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Determine Direct Element Ancestor From Element
A parent is an ancestor, but an ancestor may not be a parent of a given element.youngjedi wrote: I have a list of zero level elements from a TM1 dim in Excel in column A. In column B, I would like to return the direct parent of the element in column A. What is the function to d this???
Assuming that it's a parent (especially as you said "direct" element ancestor), it would be ELPAR(dimension, element, index).
Refer to the Reference Guide for a full list of functions.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.