Thanks for all the support to this series and I look forward to your continued support. If you have some good inputs to be shared with larger group, please share through this series or otherwise.
This one is from a colleague of mine at Wipro (Sunmit – email firstname.lastname@example.org)
Did you use Report SAP_INFOCUBE_DESIGNS? –
Monitor and administer optimized staging of data in the cube.
The size of the dimensions can be monitored in relation to the fact tables by running report SAP_INFOCUBE_DESIGNS. The report reveals the dimensions to fact ratio and is an important tool to guide your decision of restructuring the cube dimensions.
Ideally the dimension tables should be less than 10% of the fact tables.
Needless to say try it on Sandbox, development system before attempting on production environment.
See you next week, Have a great weekend!!!
Disclaimer – Idea is to learn something in couple of seconds without going through lengthy blogs or articles. BW-Tweet hopes to exist with blogs and articles rather than replacing those. Also this is reproduction of concepts and in no way qualify as an original piece of work.