O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Getting the summary

The advantages of a multi-dimensional cube are that the data is pre-aggregated and that there is a lot of metadata that we can use for calculations. There is no need to re-aggregate data at the query time, and we have pre-defined calculation formulas in the cube. Not to mention that all metrics are formatted in the cube. Reporting tools should take advantage of this instead of reinventing the wheel.

It is always a good idea to reply on MDX queries to get the correct aggregation no matter what tool you use, so that the need to aggregate in the reporting tool is eliminated.

Visual totals are totals at the end of a column or row that add up all of the items visible in the column or row. By default, when placing the All member in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required