Common Logic in CWM2_OLAP_LEVEL Subprograms

Each procedure first checks the calling user's security privileges. The calling user must be the dimension owner and must have the OLAP_DBA role. 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 parent dimension within the OLAP 2 Catalog. If the dimension does not exist, the procedure fails with an exception.

Each procedure then checks for the existence of the level. All procedures, except CREATE_LEVEL, return an error if the level does not already exist.

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, level_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.