Multiple hierarchies in a Dimension , Data load issue
Posted: Fri Aug 17, 2012 10:50 am
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..
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..