Sign in or 
Share this
Determine OLAP Cube Information (11.1.0)
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
, decode(sparse_type,'COMPRESSED','COMPR',sparse_type) sparse_type
, to_char(precompute_condition) precompute_condition
, nvl(precompute_percent,0) 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
, decode(sparse_type,'COMPRESSED','COMPR',sparse_type) sparse_type
, to_char(precompute_condition) precompute_condition
, nvl(precompute_percent,0) 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
olapdba |
Latest page update: made by olapdba
, Feb 13 2008, 11:20 AM EST
(about this update
About This Update
Edited by olapdba
8 words added 4 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.
