IStandardCubeDataset.SetCallback

Module. Description of the unit, in which the class is implemented that implements methods of the ISQLCallback interface.

ForeClass. Name of the class used for handling data extraction query generation.

Description

The SetCallback method sets a handler of data extraction query generation for a data source.

Comments

Specify name of the class that implements methods of the ISQLCallback interface in the ForeClass parameter.

To reset the specified handler, set the Module parameter to Null, and the ForeClass to "".

Fore Example

Executing the example requires that the repository contains a standard cube with STD_CUBE identifier and a unit with the CUBE_CALLBACK identifier. The SQLCallback class is implemented in the unit. Add links to the Cubes and Metabase system assemblies.

Public Class SQLCallback: Object, ISQLCallback     Sub BeforeConstruction(Components: ISQLComponents);     Var         i: Integer;         Select_, From_, Where, GroupBy, Aggregation, OrderBy: String;     Begin         Debug.WriteLine("Select_: " + Components.Select_);         Debug.WriteLine("From_: " + Components.From_);         Debug.WriteLine("Where: " + Components.Where);         Debug.WriteLine("GroupBy: " + Components.GroupBy);         Debug.WriteLine("Aggregation: " + Components.Aggregation);         Debug.WriteLine("OrderBy: " + Components.OrderBy);         Debug.WriteLine("SubQuery: " + Components.SubQuery.ToString);         Debug.WriteLine("ConditionCount: " + Components.ConditionCount.ToString);         For i := 0 To Components.ConditionCount - 1 Do             Debug.WriteLine("Condition " + i.ToString + " : " + Components.Condition(i).Condition);         End For;         Debug.WriteLine("TableAlias: " + Components.TableAlias);         //---Changed parts of query         //Select_ := Components.Select_;         //...         //Modification Select_         //...         //Components.Select_ := Select_;         //From_ := Components.From_;         //...         //Modification From_         //...         //Components.From_ := From_;         //Where := Components.Where;         //...         //Modification Where         //...         //Components.Where := Where;         //GroupBy := Components.GroupBy;         //...         //Modification GroupBy         //...         //Components.GroupBy := GroupBy;         //Aggregation := Components.Aggregation;         //...         //Modification Aggregation         //...         //Components.Aggregation := Aggregation;         //OrderBy := Components.OrderBy;         //...         //Modification OrderBy         //...         //Components.OrderBy := OrderBy;     End Sub BeforeConstruction;     Sub AfterConstruction(Var SQL: String);     Begin         //If required modification if final query text in SQL variable         Debug.WriteLine("AFTER: " + SQL);     End Sub AfterConstruction; End Class SQLCallback;

Sub UserProc;
Var
    MB: IMetabase;
    Cube: IStandardCube;
    CubeDataset: IStandardCubeDataset;
Begin
    MB := MetabaseClass.Active;
    Cube := MB.ItemById("STD_CUBE").Edit As IStandardCube;
    CubeDataset := Cube.Destinations.Item(0).Datasets.Item(0);
    CubeDataset.SetCallback(MB.ItemById("CUBE_CALLBACK"), "SQLCallback");
    (Cube As IMetabaseObject).Save;
End Sub UserProc;

On executing the example, the handler of query generation is set for the first cube data source.

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.Metabase;

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Cube: IStandardCube;
    CubeDataset: IStandardCubeDataset;
Begin
    MB := Params.Metabase;
    Cube := MB.ItemById["STD_CUBE"].Edit() As IStandardCube;
    CubeDataset := Cube.Destinations.Item[0].Datasets.Item[0];
    CubeDataset.SetCallback(MB.ItemById["CUBE_CALLBACK"], "SQLCallback");
    (Cube As IMetabaseObject).Save();
End Sub;

IStandardCubeDataset.SetCallback

Fore Syntax

Fore.NET Syntax

Parameters

Description

Comments

Fore Example

Fore.NET Example