Common Logic in CWM2_OLAP_TABLE_MAP Subprograms

Each procedure first checks the calling user's security privileges. The calling user must have the OLAP_DBA role and must be the owner of the entity that will be mapped. If the calling user does not meet the security requirements, the procedure fails with an exception.

Each procedure then checks for the existence of the metadata entity within the OLAP 2 Catalog. All procedures return an error if the entity does not already exist.

Each procedure then checks for the existence of tables and columns. If these do not exist in the data dictionary, an error is generated.

Case Requirements for Subprogram Parameters

You can specify arguments in lower case, upper case, or mixed case.

If the argument is a metadata entity name (for example, cube_name or dimension_name) or a value that will be used in further processing by other procedures, the procedure converts the argument to upper case. For all other arguments, the case that you specify is retained.