IPivot.SeparateCombinedDimsNamings

Fore Syntax

SeparateCombinedDimsNamings: Boolean;

Fore.NET Syntax

SeparateCombinedDimsNamings: boolean;

Description

The SeparateCombinedDimsNamings property determines merging of dimension name additional attributes in table.

Comments

Merging of additional name attributes is available on selecting two or more dimensions. If any attribute is not selected for one of dimensions, the cell for their elements will be empty in the column or row.

To display merging in an express report, select arrangement by all dimensions (go to the Designer ribbon tab, click the Arrangement button and select the .All Dimensions checkbox).

Available values:

True. Default. Additional dimension attributes are merged in one hierarchy:

False. Additional dimension attributes are not merged:

Fore Examples

Executing the example requires an express report with the EXPRESS_IPIVOT identifier:

Add a data table to the report.
Select two dimensions with the arrangement by rows.
Add additional name attributes for dimensions.
Go to the Designer ribbon tab, click the Arrangement button and select the All Dimensions checkbox.

In the unit add links to the Express, Metabase, Pivot system assemblies.

Sub UserProc;
Var
    Metabase: IMetabase;
    Analyzer: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    // Get repository
    Metabase := MetabaseClass.Active;
    // Get express report
    Analyzer := Metabase.ItemById("EXPRESS_IPIVOT").Edit As IEaxAnalyzer;
    // Get express report table
    Pivot := Analyzer.Pivot;
    // Undo merging of additional attributes
    Pivot.SeparateCombinedDimsNamings := False;
    // Save changes to express report
    (Analyzer As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, additional dimension attributes will not be merged in table.

Fore.NET Example

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

Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    Metabase: IMetabase;
    Analyzer: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    // Get repository
    Metabase := Params.Metabase;
    // Get express report
    Analyzer := Metabase.ItemById["EXP_IPIVOT"].Edit() As IEaxAnalyzer;
    // Get express report table
    Pivot := Analyzer.Pivot;
    // Undo merging of additional attributes
    Pivot.SeparateCombinedDimsNamings := False;
    // Save changes to express report
    (Analyzer As IMetabaseObject).Save();
End Sub;