IStandardCubeDataset.DrillThroughQuery

Syntax

DrillThroughQuery: IDatasetModel;

Description

The DrillThroughQuery property determines the Query repository object to get drilled down data.

Comments

A query can be used for each relational data source of a standard cube.

Example

Executing the example requires that the repository contains:

Standard cube with the CUBE identifier.
The Query repository object with the QUERY identifier.

Add links to the Cubes, Db and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    StandCub: IStandardCube;
    Dataset: IStandardCubeDataset;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get standard cube
    StandCub := MB.ItemById("CUBE").Edit As IStandardCube;
    // Get the first data source
    Dataset := StandCub.Datasets.Item(0);
    // Set query to get detailed data
    Dataset.DrillThroughQuery := MB.ItemById("QUERY").Bind as IDatasetModel;
    // Save changes
    (StandCub As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the specified query to get drilled down data is applied to the first relational data source of standard cube.