Skip to Content
avatar image
Former Member

Redesign Info Cube

Hello All - Need your expert advise on below issue

Problem Statement: In BW one the Infocube is observed to have drastic increase in load time and intermittent performance issues for data loading from DSO to Info cube. This is also having cascading impact on the daily BW nightly batch jobs.

The ratio of memory occupied by dimensions VS Fact Table should be less than 10-20% as per SAP recommendation. But we see this ratio to be more than 100% in some of the dimensions (refer below snapshot).  In future we expect this ratio might increase considering the amount of data that is getting added and enhancements on this Info cube.


We are looking if anyone has faced similar issues and what was done to redesign the Cube to reduce runtime. If there are any other ideas to help improve performance are also welcome.

Thanks in advance for your help in this matter

Abhishek Shanbhogue

Untitled.jpg (46.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 02:17 PM

    for the ones > 100% verify whether they are line item dimensions (if so, that's plausible)

    for the ones between 21 - 63% I would investigate (via transaction LISTSCHEMA for example) why they are so big and possibly move some fields to the dimensions where you have 0 - 2%

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Abhishek,

      In addition to above discussion, after making changes to cube & in future there should not be any issues do sufficient testing in DEV and QUA (t. code RSRV)

      refer link:

      while redesigning , make dimensions as line item which are rapidly growing.

      Regards,

      Hitesh