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. Let's quickly review how the column names are pre-determined in MDX queries.
On the COLUMNS axis, the name of the measure will become the name of the column. For example, if we put these two measures on the COLUMNS axis, we will get two columns...
