Sign in or 
| Version | User | Scope of changes |
|---|---|---|
| Oct 26 2009, 10:55 AM EDT (current) | olapdba | 9 words added, 18 words deleted |
| Feb 13 2008, 11:19 AM EST | olapdba | 4 words added, 2 words deleted |
Changes
Key: Additions Deletions
To determine Cube and AW information in Oracle Database 11g consider using this script.
set lines 110 pages 1000
col owner for a15colaw_nm 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,owner||'.'||aw_name 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;
OWNER ......... AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME
--------------- ------------ ------------ ------ ---------------------------------------------------------
DM ............DM.SALES SALES ......... CHANNEL .... STD .. SALES_CHANNEL
........................................ CUSTOMER ... STD .. REGIONAL
........................................ PRODUCT .... STD .. STANDARD
........................................ TIME ....... TIME . CALENDAR
set lines 110 pages 1000
col owner for a15colaw_nm 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,owner||'.'||aw_name 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;
OWNER ......... AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME
--------------- ------------ ------------ ------ ---------------------------------------------------------
DM ............DM.SALES SALES ......... CHANNEL .... STD .. SALES_CHANNEL
........................................ CUSTOMER ... STD .. REGIONAL
........................................ PRODUCT .... STD .. STANDARD
........................................ TIME ....... TIME . CALENDAR
