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?
TI to extract all children ?
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TI to extract all children ?
What do you mean "there is no loop in a TI"?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?
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: TI to extract all children ?
Or...
Just set your data source to be all elements of the dimension, then test using ELISANC.
Just set your data source to be all elements of the dimension, then test using ELISANC.
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TI to extract all children ?
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".David Usherwood wrote:Or...
Just set your data source to be all elements of the dimension, then test using ELISANC.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.