Sign in or 
Share this
Determine OLAP Cube Dimensions Information (11.1.0)
To determine Cube and AW information in Oracle Database 11g consider using this script.
set lines 110 pages 1000
col aw_nm for a12 hea AW
col dimension_name for a12 hea DIMENSION
col dimensions_type for a6 hea TYPE
bre on owner on aw_name skip 1
select owner||'.'||aw_name aw_nm, dimension_name
, decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type
, default_hierarchy_name
from all_cube_dimensions
order by 1,2,3;
AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME
------------ ------------ ------ ---------------------------
DM.SALES ... CHANNEL .... STD .. SALES_CHANNEL
............ CUSTOMER ... STD .. REGIONAL
............ PRODUCT .... STD .. STANDARD
............ TIME ....... TIME . CALENDAR
set lines 110 pages 1000
col aw_nm for a12 hea AW
col dimension_name for a12 hea DIMENSION
col dimensions_type for a6 hea TYPE
bre on owner on aw_name skip 1
select owner||'.'||aw_name aw_nm, dimension_name
, decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type
, default_hierarchy_name
from all_cube_dimensions
order by 1,2,3;
AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME
------------ ------------ ------ ---------------------------
DM.SALES ... CHANNEL .... STD .. SALES_CHANNEL
............ CUSTOMER ... STD .. REGIONAL
............ PRODUCT .... STD .. STANDARD
............ TIME ....... TIME . CALENDAR
olapdba |
Latest page update: made by olapdba
, Oct 26 2009, 10:55 AM EDT
(about this update
About This Update
Edited by olapdba
9 words added 18 words deleted view changes - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
