I want to allow users to quickly see data on this month (i.e. month to date)
or last month, this quarter or last quarter. I don't think I need to enable
comparison between date periods.

I was thinking of adding Calculated Sets called "This Month", "Last Month",
"This Quarter" and "Last Quarter" to my Date dimension. What's the best way
to do this?

Thanks.

you can create a "dummy dimension" called "Relative time" with only 1 row on
it
like this:

RelativeTimeID Label
1 Standard

add this dimension in your cube (you have to create a dummy column in your
fact table which is allways "1" to insure that you can link the table to the
new dimension)

Now you can create calculated members in the cube and add these members to
the "Relative time" dimension.

Like:
"Year to date"
which is:
SUM( YTD(), ([Relative time].&[1]) )

sample here:
http://www.tomchester.net/articlesdo...dimension.html
and here
http://support.microsoft.com/default...;EN-US;q304118

good luck

"Jeff Davis" <Jeff Davis (AT) discussions (DOT) microsoft.com> wrote