Solution : https://service.sap.com/sap/support/notes/1461926 (SAP Service marketplace login required)
Summary :
The SAP_INFOCUBE_DESIGNS report is critical for assessing InfoCube designs by showing database table analytics concerning the sizes and ratios of dimension to fact tables within SAP BW systems. It highlights inefficient data distribution with a red mark when dimension table row ratios exceed 10%, indicating the need for design alteration. Users can optimize performance by redistributing or isolating characteristics to new dimensions or line item dimensions. The report, accessible via tcode SE38, also distinguishes between compressed and uncompressed InfoCubes based on data location (E-fact or F-fact tables), aiding in appropriate maintenance and adjustments. Technical checks on the data’s accuracy are recommended using DBA_TABLES entries.
Key words :
technical information ======report sap_infocube_designs reads, zsdtest /bic/dzstest1 rows, zsdtest /bic/fzstest rows, 0qm_c10 /bi0/e0qm_c10 rows, 100 % <-0qm_c10 /bi0/f0qm_c10 rows, 0crm_c04 /bi0/e0crm_c04 rows, 0 %0crm_c04 /bi0/f0crm_c04 rows, 0tct_c01 /bi0/d0tct_c013 rows, 0 %0tct_c01 /bi0/d0tct_c018 rows, 0 %0tct_c01 /bi0/d0tct_c019 rows
Related Notes :
| 1096207 | Overflow dump in report SAP_INFOCUBE_DESIGNS |
| 591294 | Deleting obsolete entries in fact table |
| 590370 | Too many uncompressed request (f table partitions) |
| 407260 | FAQs: Compression of InfoCubes |