Sorting Dimension Headers

You can order column and row headers in a query result set using Dimension Header Sort definitions. Dimension Header Sort options are determined by the data source.

For Example, Essbase enables you to order columns and rows in default, ascending, descending, level or generation order. The default order is the natural order in which dimension members are returned, based on the data source outline.

  To indicate a Dimension Header Sort definition:

  1. Right-click a dimension member header and select Data Display, then Dimension Header Sort.

    The Dimension Header Sort submenu is displayed.

  2. Select Default, Ascending, Descending, Level or Generation.