Elements, Parents and so on..

Roger_Lewin · Post by **Roger_Lewin** » Mon Dec 15, 2008 3:48 pm

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

Steve Rowe · Post by **Steve Rowe** » Mon Dec 15, 2008 3:53 pm

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

Mike Cowie · Post by **Mike Cowie** » Mon Dec 15, 2008 3:54 pm

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

Roger_Lewin · Post by **Roger_Lewin** » Mon Dec 15, 2008 4:11 pm

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

TM1 Forum

Elements, Parents and so on..

Elements, Parents and so on..

Re: Elements, Parents and so on..

Re: Elements, Parents and so on..

Re: Elements, Parents and so on..