IPivotDimension.Levels

Syntax

Description

The property returns the collection of dimension levels.

Comments

To get the required dimension level, use IPivotDimensionLevels.Item.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier. The report contains a table.

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

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    Dim: IPivotDimension;
    Levels: IPivotDimensionLevels;
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 dimension from collection
    Dim := Pivot.Dimensions.Item(0);
    // Get collection of dimension levels and output the number of them to console window
    Levels := Dim.Levels;
    Debug.WriteLine("Number of dimension levels = " + Levels.Count.ToString);
End Sub UserProc;