Show contents 

Express > Express Assembly Interfaces > IEaxAnalyzeCore > IEaxAnalyzeCore.ParamProvider

IEaxAnalyzeCore.ParamProvider

Syntax

ParamProvider: Object;

Description

The ParamProvider property returns the object to work with express report parameters.

Comments

After data source parameters editing, the data source must be updated. To update the data provider, use IEaxAnalyzeCore.UpdateParamProvider.

Example

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

Add links to the Dal, Express, Metabase, Ms, Transform system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    MetObj: IMetabaseObject;
    Express: IEaxAnalyzer;
    CreateParam: IMetabaseObjectParam;
    CreateValues: IMetabaseObjectParamValues;
    Provider: IMsParamProvider;
    ModelParam: IMsModelParam;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    MetObj := MB.ItemById("EXPRESS").Edit;
    Express := MetObj As IEaxAnalyzer;
    // Create a parameter
    CreateParam := MetObj.Params.Add;
    CreateParam.DataType := DbDataType.Integer;
    CreateParam.Name := "Parameter";
    CreateParam.DefaultValue := 100;
    // Create values for parameter
    CreateValues := CreateParam.Params.CreateEmptyValues;
    CreateValues.Item(0).Value := 150;
    // Set specified values for parameter
    Express.OwnParamValues := CreateValues;
    // Get object that is data provider
    Provider := Express.ParamProvider As IMsParamProvider;
    // Cerate a parameter in data provider
    ModelParam := Provider.Params.Add;
    ModelParam.Name := "Data_Parameter";
    ModelParam.DefaultValue := 1000;
    ModelParam.ParamType := TsParamType.Simple;
    // Update data provider
    Express.UpdateParamProvider;
    // Save changes
    MetObj.Save;
End Sub UserProc;

After executing the example a parameter named Parameter is created in the express report. A parameter named Data_Parameter is created in the data source.

See also:

IEaxAnalyzeCore