Getting First children of a member

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Getting First children of a member

Post by manu0521 »

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,
User avatar
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

Post by paulsimon »

ELCOMP - just look at the Reference Guide
Wim Gielis
MVP
Posts: 3098
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

Post by Wim Gielis »

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.
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
manu0521
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

Post by manu0521 »

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
Wim Gielis
MVP
Posts: 3098
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

Post by Wim Gielis »

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.
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
Post Reply