ICustomDimOrder.ReverseOrder

Syntax

ReverseOrder: Boolean;

Description

The ReverseOrder property determines sorting direction.

Comments

Available property values:

True. Sort descending.
False. Sort ascending.

Example

Executing the example requires a standard cube with the STD_CUBE identifier in the repository.

Sub UserProc;
Var
    MB: IMetabase;
    Cube: IStandardCube;
    CustDim: ICustomDimension;
    CustAtrs: ICustomDimAttributes;
    CustDimOrd: ICustomDimOrders;
    DimOrd: ICustomDimOrder;
Begin
    MB := MetabaseClass.Active;
    Cube := MB.ItemById("STD_CUBE").Edit As IStandardCube;
    CustDim := Cube.FactDimension.Dimension As ICustomDimension;
    CustAtrs := CustDim.Attributes;
    CustDimOrd := CustAtrs.Orders;
    DimOrd := CustDimOrd.Item(0);
    If DimOrd.ReverseOrder Then
        DimOrd.ReverseOrder := False;
    Else
        DimOrd.ReverseOrder := True;
    End If;
    (Cube As IMetabaseObject).Save;
End Sub UserProc;

Executing the example changes direction of sorting by the first attribute in fact dimension sorting list.