sortMember
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.
Note:
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 AdministratorUsage
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 ofMember
-
children
, the default value, sorts only members in the level immediately below the parent member that you specify as the value ofMember
.
-
-
order
, optionally, identifies a sort order. Acceptable values are:-
ascending
; this is the default sort order. -
descending
-
Examples
-
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