Downsizing a fat ODS to optimaze the processing time!
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, Ive 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