Sorts members of Entity, Account, Scenario, and Versions dimensions and of custom dimensions.

This command is useful for sorting dimension members after loading members into the application.


You cannot use this command to sort members of Period, Years, and Currency dimensions.

Applies to

Planning, Planning Modules, FreeForm, Enterprise Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.

Required Roles

Service Administrator


epmautomate sortMember Member [type=children|descendants] [order=ascending|descending] where:
  • Member is the name of the parent member whose descendants or children are to be sorted.

  • type, optionally, specifies the members to be sorted. Acceptable values are:

    • descendants sorts all sub-members (children and descendants) of the parent member that you specify as the value of Member

    • children, the default value, sorts only members in the level immediately below the parent member that you specify as the value of Member.

  • order, optionally, identifies a sort order. Acceptable values are:

    • ascending; this is the default sort order.

    • descending


  • Sort the children of Entity dimension in ascending order: epmautomate sortMember Entity

  • Sorts all sub-members of the Entity dimension in descending order: epmautomate sortMember Entity type=descendants order=descending