MDX formatting and the changing toolset

Reporting Services includes a very useful visual MDX query tool, which I often start with when writing reports. It can add parameters and create calculated members for you which are both handy features. Very quickly though you realise that it can't do more complicated MDX queries for you without you…

MDX via OPENQUERY

When you run a basic MDX query directly against the cube, it returns only those measures and dimensions you have specified in the query. Note that [Customer Geography] is a hierarchy. Select Non empty [Measures].[Sales Amount] ON Axis(0), [Customer].[Customer Geography].[State-Province].Allmembers ON¬†Axis(1) FROM [Adventure Works]            …