If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

A quick summary of new features in Analysis Services multi-dimensional model

What's new for cubes (or Analysis Services multi-dimensional models, to give them their full title)? Virtually nothing, as this oh-so-short blog makes clear.

This is part of a wide-ranging blog explaining the new features in every part of SQL Server 2016.

Posted by Andy Brown on 08 July 2016

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

What's new in SSAS Multi-Dimensional 2016 (Cubes)

As expected, Microsoft have made substantial changes to Analysis Services (Tabular Model) 2016, but the multi-dimensional model is (as far as I can see) unchanged.

I've already blogged on the fact that I think you'd be mad to choose multi-dimensional SSAS over tabular SSAS (particularly when Microsoft are so obviously only investing in the latter).

As an example of what hasn't changed, here's a cube in SSAS 2016 (multi-dimensional model):

Creating a cube - like everything else - seems unchanged between SSAS 2012 and 2016.

Spot the difference? Me neither. About the only difference I can find for SSAS 2016 multi-dimensional model is that you can create distinct count measure groups.

This blog has 0 threads Add post