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?
Is this a parent?
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Is this a parent?
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.
... 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.
Last edited by lotsaram on Fri Aug 30, 2013 6:49 pm, edited 1 time in total.
-
Darkhorse
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Re: Is this a parent?
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 
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