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
Monday, May 26, 2008
Subscribe to:
Posts (Atom)