Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Vincent Rainardi The Date Dimension in Analysis Services RE: The Date Dimension in Analysis Services

  • October 26, 2009 at 7:47 am

    #1070699

    Thanks and that’s a good article but I have a question though.

    I have 2 dimensions stored in the same SQL table (data mart).

    Data for my date dimension is stored for 2 cycles. Both cycles have a 12 month period. The first cycle is from January to December and the other cycle is from April to March.

    One row is used to store both cycles in the table.

    See below for my dimensionTimeTable:

    DateSeqCalendarDateYr1Yr2Monthname1Yr1MonthNrYr2MonthNrYr1QNrYr2QNr

    200903012009-03-0120092008March03120104

    200903312009-03-3120092008March03120104

    200904012009-04-0120092009April04010201

    I have one time dimensions in the cube with two hierarchies. They are both represented in two hierarchies with each hierarchy representing time cycles mentioned above.

    My problem is that cycle one works fine while measuring anything but cycle2 only measures the current month and does not show any values for previous months.

    Your help regarding above will be appreciated.

    My problem is that

    What you don't know won't hurt you but what you know will make you plan to know better