Access to OLAP Catalog (CWM2) Views

The OLAP Catalog read API consists of two sets of corresponding views:

• ALL_ views displaying all valid OLAP metadata accessible to the current user.
• DBA_ views displaying all OLAP metadata (both valid and invalid) in the entire database. DBA_ views are intended only for administrators.

  Note: The OLAP Catalog tables are owned by OLAPSYS. To create OLAP metadata stored in these tables, the user must have the OLAP_DBA role.

The columns of the ALL_ and DBA_ views are identical. Only the ALL_ views are listed in this chapter.