Select Dimensions

  1. Open config.xml for editing.
  2. 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>

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