IMDCalculationFormulasTable.Check

Syntax

Check([Table: ITable = Null]);

Parameters

Table. Optional parameter that determines a table that must be checked for use as a formulas table in multidimensional calculation on database server.

Description

The Check method checks if the table can be used as a formulas table.

Example

Executing the example requires that the repository contains multidimensional calculation on database server with the MDCALC_1 identifier.

Sub UserProc;
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    MDCalc: IMDCalculation;
    Slice: IMDCalculationSlice;
    FormulasTable: IMDCalculationFormulasTable;
    TableForFormulas: ITable;
Begin
    MB := MetabaseClass.Active;
    MObj := MB.ItemById("MDCALC_1").Edit;
    MDCalc := MObj As IMDCalculation;
    Slice := MDCalc.Sources.Item(0).Slices.Item(0);
    Slice.FixType := MDCalculationSliceFixType.Fixed;
    Slice.Fixed.Mapping := MDCalc.Destination.Slices.Item(0);
    // Get formula table
    FormulasTable := MDCalc.FormulasTable;
    Try
        // Check
        FormulasTable.Check;
    Except
        // If it does not fit, create a new one
        TableForFormulas := FormulasTable.Create;
        FormulasTable.Attach(TableForFormulas);
    End Try;
    MObj.Save;
End Sub UserProc;

After executing the example the structure of the first data source of multidimensional calculation on database server is changed. The first data source dimension is fixed, then the current formulas table is checked. If the table is not suitable for future use, a new one is created.

See also:

IMDCalculationFormulasTable