How to improve the load performance

[Former Member]

can any body tell me how to improve the load performance

[Former Member · Accepted solution]

Hi Leela,

To Improve the load performance

If Data target is ODS

1. In the ods settings uncheck the check box of available for reporting

2. Uncheck the check the check box of activate ods data automatically.

Once load is complete u can check the first check box and u can do activate data manually or u can main this option in process chain also.

If Data target is INFOCUBE

1.Use the Option in the IP psa and then into data target

2. Delete indexes and create indexes after load.

Hope this will help, if ok assign points.

Regards,

HAIR GUPTA

[Former Member]

Hi,

for all loads: improve your ABAP code in routines.

for master data load:

- load master data attributes before the charateristic itself

- switch number range buffering on for initial loads

for transactional loads:

- load all your master data IObjs prior loading your cube / ODS

- depending on the ratio No.Records loaded / No.Records in Cube F fact table, drop / recreate indexes (if ration is mor than 40/50%

- switch on number range buffering for dimensions with high number of records for initial loads

- switch on number range buffering on master data IObjs which aren't loaded via master data (SIDs always created while transactional loads; eg document, item....)

these recommendations are just some among others like system tuning, DB parameters...

hope this helps...

Olivier.