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