ICubeCreator

Assembly: Cubes;

Description

The ICubeCreator interface contains properties and methods that are used for automatic creation or editing of standard cubes of repository.

Inheritance Hierarchy

ICubeCreator

Comments

To work with the object:

  1. Create the cube dimensions collection using the Dimensions property. If the new dimensions are saved for the cube, in the RdsDatabase property it is possible to determine the MDM repository, in which the corresponding MDM table dictionaries will be created. If the MDM repository is not determined, MDM table dictionaries will be created in the database determined in the Database property.

  2. Create the cube facts collection using the Facts property.

  3. If table is ready to store the cube data, select the Table and set up the binding of dimensions and facts using the ICubeCreatorDimension.Fields andICubeCreatorFact.Field properties respectively. If the table is missing, the database, specify the database in the Database property, in which the table is created automatically on cube creation. All bindings are also automatically set up.

  4. To create a cube, call the CreateCube method; to edit the existing cube structure, call the EditCube method.

To work with objects by means of properties and methods of the ICubeCreator interface, it is required that the database server is based on Oracle 9.x DBMS or later, or Microsoft SQL Server 2008 or later.

Properties

  Property name Brief description
AdditionalFields

The AdditionalFields property returns collection of additional fields that are not linked to cube dimensions or facts.
Database

The Database property determines database, in which a table to store the cube data is created.
DictionaryParent

The DictionaryParent property determines the folder, in which objects required for cube are created.
Dimensions

The Dimensions property returns the dimensions collection of created cube.
Facts

The Facts property returns the facts collection of created cube.
RdsDatabase

The RdsDatabase property determines the MDM repository, in which the dictionaries, corresponding to the cube dimensions, are created.
Table

The Table property determines the table to store the data of created cube.
UseNameAttribute

The UseNameAttribute property determines whether to use the Name attribute on cube creation.

Methods

  Method name Brief description
CreateCube

The CreateCube method creates and sets up a standard cube.
EditCube

The EditCube method edits the structure of the specified cube according to the determined settings of the current object.

See also:

Cubes Assembly Interfaces