CREATE_CATALOG Function

This function creates a measure folder and returns a unique identifier (NUMBER) for the measure folder.

This identifier may be used to create subfolders of this measure folder.

Syntax

CREATE_CATALOG (
   catalog_name            IN   VARCHAR2,
   catalog_description     IN   NUMBER,
   parent_catalog_id       IN   NUMBER);

Parameters

Table 28-7  CREATE_CATALOG Function Parameters

Parameter	Description
catalog_name	Name of the measure folder.
catalog_description	Description of the measure folder.
parent_catalog_id	Identifier of the parent measure folder. By default, this parameter is NULL, meaning that the new measure folder is at the root level in the hierarchy.

Exceptions

Table 28-8  CREATE_CATALOG Function Exceptions

Exception	Description
parent_catalog_not_found	Parent measure folder not found.
catalog_already_exists	A measure folder with this name already exists.
invalid_name	Measure folder name may not be empty or null.