Skip to Content
avatar image
Former Member



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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 01, 2009 at 06:47 AM


    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|]

    2. [Performance Tuning For SAP BW|]

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

    dependency on ROIDOCPRMS).

    Additional check this links (regarding ROIDOCPRMS):



    Add comment
    10|10000 characters needed characters exceeded