ICubeCreator

Assembly: Cubes;

Namespace: Prognoz.Platform.Interop.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