Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Determine OLAP Cube and Dimension Views (11.1.0)
OLAP Dimension Views
bre on owner on dimension_name
select owner,dimension_name,view_name
from all_cube_dim_views
group by owner,dimension_name,view_name
order by owner,dimension_name,view_name;
OWNER..........................DIMENSION_NAME.................VIEW_NAME
------------------------------ ------------------------------ ------------------------------
DM.............................CHANNEL........................CHANNEL_VIEW
...............................CUSTOMER.......................CUSTOMER_VIEW
...............................PRODUCT........................PRODUCT_VIEW
...............................TIME...........................TIME_VIEW
GLOBAL_BIEE....................CHANNEL........................CHANNEL_VIEW
...............................CUSTOMER.......................CUSTOMER_VIEW
...............................PRODUCT........................PRODUCT_VIEW
...............................TIME...........................TIME_VIEW
OLAP Cube Views
set lines 110 pages 500
bre on owner on cube_name
select owner,cube_name,view_name
from all_cube_views
group by owner,cube_name,view_name
order by owner,cube_name,view_name;
OWNER..........................CUBE_NAME......................VIEW_NAME
------------------------------ ------------------------------ ------------------------------
DM.............................FORECAST.......................FORECAST_VIEW
...............................SALES_CUBE.....................SALES_CUBE_VIEW
Latest page update: made by olapdba
, Feb 13 2008, 11:22 AM EST
(about this update
About This Update
Edited by olapdba
view changes
- complete history)
Edited by olapdba
view changes
- complete history)
Keyword tags:
None
More Info: links to this page
