OMBCREATE DRILL_TO_DETAIL

Purpose

Creates a Drill to detail to allow drilling between items.

Prerequisites

Should be in the context of a Business Definition Module.

Syntax

createDrillToDetailCommand =  OMBCREATE DRILL_TO_DETAIL "QUOTED_STRING" [ 
          SET "setPropertiesClause" ] [ SET "setReferenceIconSetClause" ] { 
          "addDrillToDetailReferenceClause" }
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addDrillToDetailReferenceClause =  SET ( REF | REFERENCE ) ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createDrillToDetailCommand

This command creates a drill to detail.

QUOTED_STRING

Specify the name of the drill to detail to be created.

setPropertiesClause

Used to set properties (core, logical, physical, user-defined) for a drill to detail. Valid properties are shown below:

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.

addDrillToDetailReferenceClause

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

propertyNameList

This is the list of property names.

propertyValueList

This is the list of property values.

propertyValue

This is a property value.

DRILL_TO_DETAIL Object

Table 7-5 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