Loading Data to Existing Cube or Time Series Database

The object of the CubeLoaderFromSource class is used to load data. After initializing the object the following actions are required:

Consider the example of loading data from the existing repository table. The table has the following fields:

Loading to Existing Cube

Loading is executed to the standard cube with the S_CUBE identifier. The cube structure has two dimensions: a countries dimension with the COUNTRY identifier and a calendar dimension.

Sub LoadData;
Var
    MB: IMetabase;
    Cube: IStandardCube;
    Dims: IStandardCubeDimensions;
    Loader: ICubeLoaderFromSource;
    Provider: IDtMetabaseProvider;
    Bindings: ICubeLoaderDimensionBindings;
    Binding: ICubeLoaderDimensionBinding;
    FactBinding: ICubeLoaderFactBinding;
Begin
    MB := MetabaseClass.Active;
    //Source table
    Provider := New DtMetabaseProvider.Create;
    Provider.Dataset := MB.ItemById("T_DATA").Bind As IDatasetModel;
    //Cube, to which data is loaded
    Cube := MB.ItemById("S_Cube").Bind As IStandardCube;
    Dims := Cube.Dimensions;
    //Loader of data to cube
    Loader := New CubeLoaderFromSource.Create;
    Loader.Type := CubeLoaderType.Cube;
    Loader.Cube := Cube;
    //Setting up of bindings of dimensions
    Bindings := Loader.DimensionBindings;
    //Country dimension
    Binding := Bindings.Add("COUNTRY_KEY");
    Binding.AttributeId := "KEY";
    Binding.Dimension := Dims.FindById("COUNTRY");
    Binding.Dictionary := Binding.Dimension.Dimension;
    //Calendar dimension
    Binding := Bindings.AddCalendar("V_DATE", DimCalendarLevel.Year);
    Binding.Dimension := Dims.Calendar;
    //Cube fact
    FactBinding := Loader.FactBindings.Add("VAL");
    FactBinding.FactKey := 1;
    //Loading data
    Loader.Load(Provider, Null);
End Sub LoadData;

Imports Prognoz.Platform.Interop.Cubes;
Imports Prognoz.Platform.Interop.Db;
Imports Prognoz.Platform.Interop.Dimensions;
Imports Prognoz.Platform.Interop.Dt;
Imports Prognoz.Platform.Interop.Metabase;

Public Shared Sub LoadData1(MB: IMetabase);
Var
    Cube: IStandardCube;
    Dims: IStandardCubeDimensions;
    Loader: CubeLoaderFromSource = New CubeLoaderFromSourceClass();
    Provider: DtMetabaseProvider = New DtMetabaseProviderClass();
    Bindings: ICubeLoaderDimensionBindings;
    Binding: ICubeLoaderDimensionBinding;
    FactBinding: ICubeLoaderFactBinding;
    //Result: ICubeLoaderResult;
Begin
    //Source table
    Provider.Dataset := MB.ItemById["T_DATA"].Bind() As IDatasetModel;
    //Cube, to which data is loaded
    Cube := MB.ItemById["S_Cube"].Bind() As IStandardCube;
    Dims := Cube.Dimensions;
    //Loader of data to cube
    Loader.Type := CubeLoaderType.cltCube;
    Loader.Cube := Cube;
    //Setting up of bindings of dimensions
    Bindings := Loader.DimensionBindings;
    //Country dimension
    Binding := Bindings.Add("COUNTRY_KEY");
    Binding.AttributeId := "KEY";
    Binding.Dimension := Dims.FindById("COUNTRY");
    Binding.Dictionary := Binding.Dimension.Dimension;
    //Calendar dimension
    Binding := Bindings.AddCalendar("V_DATE", DimCalendarLevel.dclYear);
    Binding.Dimension := Dims.Calendar;
    //Cube fact
    FactBinding := Loader.FactBindings.Add("VAL");
    FactBinding.FactKey := 1;
    //Loading data
    Loader.Load(Provider, Null);
End Sub;

Loading to Existing Time Series Database

Loading is executed to the time series database with the TSDB identifier. The COUNTRY attribute that refers to the countries dictionary is created in the database structure.

Sub LoadData;
Var
    MB: IMetabase;
    Rub: IRubricator;
    Facts: IMetaDictionary;
    Values: IMetaDictionary;
    Loader: ICubeLoaderFromSource;
    Provider: IDtMetabaseProvider;
    Bindings: ICubeLoaderDimensionBindings;
    Binding: ICubeLoaderDimensionBinding;
    FactBinding: ICubeLoaderFactBinding;
Begin
    MB := MetabaseClass.Active;
    //Source table
    Provider := New DtMetabaseProvider.Create;
    Provider.Dataset := MB.ItemById("T_DATA").Bind As IDatasetModel;
    //Time series database, to which data is loaded
    Rub := MB.ItemById("TSDB").Bind As IRubricator;
    Facts := Rub.Facts;
    Values := Rub.Values;
    //Initializing data loader
    Loader := New CubeLoaderFromSource.Create;
    Loader.Type := CubeLoaderType.Rubricator;
    Loader.Rubricator := Rub;
    //Setting up bindings of attributes
    Bindings := Loader.DimensionBindings;
    //Country dimension
    Binding := Bindings.Add("COUNTRY_KEY");
    Binding.AttributeId := "KEY";
    Binding.MetaAttribute := Facts.Attributes.FindById("COUNTRY");
    //Calendar dimension
    Binding := Bindings.AddCalendar("V_DATE", DimCalendarLevel.Year);
    Binding.MetaAttribute := Values.Attributes.FindByTag(MetaAttributeTag.CalendarDate);
    //Binding of the Value attribute
    FactBinding := Loader.FactBindings.Add("VAL");
    FactBinding.MetaAttribute := Values.Attributes.FindByTag(MetaAttributeTag.Value);
    //Loading data
    Loader.Load(Provider, Null);
End Sub LoadData;

Public Shared Sub LoadData(MB: IMetabase);
Var
    Rub: IRubricator;
    Facts: IMetaDictionary;
    Values: IMetaDictionary;
    Loader: CubeLoaderFromSource = New CubeLoaderFromSourceClass();
    Provider: DtMetabaseProvider = New DtMetabaseProviderClass();
    Bindings: ICubeLoaderDimensionBindings;
    Binding: ICubeLoaderDimensionBinding;
    FactBinding: ICubeLoaderFactBinding;
Begin
    //Source table
    Provider.Dataset := MB.ItemById["T_DATA"].Bind() As IDatasetModel;
    //Time series databse, to which data is loaded
    Rub := MB.ItemById["TSDB"].Bind() As IRubricator;
    Facts := Rub.Facts;
    Values := Rub.Values;
    //Data loader
    Loader.Type := CubeLoaderType.cltRubricator;
    Loader.Rubricator := Rub;
    //Setting up of bindings of dimensions
    Bindings := Loader.DimensionBindings;
    //Country dimension
    Binding := Bindings.Add("COUNTRY_KEY");
    Binding.AttributeId := "KEY";
    Binding.MetaAttribute := Facts.Attributes.FindById("COUNTRY");
    //Calendar dimension
    Binding := Bindings.AddCalendar("V_DATE", DimCalendarLevel.dclYear);
    Binding.MetaAttribute := Values.Attributes.FindByTag(MetaAttributeTag.meatCalendarDate);
    //Binding of the Value attribute
    FactBinding := Loader.FactBindings.Add("VAL");
    FactBinding.MetaAttribute := Values.Attributes.FindByTag(MetaAttributeTag.meatValue);
    //Loading data
    Loader.Load(Provider, Null);
End Sub;