OlapCalculationType (Property)

Applies To:

QueryOptions object

Description:

Returns the method for how database totals are calculated in a CubeQuery section. This property corresponds to the settings in the Results group of Query-> Query Options >Global.

Action:

Read-write, BqOlapCalculationType

Consants:

The OlapCalculationType (Property) uses the BqOlapCalculationType constant group, which consists of these values:

bqOlapCubeCalculator = 1: disables both Download Database Totals and Allow Relational Aggregation
bqOlapDatabaseAndLocalTotals = 3: enables Download Database Totals and Allow Relational Aggregation
bqOlapDatabaseTotals = 2: enables Download Database Totals and disables Allow Relational Aggregation

Example:

This examples shows how to return the calculation type for a CubeQuery section in an Alert box:

Alert(ActiveDocument.Sections["Query"].QueryOptions.OlapCalculationType)