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]            …

Formatting Code

Many people like to argue about how to format code, when to use tabs or spaces and other general formatting rules. I've worked with people who "enjoy" spending time formatting other people's code and will often spend a lot of time on this before they get to making changes or…