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:

  1. Specify the repository object in the Type property, to which a cube or a time series database is loaded.

  2. Depending on the specified type, specify the object, to which the loading is executed, in the Cube or Rubricator property.

  3. Determine parameters of binding of dimensions to data source fields in the DimensionBindings collection.

  4. Determine parameters of binding of facts to data source fields in the FactBindings collection.

  5. Initialize the data source, from which the loading is executed. The source must support IDtProvider.

  6. After calling the Load method data is loaded.

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.

Fore Example

Fore.NET Example

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.

Fore Example

Fore.NET Example

See also:

Examples