Dynamic updation of child elements in Dimnsion

[vishalpoddar90]

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.

[Wim Gielis]

See here for very similar time dimension manipulations:

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

[vishalpoddar90]

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.

[Wim Gielis]

You’re welcome

[tm123]

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