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