IPivot.BroughtOutDimValue

Syntax

BroughtOutDimValue: Integer;

Description

The BroughtOutDimValue property determines index of metric dimension element on using the Value attribute.

Comments

To use the property, determine metric dimension in the IPivot.BroughtOutDim property.

If value of this property is not specified, table is built by the first element in selection.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier containing a table. The role of one of the dimensions is Metrics.

Add links to the Dimensions, Express, Metabase, Pivot system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    DimInst: IDimInstance;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS").Bind As IEaxAnalyzer;
    // Get display settings of report data table
    Pivot := Express.Pivot;
    // Get data of the specified dimension
    DimInst := Pivot.BroughtOutDim;
    // Display in the console window
    If DimInst <> Null Then
        Debug.WriteLine("Metrics dimension- " + DimInst.Name);
        Debug.WriteLine("Attribute name - " + DimInst.Elements.Name(Pivot.BroughtOutDimValue));
        Debug.WriteLine("Index of metrics dimension element - " + Pivot.BroughtOutDimValue.ToString);
    Else
        Debug.WriteLine("Specified dimension is not metrics dimension";
    End If;
End Sub UserProc;

After executing the example the console window displays metrics dimension name, attribute name, index of metrics dimension element.