You can use the Planning Sort Member utility to sort dimension members. SortMember.cmd is similar to sorting on the Dimensions tab in Planning. You can sort Entity, Account, Scenario, Versions, and user-defined custom dimensions. You cannot sort Period, Year, or Currency dimension members. The utility is useful for sorting dimension members after loading members into Planning. The SortMember.cmd utility uses a command line interface. Only administrators can run it.
To launch the SortMember.cmd utility:
From the planning1 directory on the server where Planning is installed, enter this syntax:
SortMember [-f:passwordFile] servername username application member children|descendants ascend|descend
For the full path to the planning1 directory, see About EPM Oracle Instance.
Table 74. SortMember Utility Parameters
Parameter
Description
[-f:passwordFile]
Optional: If an encrypted password file is set up, use as the first parameter in the command line to read the password from the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.
servername The server name where the Planning application resides
username The name of the Planning administrator
application The name of the Planning application containing the dimension members to sort
member The parent member whose children or descendants to sort
children|descendants Whether to sort by children or descendants: sorting by children affects only members in the level immediately below the specified member; sorting by descendants affects all descendants of the specified member
ascend|descend
Whether to sort by ascending order or by descending order
For example:
SortMember localhost admin BUDGET account200 descendants ascend
If the application server, HBR Service, or RMI service is running when the SortMember utility is launched, you might see some java.rmi or “Port already in use” errors. They do not affect the functionality of this utility.