MDX Best Practices – Careful how you comment queries

I see a lot of customer MDX queries where comments are used to help explain complex logic inside an MDX query, or to remove a block that is not needed. Please avoid using the single line style of comment as below: SELECT -- Reseller Sales Amount by Quarter [Measures].[Reseller Sales Amount] ON 0 ,[Date].[Calendar].[Calendar Quarter].Members … Continue reading MDX Best Practices – Careful how you comment queries

Finished the SSAS Maestro Week !!

Just finished the Analysis Services Maestro Week in Redmond. Phew quite a hectic week. So what’s it like ? Well a lot of the content is NDA, but to be fair most of the content seems to also be in three sources: The Ops Whitepaper, The Perf Whitepaper and the Analysis Services Unleashed Book: http://msdn.microsoft.com/en-us/library/hh226085.aspxContinue reading Finished the SSAS Maestro Week !!