EPMMemberSortingOverride
This function overrides the member sorting and grouping that has been previously defined using the interface (Member Sorting and Grouping area in the Member Selector), for a specified dimension, in one or several reports.
For more information about how to sort or group members using the interface, see Member Sorting and Grouping by Properties.
| Parameter | Description |
|---|---|
| reportID | ID of one or several reports |
| dimension | On a Planning and Consolidation connection, specify the dimension name. For other connections, specify the hierarchy name; to specify a hierarchy, enter: dimension.hierarchy |
| sort | Specify if you want to enable the member sorting. Enter TRUE to enable the sorting, FALSE if you do not want to enable the sorting. |
| ascendingOrder | Specify if you want to sort the members by ascending or descending order. Enter TRUE to sort members by ascending order, FALSE to sort members by descending order. |
| property | Name of the property on which to sort the members. The
values of the specified property are ordered by ascending or descending order,
depending on the ascending parameter.
Tip In the Property parameter,
you can reference the cell in which the EPMDimensionProperty function has been
entered. For more information,
EPMDimensionProperty.
|
| AddLocalMemberBefore | Specify if you want to insert a grouping local member before the set of members. Enter TRUE to insert the grouping local member. |
| AddLocalMemberAfter | Specify if you want to insert a grouping local member after the set of members. Enter TRUE to insert the grouping local member. |