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

Selecting Hardware for Analysis Services (10GB-1TB size)

The first thing you are going to is to figure out is if you even need a dedicated analysis services server. Some of our smaller customers just go for a mini “appliance” server which has Analysis Services/SharePoint and sometimes even a small data warehouse and PowerPivot installed on a single virtual machine with 16+ GB … Continue reading Selecting Hardware for Analysis Services (10GB-1TB size)