Dealing with Calendars in OLAP

[Nassy]

Hi,

I have a customer that wants a cube that displays 52 weeks worth of future data ie 52 weeks after the current date and 2 weeks of past data ie 2 weeks before the current date.

Problem is, I have no way how to find an OLAP solution to this. I have searched the web but can find nothing. The fact tables and dimension tables will get re-loaded nightly and the way I would solve this problem would simply be to create the fact tables so that they have the correct 54 weeks of data in them.

Is there an easy way to solve this issue within OLAP? If anyone can give me pointers on how to approach this I would be very grateful.

cheers

Nassy

 

[johnherman]

Well, your weekly update will simply add a new future week, update the current week, and delete the oldest week.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright