IStandardCubeDataset.DrillThroughQuery

Fore Syntax

DrillThroughQuery: IDatasetModel;

Fore.NET Syntax

DrillThroughQuery: Prognoz.Platform.Interop.Db.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.

Fore 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.

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Cubes;
Imports Prognoz.Platform.Interop.Db;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    StandCub: IStandardCube;
    Dataset: IStandardCubeDataset;
Begin
    // Get repository
    MB := Params.Metabase;
    // 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;