SetDimSort method: CubeCollectionDefn class
Syntax
SetDimSort(DimName, IsAscending [, CubeName1, IsAscending2, CubeName2, IsAscending3, CubeName3])Description
Use the SetDimSort method to specify the sorting order for the dimension.
If CubeName1 is an empty string, the dimension is sorted by the names of the members of the dimension, and the other parameters are not used.
If CubeName1 is not an empty string, the dimension is sorted by cubes, as specified by the other parameters.
The Boolean parameter IsAscending defines whether sorting should be in ascending or descending order. Up to three sort keys may be specified. CubeName1 is the primary sort key. CubeName2 is used to sub-sort any members that have the same key value under CubeName1, and so on.
Parameters
| Parameter | Description |
|---|---|
|
DimensionName |
Specify the name of the dimension that you would like to specify a sort order for. |
|
IsAscending |
Specify if the dimension should be sorted in ascending or descending order. This parameter takes a Boolean value: true if the sort should be ascending, false if it should be descending. |
|
CubeName1 |
Specify whether the dimension is to be sorted by members or by cubes. If the dimension is to be sorted by members, specify a null string for this parameter. If the dimension is to be sorted by cubes, specify a cube name. |
|
IsAscending2 |
Specify if the sort for CubeName1 is in ascending or descending order. This parameter takes a Boolean value: true if the sort is ascending, false if its descending. |
|
CubeName2 |
Specify the name of a cube to be used to sub-sort the primary sort specified by CubeName1. |
|
IsAscending3 |
Specify if the sort for CubeName2 is in ascending or descending order. This parameter takes a Boolean value: true if the sort is ascending, false if its descending. |
|
CubeName3 |
Specify the name of a cube to be used to sub-sort the primary sort specified by CubeName2. |
Returns
None.