Hi all,
I have a situation here. I have a dimension as "week". In this elements are stored as year and week no. For e.g 201740, 201741, 201742, and so on.
My C level elements are last week, last4weeks, last8weeks. Every week I want last week element for e.g. 201742 as a child of last week, 201742, 210741, 201740, 201739 as child elements of last4weeks and so on.
Every week it has to be updated.
Please help me to achieve it.
Dynamic updation of child elements in Dimnsion
-
- Posts: 19
- Joined: Wed Jun 28, 2017 12:27 pm
- OLAP Product: IBM Planning Analytics
- Version: 2.0.76
- Excel Version: 365
-
- 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: Dynamic updation of child elements in Dimnsion
See here for very similar time dimension manipulations:
http://www.wimgielis.com/tm1_relativeti ... ons_EN.htm
http://www.wimgielis.com/tm1_relativeti ... ons_EN.htm
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: 19
- Joined: Wed Jun 28, 2017 12:27 pm
- OLAP Product: IBM Planning Analytics
- Version: 2.0.76
- Excel Version: 365
Re: Dynamic updation of child elements in Dimnsion
Thanks a lot Wim. Your article helped me a lot.Wim Gielis wrote: ↑Thu Oct 26, 2017 6:46 am See here for very similar time dimension manipulations:
http://www.wimgielis.com/tm1_relativeti ... ons_EN.htm
Appreciate your prompt reply.
-
- 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: Dynamic updation of child elements in Dimnsion
You’re welcome
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: 132
- Joined: Thu Oct 23, 2014 10:15 pm
- OLAP Product: tm1, cognos bi
- Version: 10.2
- Excel Version: 2010
Re: Dynamic updation of child elements in Dimnsion
I use a similar aproach to update my fiscal month dimension monthly, i keep the Current fiscal Month in a control cube and every time the superuser changes to the next month ( it could be automated based on current date but in finance usually they like to do it only after the prior month is closed)
Then i have a TI process where i build the following hierarchies:
Current Month
Prior Month
YTD
Prior YTD
Rolling 13 Months
You have to make sure that you unwind those hierarchies before you add the new children
Then i have a TI process where i build the following hierarchies:
Current Month
Prior Month
YTD
Prior YTD
Rolling 13 Months
You have to make sure that you unwind those hierarchies before you add the new children