TM1 Forum

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.

See here for very similar time dimension manipulations:

http://www.wimgielis.com/tm1_relativeti ... ons_EN.htm

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

Thanks a lot Wim. Your article helped me a lot.
Appreciate your prompt reply.

You’re welcome

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