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.
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