BI Package Size

[Former Member]

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.

[former_member182516]

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

[Former Member]

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

[sundeep_chalasani]

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

[Former Member]

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