MDX in SSRS - What a hack!

The "Microsoft SQL Server Analysis Services" data source provider does not allow full MDX functionality, making it damn near impossible to write propper time based queries.

If you are up to writing full MDX, try changing the data source provider to "Provider=MSOLAP.3;Data Source=localhost;Initial Catalog=AdventureWorks"

Thanks goes to Dan Meyers