Time Dimension in SSAS/SSRS
Posted on 2007-03-19
I have just created my first cube in SSAS and am using it in SSRS. I have a couple of questions for the experts on the best way to approach my task. My cube is analyzing direct marketing campaigns, so at it's basic level there are source codes, mail qty and responses. I need to have a maximum date of the dataset in my cube so I can use it in the reports. What is the best way to do this? Do I include the maxdate in the time dimension, or create a new dimension just for it?