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..
Multiple hierarchies in a Dimension , Data load issue
-
- Posts: 17
- Joined: Sun Jul 22, 2012 8:18 am
- OLAP Product: TM1
- Version: 10.1.0
- Excel Version: 2010
-
- 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
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)
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)