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.