IPivotDimensionLevelPropertiesCommon.ChildrenBeforeParents

Fore Syntax

ChildrenBeforeParents: TriState;

Fore.NET Syntax

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

Description

The ChildrenBeforeParents property determines whether to place child elements of hierarchy before parent ones.

Comments

To get whether child elements of hierarchy are placed before parent ones, use IPivotDimensionLevelPropertiesCommon.IsChildrenBeforeParents.

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 a dimension consisting of several levels.

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.IsChildrenBeforeParents Then
        LHeader.ChildrenBeforeParents := TriState.OnOption;
    End If;
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example child elements of hierarchy in the table sidehead are placed before parent ones.

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.IsChildrenBeforeParents Then
        LHeader.ChildrenBeforeParents := TriState.tsOnOption;
    End If;
    // Save changes
    (Express As IMetabaseObject).Save();
End Sub;