IPivot.SplitNamings

Fore Syntax

SplitNamings: Boolean;

Fore.NET Syntax

SplitNamings: boolean;

Description

The SplitNamings property determines whether several attributes can be output into one table column.

Comments

Available values:

True. Several attributes can be output into one column.
False. Several attributes cannot be output into one column.

Fore 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 Metabase, Express, 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".

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    Metabase: IMetabase;
    Analyzer: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    Metabase := Params.Metabase;
    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;