This is a script you can run as your user (i.e., SCOTT) to see what OLAP Catalogue Metadata you have access to. This example assumes Scott has read access to SH's specific schema objects.

CWM1 = First Generation OLAP Relational Common Warehouse Metadata (OEM)
CWM2 = Second Generation OLAP Relational or Multidimensional Common Warehouse Metadata
AWMD = Active OLAP Catalogue Metadata for Analytic Workspaces

Measure Folder or Catalogue

set lines 110 pages500 echo off

col aw format a60 heading "AWs"
col catalog format a60 heading "Catalog"
col cube format a60 heading "Cubes"
col dimension format a60 heading "Dimensions"
col measure format a60 heading "Measures"
col cat format a7 heading "Catalog"
col valid format a6 heading "Valid"

select b.entity_owner||'.'||a.catalog_name catalog, 'CWM1' cat
from olapsys.all$olap_catalogs a, olapsys.all$olap_catalog_entity_uses b
where a.catalog_id=b.catalog_id group by b.catalog_id, b.entity_owner, a.catalog_name union all
select aw_owner||'.'||aw_name||'!'||catalog_name catalog, 'AWMD' cat
from olapsys.all$olap2_aw_catalogs group by aw_owner, aw_name, catalog_name union all
select b.entity_owner||'.'||a.catalog_name catalog, 'CWM2' cat
from olapsys.all$olap2_catalogs a, olapsys.all$olap2_catalog_entity_uses b
where a.catalog_id=b.catalog_id group by b.catalog_id, b.entity_owner, a.catalog_name;

Catalog......................................................Catalog
------------------------------------------------------------ -------
SH.SH_CAT....................................................CWM1

Cubes

select owner||'.'||cube_name cube, 'CWM1' cat,
decode(invalid,'O','YES','1','NO','Y','NO','N','YES', invalid) valid
from olapsys.ALL$OLAP2_CUBES union all
select owner||'.'||cube_name cube, 'CWM2' cat,
decode(invalid,'O','YES','1','NO','Y','NO','N','YES', invalid) valid
from olapsys.ALL$OLAP_CUBES union all
select aw_owner||'.'||aw_name||'!'||aw_logical_name cube, 'AWMD' cat,'YES' valid
from olapsys.ALL$OLAP2_AW_CUBES order by cube;

Cubes......................................,,,,,,,,,,,,,,,,,,Catalog Valid
------------------------------------------------------------ ------- -----
SH.COST_CUBE.................................................CWM2....YES
SH.SALES_CUBE................................................CWM2....YES
SCOTT.STORE!SALES............................................AWMD....YES

Dimensions

select owner||'.'||dimension_name dimension, 'CWM1' cat,
decode(invalid,'O','YES','1','NO','Y','NO','N','YES', invalid) valid
from olapsys.ALL$OLAP_DIMENSIONS union all
select owner||'.'||dimension_name dimension, 'CWM2' cat,
decode(invalid,'O','YES','1','NO','Y','NO','N','YES', invalid) valid
from olapsys.ALL$OLAP2_DIMENSIONS union all
select aw_owner||'.'||aw_name||'!'||aw_logical_name dimension, 'AWMD' cat, 'YES' valid
from olapsys.ALL$OLAP2_AW_DIMENSIONS order by dimension;

Dimensions...................................................Catalog.Valid
------------------------------------------------------------ ------- -----
SH.CHANNELS_DIM..............................................CWM1....YES
SH.CUSTOMERS_DIM.............................................CWM1....YES
SH.PRODUCTS_DIM..............................................CWM1....YES
SH.PROMOTIONS_DIM............................................CWM1....YES
SH.TIMES_DIM.................................................CWM1....YES
SCOTT.STORE!BRAND............................................AWMD....YES
SCOTT.STORE!GEOGRAPHY........................................AWMD....YES
SCOTT.STORE!PRODUCT..........................................AWMD....YES
SCOTT.STORE!TIME.............................................AWMD....YES

select owner||'.'||cube_name||'.'||measure_name measure, 'CWM1' cat
from olapsys.ALL$OLAP_CUBE_MEASURES union all
select owner||'.'||cube_name||'.'||measure_name measure, 'CWM2' cat
from olapsys.ALL$OLAP2_CUBE_MEASURES union all
select aw_owner||'.'||aw_name||'!'||aw_cube_name||'!'||aw_measure_name measure,'AWMD' cat
from olapsys.ALL$OLAP2_AW_CUBE_MEASURES order by measure;

Measures

Measures.....................................................Catalog
------------------------------------------------------------ -------
SH.COST_CUBE.UNIT_COST.......................................CWM1
SH.COST_CUBE.UNIT_PRICE......................................CWM1
SH.SALES_CUBE.SALES_AMOUNT...................................CWM1
SH.SALES_CUBE.SALES_QUANTITY.................................CWM1
SCOTT.STORE!SALES!INVENTORY..................................AWMD
SCOTT.STORE!SALES!NUM_ITEMS..................................AWMD
SCOTT.STORE!SALES!TOTAL_DOLLARS..............................AWMD
SCOTT.STORE!SALES!UNITS......................................AWMD

Analytic Workspaces/Multidimensional Dataypes

select aw_owner||'.AW$'||aw_name AW from ALL$OLAP2_AW_CUBES group by aw_owner,aw_name;

AWs
------------------------------------------------------------
SCOTT.AW$STORE