OMBALTER CUBE

alterCubeCommand

This clause alters properties of a CUBE.

cubeName

The name of the cube in QUOTED_STRING.

renameClause

The name of the cube to be renamed in QUOTED_STRING.

alterPropertiesOrIconSetClause

This clause alters properties or Iconsets.

setCubeAggFunctionClause

The clause sets new AGGREGATE_FUNCTION.

alterCubeDescendentsClause

This clause alter sub clauses.

cubeImplementationClause

The clause alter the cube IMPLEMENTED BY clause.

cubePartitionClause

The clause alters PARTITION, LEVEL, HIERARCHY, and DIMENSION.

alterCubeUnBindingClause

This clause unbinds a cube.

setPropertiesClause

This clause set PROPERTIES.

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

This clause sets the reference to ICONSET.

unsetReferenceIconSetClause

This clause unsets ICONSET.

aggFunctionName

The name of the aggregation function.

addMeasureClause

The clause adds a measure.

addDimensionUseClause

The clause adds a DIMENSION_USE.

addCompositeDimensionClause

This clause adds COMPOSITE_DIMENSION

modifyMeasureClause

This clause modifies a measure, uses sub clauses.

modifyDimensionUseClause

This clause modifies a dimension use.

modifyCompositeDimensionClause

This clause modifies a composite dimension.

measureLocator

This clause finds a measure.

compositeDimensionLocator

This clause finds a COMPOSITE_DIMENSION.

dimensionUseLocator

The clause finds a DIMENSION_USE.

cubeBindingClause

This clause binds cube to a TABLE or VIEW.

measureBindingClause

This clause binds a measure to a COLUMN.

dimensionUseBindingClause

This clause binds a dimension use to a COLUMN.

cubeAutoBindingClause

This clause automatically binds cube to a table/View.

levelName

The name of level in QUOTED_STRING.

hierName

The name of hierarchy in QUOTED_STRING.

dimensionName

The name of the dimension in QUOTED_STRING.

propertyKeyList

The list of properties.

propertyValueList

The list of values of properties in corresponding order.

measureName

The name of the measure in QUOTED_STRING.

setAggFunctionClause

This clause sets AGGREGATE_FUNCTIONS FOR DIMENSIONS.

setPreComputedLevelsClause

This clause sets PRECOMPUTE_LEVELS.

setCalcExprClause

This clause sets CALCULATED_EXPRESSION.

dimensionUseName

The name of the dimension use in QUOTED_STRING.

setDimensionUseReferenceClause

This clause ROLE, LEVEL, DIMENSION.

compositeDimensionName

The name of the composite dimension as a QUOTED_STRING.

setCompositeDimensionReferenceClause

This clause sets reference to Composite Dimension.

moveToClause

The is clause moves to a POSITION given by an INTEGER_LITERAL.

modifyDimensionUseRoleClause

This clause modifies dimension use's role.

tableName

The name of the table in QUOTED_STRING.

viewName

The name of the view in QUOTED_STRING.

columnName

The name of the column in QUOTED_STRING.

propertyKey

The name of property key in UNQUOTED_STRING

propertyValue

The property values are given by QUOTED_STRING, INTEGER_LITERAL, FLOATING_POINT_LITERAL.

aggFunctionList

The list of aggregation functions.

dimensionList

The list of dimensions.

preComputedLevelList

The list of precomputed levels.

calcExpr

The name of the calculated expression in QUOTED_STRING.

roleName

The name of the role in QUOTED_STRING.

roleLocator

This clause if for finding the role.

aggFunction

The name of the aggregation function given in QUOTED_STRING.

dimension

The name of the dimension given in QUOTED_STRING.

preComputedLevel

The name of the precomputed level given in QUOTED_STRING.

CUBE Object