duda (10/26/2009)

---

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