Redesign Info Cube

[abhishek_shanbhogue2]

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

[RafkeMagic]

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%

[abhishek_shanbhogue2]

Thanks Raf for your response.

There are no line item dimensions in this cube

For the ones which are > 100% has more than one master data IO and the most heavily used IO has more than 300+ attributes which is causing this performance degrade

One of the possible solutions that we are also thinking is to redistribute the IOs among the ones which have ration between 2-60% and make other dimension as line item to include the master data IO which has large number of attributes

We also found Number Range Buffering can be used to possibly reduce the data load inconsistencies and bring down the runtimes

Apart from this are there any other alternatives?

Thanks again

Abhishek Shanbhogue

[former_member183519]

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