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

Part Number 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
 

OMBALTER OBIEE_BUSINESS_DEFINITION_MODULE

Purpose

Alter an Oracle BI business definition module by renaming it, and/or reset its properties.

Prerequisites

Should be in the context of project.

Syntax

alterOBIEEModuleCommand =  OMBALTER ( OBIEE_BUSINESS_DEFINITION_MODULE 
          "QUOTED_STRING" ( "renameClause" [ 
          "alterPropertiesOrReferenceClauseForDataOnlyModule" ] | 
          "alterPropertiesOrReferenceClauseForDataOnlyModule" | 
          "addOrRemoveOrModifyModuleReferenceLocationClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrReferenceClauseForDataOnlyModule =  ( ( SET ( ( 
          "setPropertiesClause" [ ( SET "setReferenceClauseForDataOnlyModule" [ 
          UNSET "unsetReferenceClauseForDataOnlyModule" ] ) | ( UNSET 
          "unsetReferenceClauseForDataOnlyModule" [ SET 
          "setReferenceClauseForDataOnlyModule" ] ) ] ) | ( 
          "setReferenceClauseForDataOnlyModule" [ UNSET 
          "unsetReferenceClauseForDataOnlyModule" ] ) ) ) | ( UNSET 
          "unsetReferenceClauseForDataOnlyModule" [ SET 
          "setReferenceClauseForDataOnlyModule" ] ) ) [ 
          "addOrRemoveOrModifyModuleReferenceLocationClause" ]
     addOrRemoveOrModifyModuleReferenceLocationClause =  ( 
          "addReferenceLocationClause" | "removeReferenceLocationClause" | 
          "modifyReferenceLocationClause" ) { "addReferenceLocationClause" | 
          "removeReferenceLocationClause" | "modifyReferenceLocationClause" }
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceClauseForDataOnlyModule =  ( "setReferenceLocationClause" [ SET
           "setReferenceIconSetClause" ] | "setReferenceIconSetClause" )
     unsetReferenceClauseForDataOnlyModule =  ( "unsetReferenceLocationClause" [
           UNSET "unsetReferenceIconSetClause" ] | "unsetReferenceIconSetClause"
           )
     addReferenceLocationClause =  ADD ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING" [ SET AS DEFAULT ]
     removeReferenceLocationClause =  REMOVE ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     modifyReferenceLocationClause =  MODIFY ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING" SET AS DEFAULT
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setReferenceLocationClause =  ( REFERENCE | REF ) LOCATION "QUOTED_STRING"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceLocationClause =  ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterOBIEEModuleCommand

This command modifies an existing Oracle BI business definition module.

renameClause

Rename an Oracle BI business definition module.

alterPropertiesOrReferenceClauseForDataOnlyModule

Alter existing business definition module's properties and/or locations and/or icon sets.

addOrRemoveOrModifyModuleReferenceLocationClause

Add/remove/modify data location for the business definition module.

setPropertiesClause

Associate a set of properties with the existing Oracle BI business definition module.

getPropertiesClause

Basic properties for OBIEE_BUSINESS_DEFINITION_MODULE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of a OBIEE business definition module 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of a OBIEE business definition module

setReferenceClauseForDataOnlyModule

Set location and/or icon set for the new Oracle BI business definition module.

unsetReferenceClauseForDataOnlyModule

Unset location and/or icon set for the Oracle BI business definition module.

addReferenceLocationClause

Add a data location to the new Oracle BI business definition module.

removeReferenceLocationClause

Remove a data location from the Oracle BI business definition module.

modifyReferenceLocationClause

Modify a data location of the Oracle BI business definition module.

propertyNameList

Comma-separated list of property names. Property names are not in quotes.

propertyValueList

Comma-separated list of property values.

setReferenceLocationClause

Set a data location for the existing Oracle BI business definition module as the new configuration default.

setReferenceIconSetClause

Set icon set for the new Oracle BI business definition module.

unsetReferenceLocationClause

Unset a data location for the existing Oracle BI business definition module.

unsetReferenceIconSetClause

Unset icon set for the Oracle BI business definition module.

propertyValue

Value for a specified property.

OBIEE_BUSINESS_DEFINITION_MODULE Object

Table 3-58 OBIEE_BUSINESS_DEFINITION_MODULE Object

Property Type Choices Min Max Default Description

DB_LOCATION

STRING

none

none

none

empty string

Location for Business Intelligence Module

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

MLS_DEPLOYMENT_LANGUAGE

STRING

none

none

none

MLS_BASE_LANGUAGE

MLS Language to be used for deployment