ICubeAggregationInfo.TotalsDefined

Syntax

TotalsDefined: Boolean;

Description

The TotalsDefined property determines whether there are data aggregation settings on the server.

Comments

The property returns True if server aggregation is set up for cube facts. To run aggregation, use any method except for Count and CountDistinct. If server aggregation is not set up for cube facts (AggregationType = CubeFactBindingAggregationType.None) or the Count or CountDistinct calculation method is used (calculation is executed on the computer client when these methods are used), the method returns False.

Example

Executing the example requires that the repository contains a cube with the Cube_1 identifier.

Sub UserProc;
Var
    MB: IMetabase;
    CubeInst: ICubeInstance;
    AggrInfo: ICubeAggregationInfo;
Begin
    MB := MetabaseClass.Active;
    CubeInst := MB.ItemById("Cube_1").Open(Null) As ICubeInstance;
    AggrInfo := CubeInst As ICubeAggregationInfo;
    If AggrInfo.TotalsDefined Then
        Debug.WriteLine("There are settings for data aggregation on server");
    Else
        Debug.WriteLine("There are no settings for data aggregation on server");
    End If;
End Sub UserProc;

After executing the example the cube is opened. If there are data aggregation settings on the server in the cube, an appropriate message is displayed in the console window.