Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
 

OMBALTER CUBE

Purpose

This command alters a Cube.

Prerequisites

Should be in Oracle Module context.

Syntax

alterCubeCommand =  OMBALTER CUBE "cubeName" ( ( "renameClause" [ 
          "alterPropertiesOrIconSetClause" ] [ "setCubeAggFunctionClause" ] [ 
          "alterCubeDescendentsClause" ] [ "cubeImplementationClause" ] ) | 
          "cubePartitionClause" | ( "alterPropertiesOrIconSetClause" [ 
          "setCubeAggFunctionClause" ] [ "alterCubeDescendentsClause" ] [ 
          "cubeImplementationClause" ] ) | ( "setCubeAggFunctionClause" [ 
          "alterCubeDescendentsClause" ] [ "cubeImplementationClause" ] ) | ( 
          "alterCubeDescendentsClause" [ "cubeImplementationClause" ] ) | 
          "cubeImplementationClause" | "alterCubeUnBindingClause" )
     cubeName =  "QUOTED_STRING"
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( ( "setPropertiesClause" [ ( SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ) ] 
          ) | "setReferenceIconSetClause" ) | UNSET 
          "unsetReferenceIconSetClause"
     setCubeAggFunctionClause =  SET AGGREGATE_FUNCTION TO "aggFunctionName"
     alterCubeDescendentsClause =  ( ADD ( "addMeasureClause" | 
          "addDimensionUseClause" | "addCompositeDimensionClause" ) | MODIFY ( 
          "modifyMeasureClause" | "modifyDimensionUseClause" | 
          "modifyCompositeDimensionClause" ) | DELETE ( "measureLocator" | 
          "compositeDimensionLocator" | "dimensionUseLocator" ) )+
     cubeImplementationClause =  IMPLEMENTED BY ( ( "cubeBindingClause" { 
          "measureBindingClause" | "dimensionUseBindingClause" } ) | 
          "cubeAutoBindingClause" )
     cubePartitionClause =  ( SET PARTITION LEVEL "levelName" OF HIERARCHY 
          "hierName" OF DIMENSION "dimensionName" )
     alterCubeUnBindingClause =  DELETE BINDING 
     setPropertiesClause =  PROPERTIES "propertyKeyList" VALUES 
          "propertyValueList"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     aggFunctionName =  "QUOTED_STRING"
     addMeasureClause =  MEASURE "measureName" [ SET "setPropertiesClause" ] [ 
          "setAggFunctionClause" ] [ "setPreComputedLevelsClause" ] [ 
          "setCalcExprClause" ]
     addDimensionUseClause =  DIMENSION_USE "dimensionUseName" [ SET 
          "setPropertiesClause" ] [ "setDimensionUseReferenceClause" ] [ AT 
          POSITION "INTEGER_LITERAL" ]
     addCompositeDimensionClause =  COMPOSITE_DIMENSION "compositeDimensionName"
           [ SET "setPropertiesClause" ] [ 
          "setCompositeDimensionReferenceClause" ]
     modifyMeasureClause =  "measureLocator" ( "renameClause" | SET 
          "setPropertiesClause" | "setAggFunctionClause" | 
          "setPreComputedLevelsClause" | "setCalcExprClause" )
     modifyDimensionUseClause =  "dimensionUseLocator" ( "renameClause" | 
          "moveToClause" | SET "setPropertiesClause" | 
          "modifyDimensionUseRoleClause" )
     modifyCompositeDimensionClause =  "compositeDimensionLocator" ( 
          "renameClause" | SET "setPropertiesClause" | 
          "setCompositeDimensionReferenceClause" )
     measureLocator =  MEASURE "measureName"
     compositeDimensionLocator =  COMPOSITE_DIMENSION "compositeDimensionName"
     dimensionUseLocator =  DIMENSION_USE "dimensionUseName"
     cubeBindingClause =  ( TABLE "tableName" | VIEW "viewName" )
     measureBindingClause =  "measureLocator" BOUND TO COLUMN "columnName"
     dimensionUseBindingClause =  "dimensionUseLocator" BOUND TO COLUMN 
          "columnName"
     cubeAutoBindingClause =  SYSTEM
     levelName =  "QUOTED_STRING"
     hierName =  "QUOTED_STRING"
     dimensionName =  "QUOTED_STRING"
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     propertyValueList =  "(" "propertyValue" { "," "propertyValue" } ")"
     measureName =  "QUOTED_STRING"
     setAggFunctionClause =  SET AGGREGATE_FUNCTIONS "aggFunctionList" FOR 
          DIMENSIONS "dimensionList"
     setPreComputedLevelsClause =  SET PRECOMPUTE_LEVELS "preComputedLevelList"
     setCalcExprClause =  SET CALCULATED_EXPRESSION "(" "calcExpr" ")"
     dimensionUseName =  "QUOTED_STRING"
     setDimensionUseReferenceClause =  [ USE ROLE "roleName" ] SET ( REF | 
          REFERENCE ) [ LEVEL "levelName" OF ] DIMENSION "dimensionName"
     compositeDimensionName =  "QUOTED_STRING"
     setCompositeDimensionReferenceClause =  SET ( REF | REFERENCE ) DIMENSIONS 
          "(" "dimensionName" { "," "dimensionName" } ")"
     moveToClause =  MOVE TO POSITION "INTEGER_LITERAL"
     modifyDimensionUseRoleClause =  SET "roleLocator" | UNSET "roleLocator"
     tableName =  "QUOTED_STRING"
     viewName =  "QUOTED_STRING"
     columnName =  "QUOTED_STRING"
     propertyKey =  "UNQUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     aggFunctionList =  "(" "aggFunction" { "," "aggFunction" } ")"
     dimensionList =  "(" "dimension" { "," "dimension" } ")"
     preComputedLevelList =  "(" "preComputedLevel" { "," "preComputedLevel" } 
          ")"
     calcExpr =  "QUOTED_STRING"
     roleName =  "QUOTED_STRING"
     roleLocator =  ROLE "roleName"
     aggFunction =  "QUOTED_STRING"
     dimension =  "QUOTED_STRING"
     preComputedLevel =  "QUOTED_STRING"

Parameters

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

Table 2-2 CUBE Object

Property Type Choices Min Max Default Description

COSTBASEDPERCENTAGE

NUMBER

none

none

none

0

Cost Based Aggregation

DEPLOYABLE

BOOLEAN

true, false

none

none

true

Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true

DEPLOYMENT_OPTIONS

STRING

DEPLOY_AGGREGATION, DEPLOY_ALL, DEPLOY_DATA_OBJECTS_ONLY, DEPLOY_TO_CATALOG_ONLY

none

none

DEPLOY_DATA_OBJECTS_ONLY

Warehouse Builder generates a set of scripts for cube, they are DDL Scripts for Relational Cube or Scripts for OLAP API-II or Scripts for AW.

ENABLE_MV_REFRESH

BOOLEAN

true, false

none

none

false

Enable MV Refresh

ERROR_TABLE_COLUMN_NAMES

STRING

none

none

none

empty string

 

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

MATERIALIZED_VIEW_INDEX_TABLESPACE

STRING

none

none

none

USERS

Tablespace for materialized view indexes.

MATERIALIZED_VIEW_TABLESPACE

STRING

none

none

none

USERS

Tablespace for materialized view.

MVCONSTRAINTS

STRING

, ENFORCED, TRUSTED

none

none

TRUSTED

MV Constraints

NEXTDATE

STRING

none

none

none

empty string

Refresh Next Date

QUERY_REWRITE

STRING

, DISABLE, ENABLE

none

none

DISABLE

Enable Query Rewrite

REFRESH

STRING

, COMPLETE, FAST, FORCE

none

none

FORCE

Refresh Mode

REFRESH_ON

STRING

, COMMIT, DEMAND, ONDATE

none

none

DEMAND

Refresh On

STARTWITH

STRING

none

none

none

empty string

Refresh Start Date

VISIBLE

BOOLEAN

true, false

none

none

true

The Cube is visible to OLAP end user if value is set = true.