IEaxDataAreaSlice.UseExtendedPeriod

Syntax

UseExtendedPeriod: Boolean;

Description

The UseExtendedPeriod property determines whether data loading period is used.

Comments

Available values:

True. Data loading period is used which is set by the IEaxDataAreaSlice.ExtendedPeriodStart and IEaxDataAreaSlice.ExtendedPeriodEnd properties. Data loading period is taken into account on validation and transformation calculation.
False. Data loading period is not used.

Example

Executing the example requires that the repository contains time series database with the TSBD identifier.

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

Sub UserProc;
Var
    mb: IMetabase;
    CrInf: IMetabaseObjectCreateInfo;
    Analyzer: IEaxAnalyzer;
    i: Integer;
    SelSet: IDimSelectionSet;
    Sel: IDimSelection;
    AreaSlice: IEaxDataAreaSlice;
Begin
    // Get validation rule
    Mb := MetabaseClass.Active;
    // Create express report
    CrInf := Mb.CreateCreateInfo;
    CrInf.Permanent := True;
    CrInf.KeepEdit := True;
    CrInf.ClassId := MetabaseObjectClass.KE_CLASS_EXPRESSREPORT;
    Analyzer := Mb.CreateObject(CrInf).Edit As IEaxAnalyzer;
    // Set data source
    Analyzer.DataSourceDescriptor := Mb.ItemById("TSDB");
    Analyzer.Mode := EaxMode.MultiDimension;
    // Set selection
    SelSet := Analyzer.Pivot.Selection;
    For i := 0 To SelSet.Count - 1 Do
        Sel := SelSet.Item(i);
        Sel.DeselectAll;
        Sel.SelectElement(0, True);
    End For;
    // Get data slice
    AreaSlice := Analyzer.Grid.Slice;
    // Set data loading period
    AreaSlice.ExtendedPeriodStart := DateTime.Parse("01.01.1990");
    AreaSlice.ExtendedPeriodEnd := DateTime.Parse("01.01.2020");
    AreaSlice.UseExtendedPeriod := True;
    // Save changes
    (Analyzer As IMetabaseObject).Save;
End Sub UserProc;

After executing the example express report with limited data loading period is created.