I am trying to figure out how to filter an MDX query so it only includes values that are for a certain period of time, eg. year to date, month to date, week to date.
So I have the following dimensions that I am interested in [Store].[Region].[District].[Store], [Time].[Year].[Month].[Week of Month]
Here's the query I have so far:
FROM [Sales Actl To Bdgt]
WHERE (Measures.[Bdgt Vol Q],
But say for example we are in the time period [Time]... and I only want values included for this time period and prior. The query as it stands returns the values for the entire year of 2001.
Does that make any sense?
If this needs more points, I'll gladly add them.