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

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
Mobi · ePub

OMBALTER DRILL_PATH

Purpose

Alters a drill path.

Prerequisites

Should be in the context of a business definition module or use the full path.

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.

DRILL_PATH Object

Table 2-8 DRILL_PATH Object

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 objects marked as Deployable = true