Could someone please help.

I would like to use some MDX which calculates the current month for me, based on system date or some other method. That way when I report, I could use the MDX to create a calculated member (called Current Month) which I could then use. This would mean never having to manually select the current month from my time dimension.

Also, could someone please tell me how I could get a named set in Analysis Services which returned 12 different columns based on current month.

For example, if it was July, then the columns would be:

July 2003, AUg 2003, etc right through to July 2004.

Any ideas?