SQL Server 2000 Analysis Services - how to create these rollups

[dkwong]

Hi,

I'm new to Analysis Services and have some experience with Cognos PowerPlay. I am trying to build a cube and have created all the dimensions except for the Time dimension. I need to create the following rollups to view revenue data:

YTD as of any month (e.g. YTD to August 2001)
Comparisons of quarters year over year i.e. variance (e.g. Q1 2001 compared with Q1 2002)

My Time dimension is as follows:
Fiscal Year
Quarter
Month

For those who are familiar with PowerPlay, these are defined as "special categories" in the Time dimension.

Any help on how to get started would be much appreciated!