TM1 Forum

Hi all

is there anyway to find out if London is a child of europe when its layout is London>UK>Europe

Every elpar eliscomp will do the first parent but not the second or third, is there a way?

ElIsAnc in what you need. ElIsAnc(dimension, ancestor, descendant) returns 1 or 0.

... but it just occurred to me that you didn't say in which UI you needed the answer. Because for whatever reason ElIsAnc is supported in rules and TI but not for whatever quirk in Perspectives.

You can work around it by using a rule to derive an attribute and use DBRA in Excel or you can write your own recursive VBA function using ElIsPar. Or just download the TM1Tools add-in which has an ElIsAnc function.

omg what an idiot i tried that but forgot its a number output Grrr well ask a stupid question, get made to look stupid with the answer

Edit:

Its for Rules, so ths works perfectly, cant believe I used this so many times but forgot its a number output.. origional sentance above covers my feelings about this question