IPivot.SplitNamings

Syntax

SplitNamings: Boolean;

Description

The SplitNamings property determines whether multiple attributes can be output to a single data table column.

Comments

Available values:

Example

Executing the example requires an express report with the EXPRESS_PIVOT identifier.

Express report is set up in the way that attributes of each dimension element are located in separate columns. For example, the dimension contains the Element element, for which additional attributes are set: Factor_1, Factor_2. Element attributes in table are located in separate columns.

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

Sub UserProc;
Var
    Metabase: IMetabase;
    Analyzer: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    Metabase := MetabaseClass.Active;
    Analyzer := Metabase.ItemById("EXPRESS_IPIVOT").Edit As IEaxAnalyzer;
    // Get express report table
    Pivot := Analyzer.Pivot;
    Pivot.SplitNamings := True;
    //Save changes in express report
    (Analyzer As IMetabaseObject).Save;
End Sub UserProc;

After executing the example attributes of each dimension element are located in one column and separated with the "|" character. For example: "Factor_1 | Factor_2".

See also:

IPivot