Sign in or 
| Version | User | Scope of changes |
|---|---|---|
| Feb 13 2008, 11:20 AM EST (current) | olapdba | 8 words added, 4 words deleted |
| Jan 9 2008, 1:13 PM EST | olapdba |
Changes
Key: Additions Deletions
To determine Cube information in Oracle Database 11g consider using this script.
set lines 110 pages 1000
col owner for a5
col cube_name for a10
col aw_name for a12 hea AW
col sparse_type for a6 hea TYPE
col precompute_condition for a54 wrap
col precompute_percent for 99 hea PCT
col precompute_percent_top for 99 hea TOP
select owner, aw_name, cube_name,cube_name
, decode(sparse_type,'COMPRESSED','COMPR',sparse_type) sparse_type, sparse_type
, to_char(precompute_condition) precompute_condition,precompute_condition
, nvl(precompute_percent,0) precompute_percent, precompute_percent
, nvl(precompute_percent_top,0) precompute_percent_top
from all_cubes
order by 1,2,3;
OWNER AW ......... CUBE_NAME. TYPE . PRECOMPUTE_CONDITION ..................................... PCT TOP
----- ------------ ---------- ------ ---------------------------------------------------------- --- ---
DM .. SALES ...... FORECAST . DENSE. DM.TIME WHERE DM.TIME.LEVEL_NAME='YEAR', ................. 0 . 0
.................................... DM.TIME WHERE DM.TIME.LEVEL_NAME='QUARTER',
.....................................DM.TIME WHERE DM.TIME.LEVEL_NAME='MONTH',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='CITY',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='CONTINENT',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='COUNTRY',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='STATE_PROVINCE',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='TOTAL_CUSTOMER',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME='DEPARTMENT',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME='GROUPS',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME='TOTAL_PRODUCT',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME = 'TYPE'
DM .. SALES ...... SALES_CUBE COMPR ............................................................40. 0
set lines 110 pages 1000
col owner for a5
col cube_name for a10
col aw_name for a12 hea AW
col sparse_type for a6 hea TYPE
col precompute_condition for a54 wrap
col precompute_percent for 99 hea PCT
col precompute_percent_top for 99 hea TOP
select owner, aw_name, cube_name,cube_name
, decode(sparse_type,'COMPRESSED','COMPR',sparse_type) sparse_type, sparse_type
, to_char(precompute_condition) precompute_condition,precompute_condition
, nvl(precompute_percent,0) precompute_percent, precompute_percent
, nvl(precompute_percent_top,0) precompute_percent_top
from all_cubes
order by 1,2,3;
OWNER AW ......... CUBE_NAME. TYPE . PRECOMPUTE_CONDITION ..................................... PCT TOP
----- ------------ ---------- ------ ---------------------------------------------------------- --- ---
DM .. SALES ...... FORECAST . DENSE. DM.TIME WHERE DM.TIME.LEVEL_NAME='YEAR', ................. 0 . 0
.................................... DM.TIME WHERE DM.TIME.LEVEL_NAME='QUARTER',
.....................................DM.TIME WHERE DM.TIME.LEVEL_NAME='MONTH',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='CITY',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='CONTINENT',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='COUNTRY',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='STATE_PROVINCE',
.....................................DM.CUSTOMER WHERE DM.CUSTOMER.LEVEL_NAME='TOTAL_CUSTOMER',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME='DEPARTMENT',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME='GROUPS',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME='TOTAL_PRODUCT',
.....................................DM.PRODUCT WHERE DM.PRODUCT.LEVEL_NAME = 'TYPE'
DM .. SALES ...... SALES_CUBE COMPR ............................................................40. 0
