Skip to Content
author's profile photo Former Member
Former Member

BI Package Size

Hello Experts,

I am not an Expert in BI, I only do basic navigation. I know that 50k records is the standard package size for each package in BI. Can the limit be increased to 60k or 70k? I would like to know where in BI it is maintained.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 07:26 AM

    Hi Narayan,

    1) Regarding the DTP settings for Package size ::

    a) For changing all the DTP's package setting ::

    --> T-code SPRO

    --> Drill dowm managent of internal controls

    --> Data Transfer into SAP BW

    --> Maintain control parameters for DTP .

    b) For changing a particular DTP package setting ::

    --> Open a DTP

    --> Goto its EXTRACTION tab.(by default, the setting is for 50,000 records)

    --> Change it no of records you want to process in the DTP run.

    2) Regarding the IP settings for Package size ::

    --> Open your IP.

    --> Goto Schedule Menu

    -->Data transfer for source system

    -->Change the data packet size

    --> Save.

    BR,

    Arpit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 01:16 AM

    Hi Narayan,

    We have two loading objects in SAP BI.

    1) Info Package 2) Data Transfer Process

    When it comes to Info package usually data paket size will be 20000.If it is DTP we will keep 50000.

    If you have simple logic in transformations(say one to one mapping), then you can increase your data packet size.

    If you have complex transformation, then system will take time while updating to target.

    Regards,

    venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 05, 2012 at 04:53 AM

    Hi Narayan,

    If you want to change change the package size on a particular DTP, Right click on the DTP and click on change and in the EXtraction Tab, you will see 50,000 by default. Change it to the number you require and then save and activate the DTP and execute it.

    if you need to change the default setting for all DTP's created so that they maintain a particular package size, please follow these steps

    Go to T-code SPRO - > Drill dowm managent of internal controls - > Data Transfer into SAP BW - > Maintain control parameters for DTP

    and change it here. Hope this helps and I win your points 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 05, 2012 at 07:35 AM

    In R/3 and BW you can change the data package size from the transaction SBIW in the respective system.

    SBIW --> General Settings --> 'Maintain Control Parameters for Data Transfer'.

    This setting in R/3 will change the data packet size for all the data extractions from this source system. This will be required if you want to change the data packet size in the infopackage which are getting data from the R/3 system.

    In order to change the data packet size for the dataloads within BW( data marts etc), you have to change these settings in the BW system.

    you can use Tcode rscustv6 tcode just play around reduce the datapackage

    For DTP in the Extraction tab you can see the Package Size -50000 (by default).

    FYI: set the optimum parameters for data packet size inorder to keep the performance of the system.

    If all the mappings in you system are simple n one to one mapping with no routines used then you can use the data packet size to 50K - 100K.normally we set up IP size to 20K.

    Check below notes :

    Note 409641 - Examples of packet size dependency on ROIDOCPRMS

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.