OMBCREATE CUBE

createCubeCommand

This command creates a cube.

cubeName

The name of the cube.

setPropertiesClause

Sets the properties of the cube.

setPropertiesClause

Basic properties for CUBE, MEASURE and  DIMENSION_USE: 

Basic properties for CUBE :
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the Cube 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the Cube 

Name: OLAP_USER_VISIBLE
Type: STRING
Valid Values: 'true', 'false' 
Default: 'true' 
The dimension is visible to OLAP end user 

Name: UNIQUE_KEY_CONSTRAINT
Type: STRING
Valid Values: 'true', 'false' 
Default: 'false' 
set the Unique Key constraint on the Business Key 

Name: STORAGE
Type: STRING
Valid Values: 'RELATIONAL', 'MOLAP' 
Default: 'RELATIONAL' 
The storage of a cube can be relational or molap

Name: AW_NAME
Type: STRING(32)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Set the analytical workspace name where the cube is implemented 

Name: AW_CUBE_NAME
Type: STRING(32)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Set the Analytical Workspace cube physical object name 

Name: USE_GLOBAL_INDEX
Type: STRING
Valid Values: 'true', 'false' 
Default: 'false' 
Sets the flag to say whether to generate a composite for measure partition combination

Name: BITMAP_INDEX
Type: STRING
Valid Values: 'true', 'false' 
Default: 'false' 
Sets the flag to say whether to generate a bitmap for a cube

Name: SUMMARY_REFRESH_METHOD
Type: STRING
Valid Values: 'On Demand', 'On Commit' 
Default: 'On Commit' 
Sets the Solve flag for Relational Cube whether to solve the cube 'On Demand' or 'On Commit'

Name: SPARSITY_ULTRA_COMPRESS
Type: STRING
Valid Values: 'true', 'false' 
Default: 'false' 
Sets the flag to say whether its a compressed cube. Only valid for Molap cube.

setPropertiesClause

Name: LOAD_POLICY_FOR_NULL_KEY
Type: STRING
Valid Values: 'NO_MAINTENANCE', 'NO_MAINTENANCE_WITH_ERROR_TABLE', 'REJECT', 'DEFAULT_DIMENSION_RECORD' 
Default: 'NO_MAINTENANCE' 
Data policy for loading cube where OWB mapping code relies on 
database constraints to detect the orphans (null parent references). 
'NO_MAINTENANCE', OWB does not actively enforce the parentage integrity rule that requires every child record to have a parent. 
'NO_MAINTENANCE_WITH_ERROR_TABLE', Same as NO_MAINTENANCE, and additionally error table will be deployed, thus orphan management can be switched on at the map level. 
'REJECT', the policy for loading cube where OWB mapping code will actively detect the orphans (level records without parent) and reject them. 
'DEFAULT_DIMENSION_RECORD', the policy for loading cube where OWB mapping code will actively detect the orphans (level records without parent) and assign them under default parent.

Name: LOAD_POLICY_FOR_INVALID_KEY
Type: STRING
Valid Values: 'NO_MAINTENANCE', 'NO_MAINTENANCE_WITH_ERROR_TABLE', 'REJECT', 'DEFAULT_DIMENSION_RECORD' 
Default: 'NO_MAINTENANCE' 
Data policy for loading cube where OWB mapping code relies on 
database constraints to detect the orphans (could contain a value that is not actually found in the parent). 
'NO_MAINTENANCE', OWB does not actively enforce the parentage integrity rule that requires every child record to have a parent. 
'NO_MAINTENANCE_WITH_ERROR_TABLE', Same as NO_MAINTENANCE, and additionally error table will be deployed, thus orphan management can be switched on at the map level. 
'REJECT', the policy for loading cube where OWB mapping code will actively detect the orphans (level records without parent) and reject them. 
'DEFAULT_DIMENSION_RECORD', the policy for loading cube where OWB mapping code will actively detect the orphans (level records without parent) and assign them under default parent.

setReferenceIconSetClause

References to ICONSET.

setCubeAggFunctionClause

This clauses sets the AGGREGATE_FUNCTION.

addMeasureClause

This clause add a measure.

addDimensionUseClause

This clause adds a dimension use clause.

addCompositeDimensionClause

This clause creates a COMPOSITE_DIMENSION.

cubeImplementationClause

This clause creates the IMPLEMENTED object, Table or View.

propertyKeyList

This clause sets a list of properties.

propertyValueList

Part of the property list values.

aggFunctionName

Name of aggregation function name.

measureName

Name of a measure.

setAggFunctionClause

The is clause sets AGGREGATE_FUNCTIONS FOR DIMENSIONS.

setPreComputedLevelsClause

This clause sets the PRECOMPUTE_LEVELS.

setCalcExprClause

This clause sets CALCULATED_EXPRESSION

dimensionUseName

Dimension Use's name.

setDimensionUseReferenceClause

This clause sets ROLE, LEVEL, DIMENSION

compositeDimensionName

Name of the composite dimension.

setCompositeDimensionReferenceClause

This clause sets a reference to a composite dimension.

cubeBindingClause

This clause binds a cube to a TABLE or VIEW.

measureBindingClause

This clause bind a measure to a COLUMN.

dimensionUseBindingClause

This clause binds a dimension use to a COLUMN.

cubeAutoBindingClause

Auto binding using SYSTEM.

propertyKey

The property key name.

propertyValue

The property value in QUOTED_STRING, INTEGER_LITERAL, or FLOATING_POINT_LITERAL.

aggFunctionList

Aggregation function list.

dimensionList

Dimension List.

preComputedLevelList

Precompute Level list.

calcExpr

Name of the Calculated Express in QUOTED_STRING.

roleName

Name of the role in QUOTED_STRING.

levelName

Name of level name in QUOTED_STRING.

dimensionName

Name of dimension name in QUOTED_STRING.

tableName

Name of in table name in QUOTED_STRING.

viewName

Name of view name in QUOTED_STRING.

measureLocator

This clause finds the MEASURE.

columnName

Name of a column in QUOTED_STRING.

dimensionUseLocator

This clause finds the DIMENSION_USE.

aggFunction

Name of aggregated function QUOTED_STRING

dimension

Name of dimension QUOTED_STRING

preComputedLevel

Name of pre-computed level in QUOTED_STRING

CUBE Object