Determine OLAP Cube and Dimension Views (11.1.0)This is a featured page

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


olapdba
olapdba 		Latest page update: made by olapdba , Feb 13 2008, 11:22 AM EST (about this update About This Update olapdba Edited by olapdba


view changes
- complete history)
Keyword tags: None
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.