Mapping data
We need to be aware of the way that data mapping is done in the chart. You can understand how it works if you can imagine data input as a table. CCC can receive the data as two different structures: relational and crosstab. If CCC receives data as a crosstab query, it will translate it to a relational structure. You can see this in the following examples.
Crosstab
The following table is an example of the crosstab data structure:
 |
Column Data 1 |
Column Data 2 |
---|---|---|
Row Data 1 |
Measure Data 1.1 |
Measure Data 1.2 |
Row Data 2 |
Measure Data 2.1 |
Measure Data 2.2 |
Tip
Creating crosstab queries
To create a crosstab query, usually you can do this with the group when using SQL; or just use MDX, which allows us to easily specify a set for the columns and for the rows.
Just by looking at the previous and following examples, you should be able to understand that, in the crosstab structure (the previous example), columns and rows are part of the result set, while in the relational format (the...