OMBALTER DRILL_TO_DETAIL

Purpose

Alters a drill to detail.

Prerequisites

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

Syntax

alterDrillToDetailCommand =  ( OMBALTER DRILL_TO_DETAIL "QUOTED_STRING" ( (
           "renameClause" [ SET "setPropertiesClause" ] [ SET 
          "setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ] 
          { "alterDrillToDetailClauses" } ) | ( SET "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ] 
          { "alterDrillToDetailClauses" } ) | ( SET "setReferenceIconSetClause" 
          [ UNSET "unsetReferenceIconSetClause" ] { "alterDrillToDetailClauses" 
          } ) | ( UNSET "unsetReferenceIconSetClause" { 
          "alterDrillToDetailClauses" } ) | ( "alterDrillToDetailClauses" { 
          "alterDrillToDetailClauses" } ) ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     alterDrillToDetailClauses =  "addDrillToDetailReferenceClause" | UNSET ( 
          REF | REFERENCE ) "deleteDrillToDetailClauses"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     addDrillToDetailReferenceClause =  SET ( REF | REFERENCE ) ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     deleteDrillToDetailClauses =  ( ITEM "QUOTED_STRING" OF ITEM_FOLDER 
          "QUOTED_STRING" )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterDrillToDetailCommand

This clause alters a drill to detail.

QUOTED_STRING

name of the drill to detail.

renameClause

Renames a drill to detail with a different name.

setPropertiesClause

This clause sets the properties of the object.

getPropertiesClause

Basic properties for DRILL_TO_DETAIL: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the drill to detail 

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

setReferenceIconSetClause

Set specified Icon Set.

unsetReferenceIconSetClause

Unset specified Icon Set.

alterDrillToDetailClauses

This clause modifies a drill to detail.

propertyNameList

This is the list of property names.

propertyValueList

This is the list of property values.

addDrillToDetailReferenceClause

This adds a reference to an item to a drill to detail.

deleteDrillToDetailClauses

This deletes a reference to an item from a drill to detail.

propertyValue

This is a property value.

DRILL_TO_DETAIL Object

Table 2-9 DRILL_TO_DETAIL 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