IStandardCubeDataset.UseSubqueryOptimization

Syntax

UseSubqueryOptimization: Boolean;

Description

The UseSubqueryOptimization property determines whether to use subqueries on creating a query to extract data of the current data source.

Comments

A standard cube requests for data from its own data sources. The format of queries created to get data depends on value of the UseSubqueryOptimization property. If the property is set to True (default value), subqueries are used, the following query is created:

select a.* from (select a.ID,a.VALUE,a.VDATE,... from <TableName> a) a where ((a.VDATE in (TO_DATE('1995-01-01','YYYY-MM-DD'),...))) and ((a.ID in (1,...))) and ...

If the UseSubqueryOptimization property is set to False, subqueries are not used, the following query is created:

select a.ID,a.VALUE,a.VDATE,... from <TableName> a where ((a.VDATE in (TO_DATE('1995-01-01','YYYY-MM-DD'),...))) and ((a.ID in (1,...)))...

The query format is also influenced by filtering strategies configured for different cube dimensions.

Example

The example of use is given in description of the IStandardCubeDimension.QueryStrategy property.