Default Current Month from current date with Dimensional Model

[rpvs]

Hi Gurus,

I am working on dimensional model and want the report to run for the current month based on the report date. The month level is



[Sales Analysis].[Account Totals Period].[Account Total Periods].[Month]



which has namespace,Dimension,Hierarchy,level for the time dimension.



Question is how do we extract the current month from the report date so that it equals the month level as above??? Currently i am asking the user to select it and run but would like it to default to current month and run automatically.

[Shailaja0520]

If you want to run the report with the default current month ,put a filter in your query..

Extract(month,current_date) --this will give you the month number
=
[Sales Analysis].[Account Totals Period].[Account Total Periods].[Month] --extract the month number from this column

hope you get this