Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
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 owner for a15
col aw_name 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, dimension_name
, decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type
, default_hierarchy_name
from all_cube_dimensions
order by 1,2,3;
OWNER ......... 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 owner for a15
col aw_name 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, dimension_name
, decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type
, default_hierarchy_name
from all_cube_dimensions
order by 1,2,3;
OWNER ......... AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME
--------------- ------------ ------------ ------ ------------------------------
DM ............ SALES ...... CHANNEL .... STD .. SALES_CHANNEL
............................ CUSTOMER ... STD .. REGIONAL
............................ PRODUCT .... STD .. STANDARD
............................ TIME ....... TIME . CALENDAR
Latest page update: made by olapdba
, Feb 13 2008, 11:19 AM EST
(about this update
About This Update
Edited by olapdba
4 words added
2 words deleted
view changes
- complete history)
Edited by olapdba
4 words added
2 words deleted
view changes
- complete history)
Keyword tags:
None
More Info: links to this page
