Assembly: Cubes;
The ICubeCreator interface contains properties and methods that are used for automatic creation or editing of standard cubes of repository.
ICubeCreator
To work with the object:
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.
Create the cube facts collection using the Facts property.
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.
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.
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. |
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: