Version User Scope of changes
Feb 13 2008, 11:22 AM EST (current) olapdba
Jan 15 2008, 11:53 AM EST olapdba 100 words added

Changes

Key:  Additions   Deletions

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