ReverseOrder: Boolean;
The ReverseOrder property determines sorting direction.
If this property is set to False, sorting is ascending; otherwise fact dimension is sorted in descending order.
Sub Main;
Var
MB: IMetabase;
MObj: IMetabaseObject;
UsDim: IUserDimension;
UsDimAtr: IUserDimAttributes;
DimOrd: IUserDimOrders;
Order: IUserDimOrder;
Begin
MB := MetabaseClass.Active;
MObj := MB.ItemById("USER_DIM").Edit;
UsDim := MObj As IUserDimension;
UsDimAtr := UsDim.Attributes;
DimOrd := UsDimAtr.Orders;
Order := DimOrd.Item(0);
If Order.ReverseOrder Then
Order.ReverseOrder := False;
Else
Order.ReverseOrder := True;
End If;
MObj.Save;
End Sub Main;
After executing the example sorting direction is changed for the first attribute in the sorting list of the calculated dictionary.
See also: