OMBCREATE CATALOG_FOLDER

Purpose

Creates a catalog folder to group business related items.

Prerequisites

Should be in the context of an OBIEE Business Definition Module.

Syntax

createCatalogFolderCommand =  ( OMBCREATE CATALOG_FOLDER "QUOTED_STRING" [ 
          SET "setPropertiesClause" ] [ SET "setReferenceIconSetClause" ] { SET 
          ( REF | REFERENCE ) LOGICAL_TABLES "(" "setLogicalTableNameList" ")" |
           SET ( REF | REFERENCE ) DRILL_PATHS "(" "setDrillPathNameList" ")" } 
          )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     setLogicalTableNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     setDrillPathNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createCatalogFolderCommand

This command creates a catalog folder.

QUOTED_STRING

Specify the name of the catalog folder to be created.

setPropertiesClause

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

getPropertiesClause

Basic properties for CATALOG_FOLDER: 

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

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

setReferenceIconSetClause

Set specified Icon Set.

setLogicalTableNameList

Used to set logical table references for this catalog folder.

setDrillPathNameList

Used to set logical table references for this catalog folder.

propertyNameList

This is the list of property names.

propertyValueList

This is the list of property values.

propertyValue

This is a property value.

CATALOG_FOLDER Object

Table 6-6 CATALOG_FOLDER 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