Show TOC

Ranking DataLocate this document in the navigation structure

Procedure

  1. Select Start of the navigation path EPM Next navigation step Edit Report End of the navigation path.
    The Report Editor dialog box opens.
  2. Select the Ranking tab.
  3. Select the Rank Data Using the Following Criteria option.
    The rest of the tab is activated.
  4. Select Member, First Column or Last Column.
  5. If you have selected Member:
    1. By default, you rank data based only on a member that is displayed in the column axis of the report. If you want to rank data based on a member that is not part of the column axis, deselect the Show Only Members Displayed in the Report option.
    2. Click the ellipsis button.
    3. In the Column Selector dialog box that opens, select the member on which the ranking will be based and click OK.
    Note If there is more than one dimension in the column axis, you can select one member for each dimension to be ranked.
  6. Indicate whether data will be ranked from the Top or the Bottom by selecting one of the options.
  7. Select how many items will be included in the ranking, for example, top 10 sales figures.
  8. If you also define a filtering on data in the Filtering tab, to avoid any conflict, the filtering takes precedence by default over the ranking. Therefore, the Perform Ranking, then Filtering option is not selected by default. You can select it to change the precedence and the Perform Filtering, then Ranking option in the Filtering tab is automatically unchecked.
  9. To delete the entire ranking query, click the Clear Expression button.
    Note 0 is not a valid value in this field.
    Note If the Rank Data Using the Following Criteria option is not checked, this tab is disabled. However, if you have already entered settings, they are not deleted.