Page 1 of 1
TI to extract all children ?
Posted: Tue Feb 22, 2011 4:52 am
by telula_w
Hello,
I would like to extract all the children of a roll-up. I know there is no loop in a TI.
Does anyone know of an alternative?
Re: TI to extract all children ?
Posted: Tue Feb 22, 2011 5:18 am
by Alan Kirk
telula_w wrote:I would like to extract all the children of a roll-up. I know there is no loop in a TI.
Does anyone know of an alternative?
What do you mean "there is no loop in a TI"?
You use a While loop. You get the number of children with ElCompN and use a While loop to get the ElComp values from 1 to the ElCompN value.
Re: TI to extract all children ?
Posted: Tue Feb 22, 2011 9:41 am
by David Usherwood
Or...
Just set your data source to be all elements of the dimension, then test using ELISANC.
Re: TI to extract all children ?
Posted: Tue Feb 22, 2011 10:02 am
by Alan Kirk
David Usherwood wrote:Or...
Just set your data source to be all elements of the dimension, then test using ELISANC.
I think you mean either ElIsComp or ElIsPar, depending which way around you do the test. Of course this presupposes that the question really is what it says it is; that is, wanting "children" rather than "descendants".