ICubeExecuteSetup.FindByKey

Syntax

FindByKey(Key): ICubeExecuteDimSetup;

Parameters

Key. Dimension key.

Description

The FindByKey method searches for parameters by dimension key.

Example

Executing the example requires that the repository contains a time series database with the FC_DEP identifier.

Sub UserProc;
Var
    Mb: IMetabase;
    CubeInst: ICubeInstance;
    Dest: ICubeInstanceDestination;
    Sels: IDimSelectionSet;
    CubeExSet: ICubeExecuteSetup;
    DimSetup: ICubeExecuteDimSetup;
Begin
    Mb := MetabaseClass.Active;
    CubeInst := Mb.ItemById("FC_DEP").Open(Null) As ICubeInstance;
    Dest := CubeInst.Destinations.DefaultDestination;
    Sels := Dest.CreateDimSelectionSet;
    CubeExSet := Sels As ICubeExecuteSetup;
    DimSetup := CubeExSet.FindByKey(60);
    If DimSetup <> Null Then
        Debug.WriteLine("Settings of the specified dimension  are found");
    Else
        Debug.WriteLine("Settings of the specified dimension are not found");
    End If;
End Sub UserProc;

After executing the example parameters for the dimension with the 60 key are searched. Search results are displayed in the console window. If parameters are found, they are contained in the DimSetup variable.

See also:

ICubeExecuteSetup