Cube Maintenance


myObjectiveOLAP Server enables the creation and maintenance of cubes within the MOODATA analytic workspace.


Cube maintenance


The Cube Explorer window is shown below.   You can select any existing cube from the left available Cubes pane.



Selecting a cube displays the following information:


Object

Details

Dimension Information

Lists the dimensions, dimension descriptions, dimension order

Composite

Names the composite and the dimensions which form part of the a composite dimension on the selected cube.  


Advanced information is shown in the Information pane:


Object

Details

Cube ID

Unique identifier for the internal object name (CUBE.ROW)

Cube Description

Description for the Cube

PostProcess

Name of an OLAP DML program which you want to be executed before data submission is processed.

PreProcess

Name of an OLAP DML

program which you want to be executed after data submission is processed

Internal Object

Identifier if the cube is classed as "Protected" internal.

Cube Type

Cube Data-type

Formula

Boolean, is the cube a formula?


In the lower-left corner the name of the Analytic Workspace where the physical object has been created is displayed.



Pressing the Delete Cube button will cause myObjectiveOLAP to ask if you sure?, if we say Yes to this myObjectiveOLAP will submit a MOO_DELETECUBE Process to the Process Manager.



Information about the deletion will logged and available in the Process Manager details pane:


31DEC12 18:03:24 Finished MOO: Delete Cube

31DEC12 18:03:22 With argument 'JUSTCUBE'  

31DEC12 18:03:22 Running MOO.DELETE.CUBE

31DEC12 18:03:22 Started MOO: Delete Cube



When you press New Cube, you are immediately asked which Analytic Workspace you want to create your cube in:



You can either choose the myObjectiveOLAP Primary Analytic Workspace (MOODATA), which was the default before myObjectiveOLAP 2.9.8.  


Or you can chose a child Analytic Workspace which has been created through Analytical Workspace Control



Once you have chosen which Analytic Workspace to create your cube within, only the dimensions which have been defined within the Analytic Workspace will be available to you for selection:



To define the dimensionality of your cube drag your dimensions from the All My Dimensions panel to the Dimension Information panel:



The order in which your dimensions are shown will control the order in which they are defined within the Oracle OLAP Analytic Workspace.


To composite your cube, you should drag the dimensions from the Dimension Information panel to the Composite Dimensions panel:



To remove a dimension from either the cube definition or the composite drag and drop the dimension from the appropriate panel onto the rubbish-bin icon: