Select Dimensions
- Open config.xml for editing.
- Insert blank XML template for default slice after <dataSource> block :
<config>
<dataSource type="...">
...
</dataSource>
<defaultSlice>
<axes>
<axis name="rows"> </axis>
<axis name="columns"> </axis>
<axis name="pages"> </axis>
</axes>
<measures> </measures>
</defaultSlice>
</config>
- Add rows data: insert into <axis name="rows"> tag
<hierarchy> block(s) with dimension name and hierarchy name, you may add as much fields as you like:
<axis name="rows">
<hierarchy>
<dimensionName>[Country]</dimensionName>
<hierarchyName>[Country].[Country]</hierarchyName>
</hierarchy>
<hierarchy>
<dimensionName>[Color]</dimensionName>
<hierarchyName>[Color].[Color]</hierarchyName>
</hierarchy>
</axis>
- Add columns data: insert into tag <axis name="columns"> <hierarchy> block(s) too:
<axis name="columns">
<hierarchy>
<dimensionName>[Category]</dimensionName>
<hierarchyName>[Category].[Category]</hierarchyName>
</hierarchy>
</axis>