IPivot.UseDataCache

Fore Syntax

UseDataCache: Boolean;

Fore.NET Syntax

UseDataCache: Boolean;

Description

The UseDataCache property determines whether data cache is used while working with the table.

Comments

If the property is set to True, data cache is used while working with the table. All the data obtained from a source according to the given selection, falls into cache. Data is obtained from cache on selection change. Missing data is obtained from data source and is cached. Data cache exists while data source is opened.

The property is set to False by default, and data is not cached.

NOTE. Data from server aggregation is not cached.

Fore Example

Executing the example requires a form, two buttons on the form, the TabSheetBox component named TabSheetBox1, the UiErAnalyzer component named UiErAnalyzer1, and the ErAnalyzerDimPanel component named ErAnalyzerDimPanel1. An express report is connected to the UiErAnalyzer1 component.

Class TESTForm: Form
    UiErAnalyzer1: UiErAnalyzer;
    TabSheetBox1: TabSheetBox;
    ErAnalyzerDimPanel1: ErAnalyzerDimPanel;
    Button1: Button;
    Button2: Button;
    Pivot: IPivot;

    Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
    Begin
        Pivot := (UiErAnalyzer1.Instance As IEaxAnalyzer).Pivot;
        Pivot.UseDataCache := True;
    End Sub Button1OnClick;

    Sub Button2OnClick(Sender: Object; Args: IMouseEventArgs);
    Begin
        If Pivot <> Null Then
            Pivot.FlushDataCache;
        End If;
    End Sub Button2OnClick;

End Class TESTForm;

After starting the form, clicking the Button1 button activates data caching for the express report table. Clicking the Button2 button activates clearing of available cached data.

Fore.NET Example

Executing the example requires a form, two buttons on this form, the TabSheetBoxNet component named TabSheetBoxNet1, the UiErAnalyzerNet component named UiErAnalyzerNet1, and the ErAnalyzerDimPanelNet component named ErAnalyzerDimPanelNet1. An express report is connected to the UiErAnalyzerNet1 component.

Imports Prognoz.Platform.Forms.Net;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Pivot;

Public Partial Class TESTForm: Prognoz.Platform.Forms.Net.ForeNetForm
    Public Constructor TESTForm();
    Begin
        InitializeComponent();
    End Constructor;
    Pivot: IPivot;

    Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
    Begin
        Pivot := (UiErAnalyzerNet1.AnalyzerUi.Instance As IEaxAnalyzer).Pivot;
        Pivot.UseDataCache := True;
    End Sub;

    Private Sub button2_Click(sender: System.Object; e: System.EventArgs);
    Begin
        If Pivot <> Null Then
            Pivot.FlushDataCache();
        End If;
    End Sub;

End Class;

After starting the form, clicking the Button1 button activates data caching for the express report table. Clicking the Button2 button activates clearing of available cached data.

See also:

IPivot