TotalsDefined: Boolean;
The TotalsDefined property determines whether there are data aggregation settings on the server.
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.
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.
See also: