Page 1 of 1

Multiple hierarchies in a Dimension , Data load issue

Posted: Fri Aug 17, 2012 10:50 am
by TM1Learner
Guys,

I have a Time Dimension which has multiple hierarchies.

Total Time -> Regular Time -> Year -> Quarter -> Month
Total Time -> Current Time -> Current Year
Total Time -> Current Time -> Current Month

Please note that members for

Year and Current Year are like 2010,2011, 2012..
Quarter are like Q1-10, Q1-12
Month, Current Month are like Jan-10, Feb-10, Dec-11

Now if a user upload data for e.g. to Jan-11 using Current time hierarchy, will the data for the same member also get updated in other hierarchies for same member. For e.g. if user upload sales figure for Total Time -> Current Time -> Current Month ( and hence to Aug-12) will the figure also gets reflected for Total Time -> Regular Time -> Year -> Quarter -> Month

My requirement is to the sales figure should get reflected at both places as Aug-12 member is participating in other hierarchies as well regardless of which hierarchy is used to enter data .

I am creating the Time Dimension using TI scripts (TIMST, TODAY, DIMENSIONELEMENTINSERT and DIMENSIONELEMENTCOMPONENTADD) functions.

Thanks and Regards..

Re: Multiple hierarchies in a Dimension , Data load issue

Posted: Fri Aug 17, 2012 12:57 pm
by lotsaram
TRY IT.

It's the best way to learn TM1Learner.

(I also don't see what on earth this has to do with useful code, tips & tricks)