TM1 Forum

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.

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???

A parent is an ancestor, but an ancestor may not be a parent of a given element.

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.