Multiple hierarchies in a Dimension , Data load issue

Post Reply
TM1Learner
Posts: 17
Joined: Sun Jul 22, 2012 8:18 am
OLAP Product: TM1
Version: 10.1.0
Excel Version: 2010

Multiple hierarchies in a Dimension , Data load issue

Post 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..
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Multiple hierarchies in a Dimension , Data load issue

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