OMBRETRIEVE CUBE

retrieveCubeCommand

This clause retrives information about a CUBE and other details such as: PROPERTIES, MEASURES, COMPOSITE_DIMENSION, DIMENSION_USES, IMPLEMENTED_OBJECT, PARTITION, LEVEL, HIERARCHY, AGGREGATE_FUNCTION, AGGREGATE_FUNCTIONS, FOR, DIMENSIONS, PRECOMPUTE_LEVELS, CALCULATED_EXPRESSION, DIMENSION, ROLE, DIMENSION_USE_POSITION.

cubeName

The name of the cube in QUOTED_STRING.

propertyKeyList

The clause sets the list of property keys.

getReferenceIconSetClause

The clauses gets the reference ICONSET.

measureLocator

This clause finds the MEASURE.

dimensionList

This clause retrieves the dimension list.

dimensionUseLocator

The is retrieves DIMENSION_USE.

compositeDimensionLocator

This key locates the COMPOSITE_DIMENSION.

propertyKey

The name of property key in UNQUOTED_STRING.

propertyKey

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
Get 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
Get the Analytical Workspace cube physical object name 

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

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

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

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.

propertyKey

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

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

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

Name: CALCULATED_MEASURE
Type: STRING
Valid Values: 'true', 'false' 
Default: 'false' 
Gets the measure to be aggregatable

Name: AUTO_SOLVE
Type: STRING
Valid Values: 'true', 'false' 
Default: 'false' 
gets the flag to say whether the measure is Auto Solve

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

Name: DATATYPE
Type: STRING
Valid Values: BINARY_DOUBLE, BINARY_FLOAT, BLOB, CHAR, CLOB, DATE, FLOAT, INTEGER, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, NCHAR, NCLOB, NUMBER, NVARCHAR2, RAW, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, VARCHAR, VARCHAR2, XMLFORMAT 
Default: NUMBER 
Gets the datatype of a Cube Measure 

Name: SCALE
Type: NUMBER
Valid Values: -85 - 125
Default: 1
The scale of a number.

Name: LENGTH
Type: NUMBER
Valid Values: 
Default: 1
The length of a number 

Name: PRECISION
Type: NUMBER
Valid Values: 0 - 39
Default: 1
The precision of a number. 


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

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

Name: DIMENSION_USE_POSITION
Type: INTEGER
Valid Values: Any valid character string in supported character set.
Default: Empty string

measureName

The name of the measure in QUOTED_STRING.

dimension

The name of the dimensin in QUOTED_STRING.

dimensionUseName

The name of dimension use in QUOTED_STRING.

compositeDimensionName

The name of composite dimension in QUOTED_STRING.

CUBE Object