Hi ,
I have a source as sql table where I have around 1 million rows with budget values. Unfortunately the data is not at lower level for material dimension. Its one level higher . SO while loading I have to get the first children of the product code and then load it . Budget doesnt chnage much over time ,so may be this load is 2 or 3 times max .
What function should I use to get the first children of an element .
Thanks,
Getting First children of a member
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Getting First children of a member
ELCOMP - just look at the Reference Guide
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Getting First children of a member
Indeed, ELCOMP is the one you need.
Could it be that the first child is again a consolidated element in the Product dimension ?
Then maybe it might be an idea to store the target level 0 element as a Text attribute on the consolidated Product element where the budget data arrive. Update the attribute during the reload of the Product dimension, or in a separate process before you kick off the import of budget data.
Could it be that the first child is again a consolidated element in the Product dimension ?
Then maybe it might be an idea to store the target level 0 element as a Text attribute on the consolidated Product element where the budget data arrive. Update the attribute during the reload of the Product dimension, or in a separate process before you kick off the import of budget data.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 124
- Joined: Wed Nov 26, 2014 8:32 pm
- OLAP Product: IBM TM1, Planning Analytics
- Version: PA 2.0.5
- Excel Version: 2016
Re: Getting First children of a member
Thanks ! Just noticed it was not one level up it was two levels up .
So its like 10, 10-1, 10-1-100, Material1
so the table has 10-1 and there can be many children under 10-1 like 10-1-100 ,10-1-101
But its okay to get first childrens children .
Do I do ELMCOMP 2 times
Elcomp('Item',ELCOMP('item','10-1',1) ,1)
IS there any straight forward formula .
Thanks
So its like 10, 10-1, 10-1-100, Material1
so the table has 10-1 and there can be many children under 10-1 like 10-1-100 ,10-1-101
But its okay to get first childrens children .
Do I do ELMCOMP 2 times
Elcomp('Item',ELCOMP('item','10-1',1) ,1)
IS there any straight forward formula .
Thanks
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Getting First children of a member
If it's the first child of the first child, you have to do it like that. It's fine.
Making sure that indeed, the first child is a consolidated element, and also that the first child of the first child is a level 0 element.
Making sure that indeed, the first child is a consolidated element, and also that the first child of the first child is a level 0 element.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly