OMBCREATE DIMENSION

createDimensionCommand

This clause alter the properties of a dimension.

dimensionName

The name of the dimension in QUOTED_STRING.

setPropertiesClause

This clause sets the PROPERTIES.

setPropertiesClause

Basic properties for DIMENSION, DIMENSION_ATTRIBUTE, LEVEL, LEVEL_ATTRIBUTE and HIERARCHY: 

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

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

Name: SCD_TYPE
Type: INTEGER
Valid Values: 1, 2, 3
Default: 1 
Slowly changing policy to be applied on the dimension. Give Integer values 1, 2, 3 
for Slowly changing type one, two and three 

Name: LOAD_POLICY_FOR_NULL_KEY
Type: STRING
Valid Values: 'NO_MAINTENANCE', 'NO_MAINTENANCE_WITH_ERROR_TABLE', 'REJECT', 'DEFAULT_PARENT' 
Default: 'NO_MAINTENANCE' 
Data policy for loading dimension 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 dimension where OWB mapping code will actively detect the orphans (level records without parent) and reject them. 
'DEFAULT_PARENT', the policy for loading dimension 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_PARENT' 
Default: 'NO_MAINTENANCE' 
Data policy for loading dimension 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 dimension where OWB mapping code will actively detect the orphans (level records without parent) and reject them. 
'DEFAULT_PARENT', the policy for loading dimension where OWB mapping code will actively detect the orphans (level records without parent) and assign them under default parent.

Name: REMOVE_POLICY
Type: STRING
Valid Values: 'NO_MAINTENANCE', 'NO_MAINTENANCE_WITH_ERROR_TABLE', 'REJECT' 
Default: 'NO_MAINTENANCE' 
Data policy for remove dimension data where OWB relies on database 
constraints to detect removal of parent records who still have child records.  
'NO_MAINTENANCE', 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', data policy for loading dimension where OWB mapping code will actively 
reject the removal of parent records who still have child records. 
#'CASCADE', data policy for removing dimension data where OWB mapping code will  
#actively detect the removal of parent records who still have child records,  
#and remove all of the descendents.

setPropertiesClause

Name: TYPE
Type: STRING
Valid Values: 'NONE', 'TIME'
Default: 'NONE' 
'NONE'  it does not recognize it as any specific type of dimension. 
'TIME' dimension is a time dimension 

Name: OLAP_TYPE
Type: STRING
Valid Values: NONE, TIME 
Default: NONE 
Dimension type for OLAP, get regular dimension 'NONE' and for OLAP Time Dimension 'TIME' 

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, AW 
Default: 'RELATIONAL' 
The storage of a dimension can be AW or relational 

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 dimension is implemented 

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

Name: USE_BUSINESS_KEYS
Type: STRING
Valid Values: true, false 
Default: false
Set the flag for Analytical Workspace dimension to use Business Keys as data source

setPropertiesClause

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

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

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
Default: NUMBER 
Sets the datatype of a Dimension_Attribute 

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.

setPropertiesClause

Name: DESCRIPTOR
Type: STRING
Valid Values: NONE, SHORT_DESCRIPTION, LONG_DESCRIPTION, END_DATE, TIME_SPAN, PRIOR_PERIOD, YEAR_AGO_PERIOD
Default: NONE
The following properties are set on dimension attribute so that it is recognized by OLAP service 
'NONE' it is not specially recognized type by OLAP service 
'SHORT_DESCRIPTION' sets as a short description  
'LONG_DESCRIPTION' sets as a long description  
'END_DATE' sets as a last date of a period. 
'TIME_SPAN' sets as a number of days in a period. 
'PRIOR_PERIOD' sets as the prior period number. 
'YEAR_AGO_PERIOD' sets as the time period a year before this period 

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

setPropertiesClause

Name: TYPE
Type: STRING
Valid Values: NONE, START_DATE, END_DATE, TIME_SPAN
Default: NONE 
'NONE'  dimension attribute so OWB does not recognize it as any specific type. 
'START_DATE' dimension attribute of time dimension as the start date of a period 
'END_DATE' dimension attribute of time dimension as the end date of a period 
'TIME_SPAN' dimension attribute of time dimension as the time span  

Name: AW_ATTRIBUTE_NAME
Type: STRING(32)
Valid Values: Any valid character string in supported character set.
Default: Empty string
set the AW object name implementing the dimension attribute 


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

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

Name: TYPE
Type: STRING
Valid Values: NONE, DAY, FISCAL_WEEK, FISCAL_MONTH, FISCAL_QUARTER, FISCAL_YEAR, CALENDAR_WEEK, CALENDAR_MONTH, CALENDAR_QUARTER, CALENDAR_YEAR 
Default: NONE 
For regular relational dimension level (non-time dimension level) use 'NONE'. For relational time dimension use other values.

Name: OLAP_TYPE
Type: STRING
Valid Values: NONE,DAY,MONTH,QUARTER,YEAR,TOTAL 
Default: NONE 
Level has an olap-type for OLAP-based levels; use 'NONE' for regular levels, and other values for OLAP Time Dimension 

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


Basic properties for Level_Attribute :
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string

setPropertiesClause

Business name of the Level_Attribute 

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

Name: DEFAULT_VALUE
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
This is used to construct the default parent policy for loading data into dimesion.

Name: OLAP_TYPE
Type: STRING
Valid Values: NONE, SHORT_DESCRIPTION, END_DATE, TIME_SPAN, PRIOR_PERIOD, YEAR_AGO_PERIOD 
Default: NONE
The following properties are set on level attribute so that it is recognized by OLAP service 
'NONE' it is not specially recognized type by OLAP service 
'SHORT_DESCRIPTION' sets as a short description  
'END_DATE' sets as a last date of a period. 
'TIME_SPAN' sets as a number of days in a period. 
'PRIOR_PERIOD' sets as the prior period number. 
'YEAR_AGO_PERIOD' sets as the time period a year before this period

setPropertiesClause

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

Name: TYPE
Type: STRING
Valid Values: NONE, START_DATE, END_DATE, TIME_SPAN
Default: 'NONE' 
'NONE'  level attribute so OWB does not recognize it as any specific type. 
'START_DATE' level attribute of time dimension as the start date of a period 
'END_DATE' level attribute of time dimension as the end date of a period 
'TIME_SPAN' level attribute of time dimension as the time span  

Name: TYPE_TWO_SCD_EFFECTIVE_DATE
Type: STRING
Valid Values: true, false 
Default: false 
The level attribute is defined as Effective Date for Slowly changing type 2 

Name: TYPE_TWO_SCD_EXPIRATION_DATE
Type: STRING
Valid Values: true, false
Default: false 
The level attribute is defined as Expiration Date for Slowly changing type 2 

Name: TYPE_TWO_SCD_TRIGGER
Type: STRING
Valid Values: true, false 
Default: false 
The level attribute is defined as Trigger for saving history for Slowly changing type 2 

Name: TYPE_THREE_SCD_EFFECTIVE_DATE
Type: STRING
Valid Values: true, false 
Default: false 
The level attribute is defined as Effective Date for Slowly changing type 3 


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

setPropertiesClause

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

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

Name: TYPE
Type: STRING
Valid Values: NONE, FISCAL, CALENDAR_YEAR, CALENDAR_WEEK
Default: NONE 
'NONE'  hierarchy so OWB does not recognize it as any specific type. 
'FISCAL' fiscal hierarchy for time dimension 
'CALENDAR_YEAR' calendar year hierarchy time dimension 
'CALENDAR_WEEK' calendar week hierarchy time dimension 

Name: DEFAULT_DISPLAY
Type: STRING
Valid Values: true, false 
Default: false 
The hierarchy is set as Default display hierarchy 

Name: VALUE_BASED
Type: STRING
Valid Values: true, false 
Default: false 
Sets the flag to define a Value Based Hierarchy for AW only

setReferenceIconSetClause

This clause sets the reference to an ICONSET.

setDimensionKeySequenceClause

This clause sets the dimension key SEQUENCE.

addSurrogateKeyDimensionAttributeClause

This clause adds DIMENSION_ATTRIBUTE as a SURROGATE_KEY.

addParentKeyDimensionAttributeClause

This clause adds a DIMENSION_ATTRIBUTE as a PARENT_KEY.

addDimensionAttributeClause

This clause adds DIMENSION_ATTRIBUTE as a BUSINESS_KEY.

addDimensionRoleClause

This clause adds a DIMENSION_ROLE.

addLevelClause

This clause adds a LEVEL.

addLevelAttributeClause

This clause adds a LEVEL_ATTRIBUTE.

addHierarchyClause

This clause adds a HIERARCHY.

addSkipLevelsClause

This clause adds SKIP_LEVELS.

createDimensionBindingClause

This clause creates dimension binding clauses.

propertyKeyList

The property list clause.

propertyValueList

The property value list clause.

sequenceName

The sequence name in QUOTED_STRING.

dimensionAttributeName

The dimension attribute name in QUOTED_STRING.

roleName

The name of the role in QUOTED_STRING.

levelName

The name of the level in a QUOTED_STRING

levelAttributeName

The name of the level attribute in a QUOTED_STRING

levelLocator

This clause finds a LEVEL

setLevelAttributeReferenceClause

This clause sets level attribute reference clause.

hierarchyName

The name of the hierarchy in QUOTED_STRING.

hierarchyLevelReferenceClause

This is hierarchy level reference clause.

hierarchyLocator

This clause finds a HIERARCHY

columnName

The name of the column in QUOTED_STRING

levelBindingClause

This clause binds a level to a table or view.

levelAttributeBindingClause

This clause binds a LEVEL_ATTRIBUTE to a column.

setBindRelationshipClause

This clause binds LEVEL_RELATIONSHIP to a COLUMN.

setSkipBindRelationshipClause

This clause binds SKIP_LEVEL_RELATIONSHIP to a COLUMN.

propertyKey

The property key.

propertyValue

The property key value: QUOTED_STRING, INTEGER_LITERAL, FLOATING_POINT_LITERAL

dimensionAttributeLocator

This clause finds a DIMENSION_ATTRIBUTE.

levelAttributeLocator

This clause locates a LEVEL_ATTRIBUTE.

tableName

The table name in QUOTED_STRING.

viewName

The view name in QUOTED_STRING.

DIMENSION Object