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 data on the column

This chapter will discuss two issues about getting data on the column. By this, we mean controlling the data shape in the results. One issue is about controlling the report headers in the results, and another issue is with how to physically put data on the column.

Reports are essentially one dimensional in the sense that both COLUMNS and ROWS axes from an MDX query will become columns or headers (columns and headers are used interchangeably in this chapter) in the report. Most of the reporting tools require the report shape to be pre-defined. This means that column header names and data types should be known during the design time.

On the other hand, MDX queries return a dataset that has the column names already pre-decided. ...

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