Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Downsizing a fat ODS to optimaze the processing time!

Hello all,

Working with SAP NetWeaver BI 7.0, a customizing FI_CO OPC ODS with 300.000.000 records extracted from Sap R/3, was enhanced with 2 new fields and since then it has generated big processing time – about 20 hrs and same times basis team needs to kill it! This ODS has been loading a Cube and the new enhanced fields will be loaded to another Cube.

As a newbie and Sap BI also newbie at this project, I’ve been requested to analyze the model and give a better option to optimize the loading process, options such as should this ODS be deleted and data be extracted straight to the Cubes, or downsizing this ODS by removing the olds records of it and saving it in other new ODS?

Anyone could come up with a bright idea?

Thanks in advanced

Not what you were looking for? View more on this topic or Ask a question