IPivotDimensionLevelPropertiesCommon.DuplicateParent

Fore Syntax

DuplicateParent: TriState;

Fore.NET Syntax

DuplicateParent: Prognoz.Platform.Interop.ForeSystem.TriState;

Description

The DuplicateParent property determines whether level elements for child ones are repeated.

Comments

To get whether level elements are repeated from child ones, use IPivotDimensionLevelPropertiesCommon.IsDuplicateParent.

Fore Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier. Report data source is a cube that contains multilevel dimensions.

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

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    LHeader: IPivotHeader;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
    // Get display settings of report data table
    Pivot := Express.Pivot;
    // Get collection of dimensions located by rows
    LHeader := Pivot.LeftHeader;
    // Check
    If Not LHeader.IsDuplicateParent Then
        LHeader.DuplicateParent := TriState.OnOption;
    End If;
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example parent elements of hierarchy are displayed in the table sidehead before and after child elements.

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.ForeSystem;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    LHeader: IPivotHeader;
Begin
    // Get repository
    MB := Params.Metabase;
    // Get express report
    Express := MB.ItemById["EXPRESS"].Edit() As IEaxAnalyzer;
    // Get display settings of report data table
    Pivot := Express.Pivot;
    // Get collection of dimensions located by rows
    LHeader := Pivot.LeftHeader;
    // Check
    If Not LHeader.IsDuplicateParent Then
        LHeader.DuplicateParent := TriState.tsOnOption;
    End If;
    // Save changes
    (Express As IMetabaseObject).Save();
End Sub;