Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
retrieveTimeDimensionCommand = OMBRETRIEVE TIME_DIMENSION "TimeDimensionName" ( GET ( PROPERTIES "propertyKeyList" | FISCAL PROPERTIES "propertyKeyList" | DIMENSION_ATTRIBUTES | LEVELS | HIERARCHIES | DIMENSION_ROLES | YEARS | START_YEAR | IMPLEMENTATION_STRATEGY | MAPPING | IMPLEMENTED_OBJECTS ) | "dimensionAttributeDetailClause" | "levelDetailClause" | "hierarchyDetailClause" | "roleDetailClause" ) TimeDimensionName = "QUOTED_STRING" propertyKeyList = "(" "propertyKey" { "," "propertyKey" } ")" dimensionAttributeDetailClause = "dimensionAttributeLocator" GET PROPERTIES "propertyKeyList" levelDetailClause = "levelLocator" ( GET ( PROPERTIES "propertyKeyList" | LEVEL_ATTRIBUTES | IMPLEMENTED_OBJECT ) | "levelAttributeDetailClause" ) hierarchyDetailClause = "hierarchyLocator" GET ( PROPERTIES "propertyKeyList" | ( REF | REFERENCE ) LEVELS ) roleDetailClause = "roleLocator" ( GET ( PROPERTIES "propertyKeyList" ) ) propertyKey = "UNQUOTED_STRING" dimensionAttributeLocator = DIMENSION_ATTRIBUTE "dimensionAttributeName" levelLocator = LEVEL "levelName" levelAttributeDetailClause = "levelAttributeLocator" GET ( PROPERTIES "propertyKeyList" | IMPLEMENTED COLUMN ) hierarchyLocator = HIERARCHY "hierarchyName" roleLocator = ROLE "roleName" dimensionAttributeName = "QUOTED_STRING" levelName = "QUOTED_STRING" levelAttributeLocator = LEVEL_ATTRIBUTE "levelAttributeName" hierarchyName = "QUOTED_STRING" roleName = "QUOTED_STRING" levelAttributeName = "QUOTED_STRING"
This clause retrieves informtion about TIME_DIMENSION, PROPERTIES, FISCAL, DIMENSION_ATTRIBUTES, LEVELS, HIERARCHIES, DIMENSION_ROLES, YEARS, START_YEAR, IMPLEMENTATION_STRATEGY, MAPPING, IMPLEMENTED_OBJECTS.
Basic properties for TIME DIMENSION, TIME DIMENSION MAP, DIMENSION_ATTRIBUTE, LEVEL, LEVEL_ATTRIBUTE and HIERARCHY: Basic properties for TIME DIMENSION : Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the Time Dimension Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the Time Dimension 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 Basic properties for TIME MAP : Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the Time Dimension Map Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the Time Dimension Map 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
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
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_ALL, DEPLOY_DATA_OBJECTS_ONLY, DEPLOY_TO_CATALOG_ONLY |
none |
none |
DEPLOY_DATA_OBJECTS_ONLY |
Warehouse Builder generates a set of scripts for Dimension, they are DDL Scripts for Relational Dimensional or Scripts for ROLAP or or Scripts for AW. |
ENABLE_MV_REFRESH |
BOOLEAN |
true, false |
none |
none |
false |
Enable MV Refresh |
GENERATION_COMMENTS |
STRING |
none |
none |
none |
empty string |
Enter additional comments for the generated code. |
MVCONSTRAINTS |
STRING |
, ENFORCED, TRUSTED |
none |
none |
TRUSTED |
MV Constraints |
NEXTDATE |
STRING |
none |
none |
none |
empty string |
Refresh Next Date |
REFRESH |
STRING |
, COMPLETE, FAST, FORCE |
none |
none |
FORCE |
Refresh Mode |
REFRESH_ON |
STRING |
, DEMAND, ONDATE |
none |
none |
DEMAND |
Refresh On |
STARTWITH |
STRING |
none |
none |
none |
empty string |
Refresh Start Date |
VIEW_NAME |
STRING(30) |
none |
none |
none |
empty string |
Name of the view that is generated to hide the control rows on the dimension implementation table of a star schema. If this field is left blank, the view name will default to '<Name of Dimension>_v' |
VISIBLE |
BOOLEAN |
true, false |
none |
none |
true |
The Dimension is visible to OLAP end user if value is set = true. |