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. ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.