IRubricatorInstance.CreateObservationsLookup

Syntax

CreateObservationsLookup(FactData: IRubricatorFactData): IRubricatorObservationsLookup;

Parameters

FactData. Data of the time series, in which the search is executed.

Description

The CreateObservationsLookup method creates an object searching among indicators data.

Example

Executing the example requires that the repository contains a time series database with the OBJ_RUBRICATOR identifier. This database must contain an indicator attribute with the COUNTRIES identifier.

Sub UserProc;
Var
    MB: IMetabase;
    RubrInst: IRubricatorInstance;
    FactsLookup: IRubricatorFactsLookup;
    MetaDLookup: IMetaDictionaryLookup;
    ObservLookup: IRubricatorObservationsLookup;
    Key: Array Of Integer;
    i: Integer;
    Cond: IOrmCondition;
Begin
    MB := MetabaseClass.Active;
    RubrInst := MB.ItemById("OBJ_RUBRICATOR").Open(Null) As IRubricatorInstance;
    FactsLookup := RubrInst.CreateFactsLookup;
    MetaDLookup := FactsLookup.Lookup;
    Cond := MetaDLookup.Where.Add;
    Cond.AttributeName := "COUNTRIES";
    Cond.Value := 512;
    ObservLookup := RubrInst.CreateObservationsLookup(Null);
    ObservLookup.WhereCalendarLevel := DimCalendarLevel.Year;
    i := RubrInst.LookupFactors(FactsLookup, ObservLookup).Length;
    Key := New Integer[i];
    Key := RubrInst.LookupFactors(FactsLookup, ObservLookup);
End Sub UserProc;

After executing the example the Key array contains indicators keys that satisfy the following conditions: annual frequency is present in the indicator, and the COUNTRIES attribute value equals to 512.

See also:

IRubricatorInstance