Specifying the order of dimensions

To set the dimension order configuration for Application Studio reports:

  1. Select Application Studio > Advanced tab.
  2. Specify the Database Alias.
  3. Specify this information:
    Period Year
    Select Unmerged.
    DimensionsOrder
    Specify [1],[2],[3],[4],[5],[6],[7],[8],[10],[11],[12],[13],[9]
    DS Connector compatibility
    Set to YES.
    Period Year
    Select Merged.
    DimensionsOrder
    Specify [1*2],[3],[4],[5],[6],[7],[8],[10],[11],[12],[13],[9]
    DS Connector compatibility
    Set to YES. The [1*2],[3] or [1],[2],[3], etc. are dimensions IDs
  4. After configuring the changes, log-off from Application Studio. Disconnect from the repository and reconnect again.