ICubeMetaLoader.DuplicateCheck

Fore Syntax

DuplicateCheck: CubeLoadDuplicateCheckSet;

Fore.NET Syntax

DuplicateCheck: Prognoz.Platform.Interop.Cubes.CubeLoadDuplicateCheckSet;

Description

The DuplicateCheck property determines a mode of excluding duplicate values.

Comments

To select the time series loading mode, use the ICubeMetaLoader.LoadType property.

Fore Example

Executing the example requires a time series database with the TSDB_IMP identifier containing mandatory custom attributes with the CITY and INDICATOR identifiers. These attributes must be links to the dictionary. The child container of time series database must have several scenarios.

The file system must have the D:\res_export.txt file with data.

Contents of the res_export.txt file

Add links to the Cubes, Db, Dimensions, Dt, Metabase, Ms, Rds system assemblies.

<font color="#008080">Sub</font>&nbsp;UserProc;<br /> <font color="#008080">Var</font><br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider:&nbsp;IDtTextProvider;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Mb:&nbsp;IMetabase;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDBObj:&nbsp;IMetabaseObject;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDB:&nbsp;IRubricator;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Attr:&nbsp;IMetaAttributes;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo:&nbsp;IMetabaseObjectCreateInfo;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Obj:&nbsp;IMetabaseObject;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader:&nbsp;ICubeMetaLoader;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Bindings:&nbsp;ICubeMetaLoaderBindings;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding:&nbsp;ICubeMetaLoaderBinding;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM:&nbsp;IDimensionModel;<br /> <font color="#008080">Begin</font><br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Create&nbsp;data&nbsp;source&nbsp;for&nbsp;import&nbsp;from&nbsp;text&nbsp;file<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;TextProvider&nbsp;:=&nbsp;<font color="#008080">New</font>&nbsp;DtTextProvider.Create;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.File&nbsp;:=&nbsp;<font color="#800000">&quot;D:\res_export.txt&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.FormatType&nbsp;:=&nbsp;DtTextFormatType.Delimited;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.DelimitedColumnDelimiter&nbsp;:=&nbsp;<font color="#800000">&quot;;&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.DelimitedTextQualifier&nbsp;:=&nbsp;<font color="#800000">&quot;&quot;&quot;&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.Encoding&nbsp;:=&nbsp;<font color="#800000">&quot;WIN&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.RangeHasHeader&nbsp;:=&nbsp;<font color="#008080">True</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.Open;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Get&nbsp;time&nbsp;series&nbsp;database<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Mb&nbsp;:=&nbsp;MetabaseClass.Active;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDBObj&nbsp;:=&nbsp;Mb.ItemById(<font color="#800000">&quot;TSDB_IMP&quot;</font>).Bind;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDB&nbsp;:=&nbsp;TSDBObj&nbsp;<font color="#008080">As</font>&nbsp;IRubricator;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Attr&nbsp;:=&nbsp;TSDB.Facts.Attributes;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Create&nbsp;object&nbsp;for&nbsp;loading&nbsp;time&nbsp;series<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;CrInfo&nbsp;:=&nbsp;Mb.CreateCreateInfo;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.ClassId&nbsp;:=&nbsp;MetabaseObjectClass.KE_CLASS_CUBEMETALOADER;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.Parent&nbsp;:=&nbsp;TSDBObj;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.Id&nbsp;:=&nbsp;Mb.GenerateId(<font color="#800000">&quot;CUBEMETALOADER&quot;</font>,&nbsp;TSDBObj.Key);<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.Permanent&nbsp;:=&nbsp;<font color="#008080">False</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Obj&nbsp;:=&nbsp;Mb.CreateObject(CrInfo).Edit;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader&nbsp;:=&nbsp;Obj&nbsp;<font color="#008080">As</font>&nbsp;ICubeMetaLoader;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Specify&nbsp;data&nbsp;source<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.Data&nbsp;:=&nbsp;TextProvider&nbsp;<font color="#008080">As</font>&nbsp;IDatasetDataProvider;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Specify&nbsp;data&nbsp;consumer<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.Rubricator&nbsp;:=&nbsp;TSDB;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;data&nbsp;loading&nbsp;parameters&nbsp;<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.ImportObjectKey&nbsp;:=&nbsp;Obj.Key;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.NewRevisionName&nbsp;:=&nbsp;<font color="#800000">&quot;Data&nbsp;update&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.LoadType&nbsp;:=&nbsp;CubeMetaLoaderLoadType.CreateAndUpdate;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.LoadMode&nbsp;:=&nbsp;CubeLoadClearMode.DataAndMetadata;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.DuplicateCheck&nbsp;:=&nbsp;CubeLoadDuplicateCheckSet.ValueAttribute&nbsp;<font color="#008080">Or</font>&nbsp;CubeLoadDuplicateCheckSet.Value;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Specify&nbsp;scenario,&nbsp;to&nbsp;which&nbsp;data&nbsp;is&nbsp;loaded<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.ScenarioKey&nbsp;:=&nbsp;(TSDB.ModelSpace&nbsp;<font color="#008080">As</font>&nbsp;IMsModelSpace).ScenarioTree.Item(<font color="#008000">0</font>).Key;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;attribute&nbsp;binding<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Bindings&nbsp;:=&nbsp;Loader.Bindings;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;calendar&nbsp;binding<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.Calendar;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.ByColumns&nbsp;:=&nbsp;<font color="#008080">False</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.CalendarDateFormat&nbsp;:=&nbsp;<font color="#800000">&quot;$Year$&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.CalendarOptions.Levels&nbsp;:=&nbsp;DimCalendarLevelSet.Year;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.Name;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;Year&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;of the&nbsp;Units attribute&nbsp;(UNIT)<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.Unit;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.ConstValue;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldValue&nbsp;:=&nbsp;<font color="#008000">1</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Attribute&nbsp;:=&nbsp;<font color="#800000">&quot;UNIT&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM&nbsp;:=&nbsp;Attr.FindById(<font color="#800000">&quot;UNIT&quot;</font>).ValuesObject.Bind&nbsp;<font color="#008080">As</font>&nbsp;IDimensionModel;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Dimension&nbsp;:=&nbsp;DimM;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Index&nbsp;:=&nbsp;DimM.Indexes.Item(<font color="#008000">0</font>).Id;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.KeyAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;of the&nbsp;Cities attribute&nbsp;(CITY)<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.Attribute;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Attribute&nbsp;:=&nbsp;<font color="#800000">&quot;CITY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.Name;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;CITY_KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM&nbsp;:=&nbsp;Attr.FindById(<font color="#800000">&quot;CITY&quot;</font>).ValuesObject.Bind&nbsp;<font color="#008080">As</font>&nbsp;IDimensionModel;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Dimension&nbsp;:=&nbsp;DimM;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Index&nbsp;:=&nbsp;DimM.Indexes.Item(<font color="#008000">0</font>).Id;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.KeyAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.NameAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;NAME&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;of the&nbsp;Indicators attribute&nbsp;(INDICATOR)<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.Attribute;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Attribute&nbsp;:=&nbsp;<font color="#800000">&quot;INDICATOR&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.Name;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;INDICATOR_KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM&nbsp;:=&nbsp;Attr.FindById(<font color="#800000">&quot;INDICATOR&quot;</font>).ValuesObject.Bind&nbsp;<font color="#008080">As</font>&nbsp;IDimensionModel;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Dimension&nbsp;:=&nbsp;DimM;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Index&nbsp;:=&nbsp;DimM.Indexes.Item(<font color="#008000">0</font>).Id;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.KeyAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.NameAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;NAME&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;for&nbsp;import&nbsp;of series&nbsp;observation&nbsp;values<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.Value;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.Name;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;Value&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Load&nbsp;data<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.LoadData;<br /> <font color="#008080">End</font>&nbsp;<font color="#008080">Sub</font>&nbsp;UserProc;

After executing the example the data from the "D:\res_export.txt" file will be imported to the time series database for the first scenario, and duplicate data will be excluded.

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

<font color="#008080">Imports</font>&nbsp;Prognoz.Platform.Interop.Cubes;<br /> <font color="#008080">Imports</font>&nbsp;Prognoz.Platform.Interop.Db;<br /> <font color="#008080">Imports</font>&nbsp;Prognoz.Platform.Interop.Dimensions;<br /> <font color="#008080">Imports</font>&nbsp;Prognoz.Platform.Interop.Dt;<br /> <font color="#008080">Imports</font>&nbsp;Prognoz.Platform.Interop.Ms;<br /> <font color="#008080">Imports</font>&nbsp;Prognoz.Platform.Interop.Rds;<br /> …<br /> <font color="#008080">Public</font>&nbsp;<font color="#008080">Shared</font>&nbsp;<font color="#008080">Sub</font>&nbsp;Main(Params:&nbsp;StartParams);<br /> <font color="#008080">Var</font><br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider:&nbsp;IDtTextProvider;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Mb:&nbsp;IMetabase;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDBObj:&nbsp;IMetabaseObject;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDB:&nbsp;IRubricator;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Attr:&nbsp;IMetaAttributes;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo:&nbsp;IMetabaseObjectCreateInfo;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Obj:&nbsp;IMetabaseObject;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader:&nbsp;ICubeMetaLoader;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Bindings:&nbsp;ICubeMetaLoaderBindings;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding:&nbsp;ICubeMetaLoaderBinding;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM:&nbsp;IDimensionModel;<br /> <font color="#008080">Begin</font><br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Create&nbsp;data&nbsp;source&nbsp;for&nbsp;import&nbsp;from&nbsp;text&nbsp;file<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;TextProvider&nbsp;:=&nbsp;<font color="#008080">New</font>&nbsp;DtTextProvider.Create();<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.File&nbsp;:=&nbsp;<font color="#800000">&quot;D:\res_export.txt&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.FormatType&nbsp;:=&nbsp;DtTextFormatType.tftDelimited;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.DelimitedColumnDelimiter&nbsp;:=&nbsp;<font color="#800000">&quot;;&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.DelimitedTextQualifier&nbsp;:=&nbsp;<font color="#800000">&quot;&quot;&quot;&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.Encoding&nbsp;:=&nbsp;<font color="#800000">&quot;WIN&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.RangeHasHeader&nbsp;:=&nbsp;<font color="#008080">True</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TextProvider.Open();<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Get&nbsp;time&nbsp;series&nbsp;database<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Mb&nbsp;:=&nbsp;Params.Metabase;<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDBObj&nbsp;:=&nbsp;Mb.ItemById[<font color="#800000">&quot;TSDB_IMP&quot;</font>].Bind();<br /> &nbsp;&nbsp;&nbsp;&nbsp;TSDB&nbsp;:=&nbsp;TSDBObj&nbsp;<font color="#008080">As</font>&nbsp;IRubricator;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Attr&nbsp;:=&nbsp;TSDB.Facts.Attributes;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Create&nbsp;object&nbsp;for&nbsp;loading&nbsp;time&nbsp;series<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;CrInfo&nbsp;:=&nbsp;Mb.CreateCreateInfo();<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.ClassId&nbsp;:=&nbsp;MetabaseObjectClass.KE_CLASS_CUBEMETALOADER&nbsp;<font color="#008080">As</font>&nbsp;integer;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.Parent&nbsp;:=&nbsp;TSDBObj;<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.Id&nbsp;:=&nbsp;Mb.GenerateId(<font color="#800000">&quot;CUBEMETALOADER&quot;</font>,&nbsp;TSDBObj.Key);<br /> &nbsp;&nbsp;&nbsp;&nbsp;CrInfo.Permanent&nbsp;:=&nbsp;<font color="#008080">False</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Obj&nbsp;:=&nbsp;Mb.CreateObject(CrInfo).Edit();<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader&nbsp;:=&nbsp;Obj&nbsp;<font color="#008080">As</font>&nbsp;ICubeMetaLoader;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Specify&nbsp;data&nbsp;source<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.Data&nbsp;:=&nbsp;TextProvider&nbsp;<font color="#008080">As</font>&nbsp;IDatasetDataProvider;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Specify&nbsp;data&nbsp;consumer<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.Rubricator&nbsp;:=&nbsp;TSDB;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;data&nbsp;loading&nbsp;parameters&nbsp;<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.ImportObjectKey&nbsp;:=&nbsp;Obj.Key;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.NewRevisionName&nbsp;:=&nbsp;<font color="#800000">&quot;Data&nbsp;refresh&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.LoadType&nbsp;:=&nbsp;CubeMetaLoaderLoadType.cmlltCreateAndUpdate;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.LoadMode&nbsp;:=&nbsp;CubeLoadClearMode.clcmDataAndMetadata;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Loader.DuplicateCheck&nbsp;:=&nbsp;CubeLoadDuplicateCheckSet.cldcValueAttribute&nbsp;<font color="#008080">Or</font>&nbsp;CubeLoadDuplicateCheckSet.cldcValue;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Specify&nbsp;scenario,&nbsp;to&nbsp;which&nbsp;data&nbsp;is&nbsp;loaded<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.ScenarioKey&nbsp;:=&nbsp;(TSDB.ModelSpace&nbsp;<font color="#008080">As</font>&nbsp;IMsModelSpace).ScenarioTree.Item[<font color="#008000">0</font>].Key&nbsp;<font color="#008080">As</font>&nbsp;integer;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;attribute&nbsp;binding<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Bindings&nbsp;:=&nbsp;Loader.Bindings;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;calendar&nbsp;binding<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add();<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.cmlbtCalendar;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.ByColumns&nbsp;:=&nbsp;<font color="#008080">False</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.CalendarDateFormat&nbsp;:=&nbsp;<font color="#800000">&quot;$Year$&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.CalendarOptions.Levels&nbsp;:=&nbsp;DimCalendarLevelSet.dclsYear;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.cmlftName;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;Year&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;of the&nbsp;Units&nbsp;attribute&nbsp;(UNIT)<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add();<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.cmlbtUnit;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.cmlftConstValue;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldValue&nbsp;:=&nbsp;<font color="#008000">1</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Attribute&nbsp;:=&nbsp;<font color="#800000">&quot;UNIT&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM&nbsp;:=&nbsp;Attr.FindById(<font color="#800000">&quot;UNIT&quot;</font>).ValuesObject.Bind()&nbsp;<font color="#008080">As</font>&nbsp;IDimensionModel;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Dimension&nbsp;:=&nbsp;DimM;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Index&nbsp;:=&nbsp;DimM.Indexes.Item[<font color="#008000">0</font>].Id;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.KeyAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;of the&nbsp;Cities attribute&nbsp;(CITY)<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add();<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.cmlbtAttribute;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Attribute&nbsp;:=&nbsp;<font color="#800000">&quot;CITY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.cmlftName;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;CITY_KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM&nbsp;:=&nbsp;Attr.FindById(<font color="#800000">&quot;CITY&quot;</font>).ValuesObject.Bind()&nbsp;<font color="#008080">As</font>&nbsp;IDimensionModel;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Dimension&nbsp;:=&nbsp;DimM;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Index&nbsp;:=&nbsp;DimM.Indexes.Item[<font color="#008000">0</font>].Id;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.KeyAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.NameAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;NAME&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;of the&nbsp;Indicators attribute&nbsp;(INDICATOR)<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add();<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.cmlbtAttribute;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Attribute&nbsp;:=&nbsp;<font color="#800000">&quot;INDICATOR&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.cmlftName;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;INDICATOR_KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;DimM&nbsp;:=&nbsp;Attr.FindById(<font color="#800000">&quot;INDICATOR&quot;</font>).ValuesObject.Bind()&nbsp;<font color="#008080">As</font>&nbsp;IDimensionModel;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Dimension&nbsp;:=&nbsp;DimM;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Index&nbsp;:=&nbsp;DimM.Indexes.Item[<font color="#008000">0</font>].Id;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.KeyAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;KEY&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.NameAttribute&nbsp;:=&nbsp;<font color="#800000">&quot;NAME&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Set&nbsp;binding&nbsp;for&nbsp;import of&nbsp;series&nbsp;observation&nbsp;values<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Binding&nbsp;:=&nbsp;Bindings.Add();<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.BindingType&nbsp;:=&nbsp;CubeMetaLoaderBindingType.cmlbtValue;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.FieldType&nbsp;:=&nbsp;CubeMetaLoaderFieldType.cmlftName;<br /> &nbsp;&nbsp;&nbsp;&nbsp;Binding.Field&nbsp;:=&nbsp;<font color="#800000">&quot;Value&quot;</font>;<br /> &nbsp;&nbsp;&nbsp;&nbsp;<font color="#008000">//&nbsp;Load&nbsp;data<br /> </font>&nbsp;&nbsp;&nbsp;&nbsp;Loader.LoadData();<br /> <font color="#008080">End</font>&nbsp;<font color="#008080">Sub</font>;

See also:

ICubeMetaLoader