Syntax
alterDrillPathCommand = ( OMBALTER DRILL_PATH "QUOTED_STRING" ( (
"renameClause" [ SET "setPropertiesClause" ] [ SET
"setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ]
{ "alterDrillPathLevelClauses" } ) | ( SET "setPropertiesClause" [ SET
"setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ]
{ "alterDrillPathLevelClauses" } ) | ( SET
"setReferenceIconSetClause" [ UNSET "unsetReferenceIconSetClause" ] {
"alterDrillPathLevelClauses" } ) | ( UNSET
"unsetReferenceIconSetClause" { "alterDrillPathLevelClauses" } ) | (
"alterDrillPathLevelClauses" { "alterDrillPathLevelClauses" } ) ) )
renameClause = RENAME TO "QUOTED_STRING"
setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "("
"propertyValueList" ")"
setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
unsetReferenceIconSetClause = ( REFERENCE | REF ) ICONSET
alterDrillPathLevelClauses = ADD ( "addDrillPathLevelClauseForAlter" |
"addDrillLevelLinkClauseForAlter" ) | MODIFY
"modifyDrillPathLevelClause" | DELETE ( "deleteDrillPathLevelClause" |
"deleteDrillLevelLinkClause" )
propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
propertyValueList = "propertyValue" { "," "propertyValue" }
addDrillPathLevelClauseForAlter = [ ROOT ] DRILL_LEVEL "QUOTED_STRING" [
DEFAULT_ROOT ] [ SET "setPropertiesClause" ] { "setDrillItemClause" }
{ "addDrillLevelKey" }
addDrillLevelLinkClauseForAlter = DRILL_LEVEL_LINK PARENT DRILL_LEVEL
"QUOTED_STRING" CHILD DRILL_LEVEL "QUOTED_STRING"
modifyDrillPathLevelClause = DRILL_LEVEL "QUOTED_STRING" [ PARENT
DRILL_LEVEL "QUOTED_STRING" ] [ "renameClause" ] [ "moveDrillLevel" ]
[ SET "setPropertiesClause" ] { "setDrillItemClause" |
"unsetDrillItemClause" | "unsetJoinUsage" } {
"alterDrillLevelKeyClauses" }
deleteDrillPathLevelClause = DRILL_LEVEL "QUOTED_STRING" [ CASCADE ]
deleteDrillLevelLinkClause = DRILL_LEVEL_LINK PARENT DRILL_LEVEL
"QUOTED_STRING" CHILD DRILL_LEVEL "QUOTED_STRING"
propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" |
"FLOATING_POINT_LITERAL" )
setDrillItemClause = SET ( REF | REFERENCE ) ITEM "QUOTED_STRING" OF ( (
ITEM_FOLDER "QUOTED_STRING" "itemJoinUsages" ) | ( LOGICAL_TABLE
"QUOTED_STRING" ) )
addDrillLevelKey = ADD DRILL_LEVEL_KEY "QUOTED_STRING" [ SET
"setPropertiesClause" ] { "setDrillItemKeyClause" }
moveDrillLevel = MOVE BELOW DRILL_LEVEL "QUOTED_STRING"
unsetDrillItemClause = UNSET ( REF | REFERENCE ) ITEM "QUOTED_STRING" OF (
( ITEM_FOLDER "QUOTED_STRING" ) | ( LOGICAL_TABLE "QUOTED_STRING" ) )
unsetJoinUsage = UNSET USING JOIN "QUOTED_STRING" OF ITEM_FOLDER
"QUOTED_STRING"
alterDrillLevelKeyClauses = ADD "addDrillLevelKeyforAlter" | MODIFY
"modifyDrillLevelKeyClause" | DELETE "deleteDrillLevelKeyClause"
itemJoinUsages = { USING JOIN "QUOTED_STRING" OF ITEM_FOLDER
"QUOTED_STRING" }
setDrillItemKeyClause = SET ( REF | REFERENCE ) ITEM "QUOTED_STRING" OF
LOGICAL_TABLE "QUOTED_STRING"
addDrillLevelKeyforAlter = DRILL_LEVEL_KEY "QUOTED_STRING" [ SET
"setPropertiesClause" ] { "setDrillItemKeyClause" }
modifyDrillLevelKeyClause = DRILL_LEVEL_KEY "QUOTED_STRING" [
"renameClause" ] [ SET "setPropertiesClause" ] {
"setDrillItemKeyClause" | "unsetDrillItemKeyClause" }
deleteDrillLevelKeyClause = DRILL_LEVEL_KEY "QUOTED_STRING"
unsetDrillItemKeyClause = UNSET ( REF | REFERENCE ) ITEM "QUOTED_STRING"
OF LOGICAL_TABLE "QUOTED_STRING"
Parameters
alterDrillPathCommand
This clause alters a drill path.
QUOTED_STRING
name of the drill path.
renameClause
Renames a drill path with a different name.
setPropertiesClause
This clause sets the properties of the object.
getPropertiesClause
Basic properties for DRILL_PATH:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the drill path
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the drill path
Name: TIMEDIMENSION
Type: BOOLEAN
Valid Values: Y,N
Default: 'N'
Whether the drill path represents a time dimension. Oracle Business Intelligence Modules (OBIEE) only
Basic properties for DRILL_LEVEL:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the drill level
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the drill level
Name: DEFAULT_ROOT_LEVEL
Type: BOOLEAN
Valid Values: Y,N
Default: 'N'
Whether the level is a default root. Oracle Business Intelligence Modules (OBIEE) only
Name: GRAND_TOTAL_LEVEL
Type: BOOLEAN
Valid Values: Y,N
Default: 'N'
Whether the level is a grand total level. Oracle Business Intelligence Modules (OBIEE) only
Name: SUPPORTS_ROLLUP
Type: BOOLEAN
Valid Values: Y,N
Default: 'Y'
Whether the level supports rollup to a higher level of aggregation. Oracle Business Intelligence Modules (OBIEE) only
Basic properties for DRILL_LEVEL_KEY (Oracle Business Intelligence (OBIEE):
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the drill level key
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the drill level key
Name: PRIMARYKEY
Type: BOOLEAN
Valid Values: Y,N
Default: 'N'
Whether the level key is the primary key for the drill level. Oracle Business Intelligence Modules (OBIEE) only
Name: CHRONOLOGICALKEY
Type: BOOLEAN
Valid Values: Y,N
Default: 'N'
Whether the level key is the chronological key for a time dimension. Oracle Business Intelligence Modules (OBIEE) only
Name: USE_FOR_DRILLDOWN
Type: BOOLEAN
Valid Values: Y,N
Default: 'Y'
Whether the level key is used for drill down. Oracle Business Intelligence Modules (OBIEE) only
setReferenceIconSetClause
Set specified Icon Set.
unsetReferenceIconSetClause
Unset specified Icon Set.
alterDrillPathLevelClauses
This clause modifies a drill path.
propertyNameList
This is the list of property names.
propertyValueList
This is the list of property values.
addDrillPathLevelClauseForAlter
This adds a drill level to a drill path.
QUOTED_STRING
name of the drill level.
addDrillLevelLinkClauseForAlter
This adds a drill level link from a parent to child level.
modifyDrillPathLevelClause
This modifies a drill level in a drill path.
QUOTED_STRING
name of the drill level.
deleteDrillPathLevelClause
This deletes a drill level from a drill path.
QUOTED_STRING
name of the drill level.
deleteDrillLevelLinkClause
This deletes a drill level link between parent and child levels.
propertyValue
This is a property value.
setDrillItemClause
This clause adds a reference to an item for the level.
addDrillLevelKey
This clause adds a level key to the level.
moveDrillLevel
Moves a drill level below another drill level.
unsetDrillItemClause
This clause removes a reference to an item for the level.
unsetJoinUsage
removes a join usage.
alterDrillLevelKeyClauses
Alters the drill level key.
itemJoinUsages
The specific joins to be used.
setDrillItemKeyClause
Associates an item with a drill level key.
addDrillLevelKeyforAlter
Adds a drill level key.
modifyDrillLevelKeyClause
Modifies a drill level key.
deleteDrillLevelKeyClause
Deletes a drill level key.
unsetDrillItemKeyClause
Removes the associaton to an item for a drill level key.
