Validating the Accessibility of an OLAP Cube

Cube validation procedures in the CWM2_OLAP_VALIDATE package validate the logical structure of an OLAP cube and check that it is correctly mapped to columns in dimension tables and fact tables. However, a cube may be entirely valid according to this criteria and still be inaccessible to your application.

For this reason, you may need to use the CWM2_OLAP_VERIFY_ACCESS package to check that the following additional criteria have also been met:

The metadata tables used by the OLAP API Metadata Reader must be refreshed with the latest changes in the cube's metadata. If these MRV$ tables have not been updated, you must run the procedures in the CWM2_OLAP_METADATA_REFRESH package to enable access by the OLAP API.
The identity of the application must have access to the source data that underlies the cube. The validation procedures in CWM2_OLAP_VALIDATE run under the SYS identity. These procedures may indicate that the cube is entirely valid, and yet the application may not be able to access it. If this is the case, you must grant the appropriate rights to the calling user.

Summary of CWM2_OLAP_VERIFY_ACCESS Subprograms

Table 23-1 CWM2_OLAP_VERIFY_ACCESS

Subprogram	Description
VERIFY_CUBE_ACCESS Procedure	Validates the cube and verifies its accessibility to an OLAP application.

VERIFY_CUBE_ACCESS Procedure

This procedure first validates a cube by calling the VALIDATE_CUBE procedure in the CWM2_OLAP_VALIDATE package. Additionally it checks that an OLAP API application running under the identity of the calling user has access to the cube.

Cube accessibility requirements are described in "Validating the Accessibility of an OLAP Cube".

Syntax

VERIFY_CUBE_ACCESS (
          cube_owner            IN   VARCHAR2,
          cube_name             IN   VARCHAR2,
          type_of_validation    IN   VARCHAR2 DEFAULT 'DEFAULT',
          verbose_report        IN   VARCHAR2 DEFAULT 'YES');

Parameters

Table 23-2 VERIFY_CUBE_ACCESS Procedure Parameters

Parameter	Description
`cube_owner`	Owner of the cube.
`cube_name`	Name of the cube.
`type_of_validation`	`'DEFAULT'` or `'OLAP API'`. See "Validation Type".
`verbose_report`	`'YES'` or `'NO'`. Whether `to` report all validation checks or only major events and errors. By default, all validation checks are reported.