Component: CREATE CUBE

The following table describes the fields of the Create Cube.

Table 11-8 Fields in the Create Cube and their Description

Field	Description
Cube Parameter	Refers to the cube identifier as defined through the Business Metadata (Cube) menu option. Select the cube code from the drop-down list.
Operation	Refers to the operation to be performed. Select the required Operation from the drop-down list. The options are: ALL – This option will execute BUILDDB and DLRU. BUILDDB – This option should be used to build the outline in Essbase Cube. The outline is built based on the parentage file(s) contents. TUNEDB – This option should be used to analyze data and optimize cube settings. For example, if you are trying to achieve the best block size, where 64K bytes is the ideal size. PROCESSDB – This option will execute BUILDDB and DLRU, and is same as All option. Selecting this option will internally assign as ALL. DLRU – This option should be used to Load Data in the Essbase Cube and trigger a Rollup. ROLLUP – ROLLUP refers to populating data in parent nodes based on calculations (E.g. Addition). This option should be used to trigger just the ROLLUP option where in the CALC scripts are executed. The same is applicable for DLRU option also. VALIDATE – This option will validate the outline. DELDB – This option will delete the Essbase cube. OPTSTORE – This option will create the Optimized outline for the cube.

Field

Description

Cube Parameter

Refers to the cube identifier as defined through the Business Metadata (Cube) menu option. Select the cube code from the drop-down list.

Operation

Refers to the operation to be performed. Select the required Operation from the drop-down list. The options are:

ALL – This option will execute BUILDDB and DLRU.
BUILDDB – This option should be used to build the outline in Essbase Cube. The outline is built based on the parentage file(s) contents.
TUNEDB – This option should be used to analyze data and optimize cube settings. For example, if you are trying to achieve the best block size, where 64K bytes is the ideal size.
PROCESSDB – This option will execute BUILDDB and DLRU, and is same as All option. Selecting this option will internally assign as ALL.
DLRU – This option should be used to Load Data in the Essbase Cube and trigger a Rollup.
ROLLUP – ROLLUP refers to populating data in parent nodes based on calculations (E.g. Addition). This option should be used to trigger just the ROLLUP option where in the CALC scripts are executed. The same is applicable for DLRU option also.
VALIDATE – This option will validate the outline.
DELDB – This option will delete the Essbase cube.
OPTSTORE – This option will create the Optimized outline for the cube.