Question:
Hi all,
I'm using the program SAP_INFOCUBE_DESIGNS to help me tune the performance of infocubes but I noticed that this program does NOT list ALL the infocubes in the system although these infocubes are active and contains data.
After debugging the program, I found that the logic skips certain infocubes when it reads that these cubes have empty fact tables, although in fact, these fact tables do have data.
Anybody knows why? Is it a problem with the program itself?
I'm currently running on SAP BW 3.5.
Thanks.
_________________
I'm loving angels instead
Answer:
Check to see if you have statistics for thos "empty" cubes.
InfoCube_Designs is NOT going out and actually counts records in all the cubes when you run it, it is getting the statistics data, so maybe you need to collect statistics on those cubes - should be a regular event any way.
There is also an RSRV function that gets the row cows as well.
Answer:
Thanks for the reply, Pizzaman.
I've activated the statistics, both in the DB statistics and also BW statistics but the problem remains.
In the end I just use the transaction LISTSCHEMA to list out the tables and manually look at tablecount myself.
Thanks anyway.
_________________
I'm loving angels instead
Answer:
I had a similar issue. When re-loading a cube it wouldn't appear in SAP_INFOCUBE_DESIGNS.
An alternative is the function module RSDU_INFOCUBE_TABLE_SIZES. This'll give you the sizes of your dimension tables but not the size ratio to the fact table.
Hope this helps.
Answer:
Check to make sure you have actually collected DB statistics on the tables after you loaded the cube.
When I run SAP_INFOCUBE_DESIGNS without DB statistics being collected (not sure what you mean by activated), the InfoCube does NOT show up. After I collect statistics, it does.
We're Oracle at BW 3.1 SP21.
Also - you can use RSRV to get the info too AND test to see if you have statistics.
Use RSRV, under Database tests - Database statistics of and Infprovider and its aggregates.
After loading data to the InfoCube but BEFORE tables are analyzed - here's what I get with lots of red lights -
Date/Time/User
14:37:41 o'clock on 06/23/2005: Start test run for user ****
ORACLE: Table /BIC/FZFM_C53 has not yet been analyzed
ORACLE: Table /BIC/EZFM_C53 has not yet been analyzed
ORACLE: Table /BIC/DZFM_C53P has not yet been analyzed
ORACLE: Table /BIC/DZFM_C53T has not yet been analyzed
ORACLE: Table /BIC/DZFM_C53U has not yet been analyzed
ORACLE: Table /BIC/DZFM_C531 has not yet been analyzed
ORACLE: Table /BIC/DZFM_C532 has not yet been analyzed
ORACLE: Table /BIC/DZFM_C533 has not yet been analyzed
ORACLE: Table /BIC/DZFM_C534 has not yet been analyzed
After I collect statistics - from Performance tab, I get green lights with this -
14:50:54 o'clock on 06/23/2005: Start test run for user *****
ORACLE: Table /BIC/FZFM_C53 was analyzed on 23-JUN-05 (inspection sample 010 %)
ORACLE: Table /BIC/EZFM_C53 was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C53P was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C53T was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C53U was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C531 was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C532 was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C533 was analyzed on 23-JUN-05 (inspection sample 100 %)
ORACLE: Table /BIC/DZFM_C534 was analyzed on 23-JUN-05 (inspection sample 100 %)
And a bunch more on the master data tables referenced by the cube, like -
ORACLE: Table /BI0/PFUND was analyzed on 23-JUN-05 (inspection sample 100 %)
Now I run RSRV test - Database statistics of an InfoCube and its aggregates and get -
14:49:18 o'clock on 06/23/2005: Start test run for user *****
Database information about InfoProvider ZFM_C53 tables
ZFM_C53 is a BasisInfoCube
Cube ZFM_C53 has 7 dimensions; 0 dimensions are line item dimensions
Table /BIC/DZFM_C531 has 3937 entries. Size corresponds to 5% of the InfoCube
Table /BIC/DZFM_C532 has 808 entries. Size corresponds to 1% of the InfoCube
Table /BIC/DZFM_C533 has 2250 entries. Size corresponds to 3% of the InfoCube
Table /BIC/DZFM_C534 has 44 entries. Size corresponds to 0% of the InfoCube
Table /BIC/DZFM_C53P has 3 entries. Size corresponds to 0% of the InfoCube
Table /BIC/DZFM_C53T has 9 entries. Size corresponds to 0% of the InfoCube
Table /BIC/DZFM_C53U has 5 entries. Size corresponds to 0% of the InfoCube
Table /BIC/EZFM_C53 has 0 entries. Size corresponds to 0% of the InfoCube
Table /BIC/FZFM_C53 has 78760 entries. Size corresponds to 100% of the InfoCube
And surprise -
When I run SAP_INFOCUBE_DESIGNs the cube now shows up and I get -
ZFM_C53 /BIC/DZFM_C531 rows: 3,937 ratio: 5 %
ZFM_C53 /BIC/DZFM_C532 rows: 808 ratio: 1 %
ZFM_C53 /BIC/DZFM_C533 rows: 2,250 ratio: 3 %
ZFM_C53 /BIC/DZFM_C534 rows: 44 ratio: 0 %
ZFM_C53 /BIC/DZFM_C53P rows: 3 ratio: 0 %
ZFM_C53 /BIC/DZFM_C53T rows: 9 ratio: 0 %
ZFM_C53 /BIC/DZFM_C53U rows: 5 ratio: 0 %
ZFM_C53 /BIC/EZFM_C53 rows: 0 ratio: 0 %
ZFM_C53 /BIC/FZFM_C53 rows: 78,760 ratio: 100 %
Answer:
I might have gotten some of my cut and pastes mixed up -
There are two tests form RSRV you might run:
Database statistics of an Inforprovider and its aggregates
and
Database information about Infoprovider tables
What do you want for nothing....................
Hope this helps
Answer:
Hi! Just wanna check, from the result that you've obtained from RSRV transaction, e.g. "/BIC/DINFOCUBE1 has 19 entries. Size corresponds to 0% of the InfoCube." Does that mean that the 19 entries is the same if I go into SE16 and key in /BIC/DINFOCUBE1 for the number of records?
I keep getting a different amount although I've recollected the statistics for the cube. I've also tried programs SAP_INFOCUBE_DESIGNS, but its still the same.
Thanks in advance