TM1 Forum

Good evening everyone from germany,

how do i find out, if an element is child of a parent, regardless of dimension levels? ELISPAR won't do the trick, any suggestions?

Roger

You are after ElIsAnc which unfortunatly is only available using rules..

If you look in the useful code section there is a way of doing this in Excel...
HTH

Hi Roger,

Look around on the forum (or the TM1 help files, for that matter) for "ELISANC". This is a function that exists in TI and in Rules that lets you return whether or not a particular element rolls into another (regardless of how many levels in between). Here is one post in particular that provides some sample code that could give you the same function in Excel (since IBM Cognos have not yet added support for it in Excel, I don't believe, despite abundant requests):

http://forums.olapforums.com/viewtopic. ... sanc#p1480

Hope that helps.

Regards,
Mike

Thank you very much, this is exactly, what i was looking for. I didn't knew the function...*cheers*