Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

ADD_CATALOG_ENTITY Procedure

This procedure adds a measure or a cube to a measure folder.

Syntax

ADD_CATALOG_ENTITY (
   catalog_id           IN   NUMBER,
   entity_owner         IN   VARCHAR2,
   entity_name          IN   VARCHAR2,
   child_entity_name    IN   VARCHAR2);

Parameters

Table 28-2  ADD_CATALOG_ENTITY Procedure Parameters
Parameter Description

catalog_id

Name of the measure folder.

entity_owner

Owner of the cube to be added to the measure folder.

entity_name

Name of the cube to be added to the measure folder.

child_entity_name

Name of a measure. If this parameter is specified, the procedure adds this individual measure to the measure folder, instead of adding all of the cube's measures. If this parameter is NULL, the procedure adds all of the cube's measures. The default is NULL.

Exceptions

Table 28-3  ADD_CATALOG_ENTITY Procedure Exceptions
Exception Description

element_already_exists

This cube is already added to this measure folder.

element_not_found

Cube or measure not found.

catalog_not_found

Measure folder not found.