IEaxDataAreaPivotSlice.ParamValues

Syntax

ParamValues: IMetabaseObjectParamValues;

Description

The ParamValues property determines a collection of values of slice data source parameters.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier.

Add links to the Express and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Expr: IEaxAnalyzer;
    Slice: IEaxDataAreaPivotSlice;
    Params: IMetabaseObjectParamValues;
    v: Variant;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Expr := MB.ItemById("EXPRESS_REPORT").Bind As IEaxAnalyzer;
    // Get data analytical area slice
    Slice := Expr.DataArea.Slices.Item(0) As IEaxDataAreaPivotSlice;
    // Determine a collection of values of slice data source parameters
    Params := Slice.ParamValues;
    // Get value of the first cube parameter
    If Slice.IsParameterized Then
        v := Params.Item(0).Value;
    End If;
End Sub UserProc;

After executing the example the "v" variable contains value of the first parameter of the cube used as a data source for the express report if there are such ones.