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

OMBDERIVE

Purpose

Derives business definition objects from OWB design objects.

Prerequisites

Should be in an appropriate context for the design object or use the full path for the design object.

The Business Definition Module named in the TO clause should already exist within the current project.

Any Business Areas named should already exist within the Business Definition Module.

Syntax

parseDeriveCommand =  OMBDERIVE ( ORACLE_MODULE | GATEWAY_MODULE | 
          DIMENSION | CUBE | TABLE | VIEW | MATERIALIZED_VIEW | EXTERNAL_TABLE |
           FUNCTION | "UNQUOTED_STRING" | COLLECTION ) "QUOTED_STRING" TO ( ( 
          BUSINESS_DEFINITION_MODULE "QUOTED_STRING" [ BUSINESS_AREAS "(" 
          "BANameList" ")" ] ) | ( OBIEE_BUSINESS_DEFINITION_MODULE 
          "QUOTED_STRING" [ CATALOG_FOLDERS "(" "BANameList" ")" ] ) ) [ 
          "parseDeriveCommandParams" ]
     BANameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     parseDeriveCommandParams =  "parseRuleParameters" { "parseRuleParameters" }
     parseRuleParameters =  SET [ ( ORACLE_MODULE | GATEWAY_MODULE | DIMENSION |
           CUBE | TABLE | MATERIALIZED_VIEW | VIEW | EXTERNAL_TABLE | FUNCTION |
           "UNQUOTED_STRING" | COLLECTION ) ] "(" "parameterNameList" ")" VALUES
           "(" "parameterValueList" ")"
     parameterNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     parameterValueList =  "parameterValue" { "," "parameterValue" }
     parameterValue =  ( "QUOTED_STRING" )

Parameters

parseDeriveCommand

Derives business definition objects from OWB design objects.

The quoted string following TO should be the name of a Business Definition Module in the current project, into which the business definition objects are derived.

BANameList

List of the target business areas.

parseDeriveCommandParams

The global derivation parameters.

parseRuleParameters

The rule derivation parameters.

parameterNameList

List of the parameters.

parameterValueList

List of the parameter values.

parameterValue

The parameter value.