|Oracle® OLAP Reference
10g Release 1 (10.1)
Part Number B10334-02
This chapter discusses the following topics:
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.
Table 20-1 CWM2_OLAP_VERIFY_ACCESS
||Validates the cube and verifies its accessibility to an OLAP application.|
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".
VERIFY_CUBE_ACCESS ( cube_owner IN VARCHAR2, cube_name IN VARCHAR2, type_of_validation IN VARCHAR2 DEFAULT 'DEFAULT', verbose_report IN VARCHAR2 DEFAULT 'YES');
Table 20-2 VERIFY_CUBE_ACCESS Procedure Parameters
||Owner of the cube.|
||Name of the cube.|