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 Main;

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(Configurations for data aggregation on server exist);

Else

Debug.WriteLine(Configurations for data aggregation on server do not exist);

End If;

End Sub Main;

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.