cancel
Showing results for 
Search instead for 
Did you mean: 

ROOSPRMS vs ROIDOCPRMS

Former Member
0 Kudos

Hi,

For a data load from an ODS to Info cube in BW 3.5 systems I want to use more system resources to achieve better performance.

My question is that I can maintain the control parameters either in SBIW/ROIDOCPRMS at a global level or in ROOSPRMS for individual datasources.

Which one will supercede or they are totally different settings altogether??

What other parameter considerations can help?

Please help.

Regards,

Ranjeet

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Size of DataPackages: Influencing Factors

- Specific to application datasource, the contents and structure of records in the extracted datasets.

- Package size: impacts frequency of COMMITs in DB .

- SAP OSS note 417307: Extractor Packet Size Collective Note for SAP Applications

- Consider both the source system and the BW system (RSADMINC).

- Package size specified in table ROIDOCPRMS and/or InfoPackages

Check this documents:

1. [Know-How Network: SAP BW Data Load Performance Analysis and Tuning|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/3a699d90-0201-0010-bc99-d5c0e3a2c87b]

2. [Performance Tuning For SAP BW|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10fb4502-111c-2a10-3080-df0e41d44bb3]

Examples can be found in SAP note 409641 (Examples of packet size

dependency on ROIDOCPRMS).

Additional check this links (regarding ROIDOCPRMS):

Regards

Andreas