Hi all,

I posted this a little while ago and Dave suggested I used a Calculated
Member but I just can't seem to get the MDX syntax right - I am really
battling with MDX, please can someone help me with the MDX syntax to create
a calculated member that will help me achieve what I need.
I have a standard time dimension, I need to create a calculated member off
this to get MTD dates etc.

Thanks in advance
Kathy

---------------------------------------------------------------------------------------------
Hi All

I need help with a cube, I want to add a calendar dimension with a Year,
Month, Date - easy enough but now I want to add an alternate drill down path
which just reflects for instance all the dates for the prev month etc.

i.e. it would display as follows

Calendar
All Dates (Dimension)
Year
Month
Date
Prev Month (Virtual Dimension)
2005/02/01 .... to
2005/02/28
Current Month (Virtual Dimension)
2005/03/01 .... to
2005/03/31

etc


I thought a virtual dimension would do the trick and it would have if one
could do a SourceTableFilter on it but you can't so what do I do??
How do I accomplish this? Please can someone help?

Regards

K