DATA packet size

[Former Member]

hi

when i take load from r/3 the size of data packet is 6000 i increase the size in info package that i set to 20000 kb and also do the setiing in sbiw in r/3

still its remain same.

please help us data loading is very very slow.

regars

mangra

[former_member228339]

Hi..

MAXSIZE = Maximum size of an individual data packet in KB.

The individual records are sent in packages of varying sizes in the data transfer to the Business In-formation Warehouse. Using these parameters you determine the maximum size of such a package and therefore how much of the main memory may be used for the creation of the data package. SAP recommends a data package size between 10 and 50 MB.

MAXLINES = Upper-limit for the number of records per data packet

The default setting is 'Max. lines' = 100000

The maximum main memory space requirement per data packet is around

memory requirement = 2 * 'Max. lines' * 1000 Byte,

meaning 200 MByte with the default setting

3 THE FORMULA FOR CALCULATING NUMBER OF RECORDS

The formula for calculating the number of records in a Data Packet is:

packet size = MAXSIZE * 1000 / transfer structure size (ABAP Length)

but not more than MAXLINES.

eg. if MAXLINES < than the result of the formula, then MAXLINES size is transferred into BW.

The size of the Data Packet is the lowest of MAXSIZE * 1000 / transfer structure size (ABAP Length) or MAXLINES.

https://www.sdn.sap.com/irj/sdn/directforumsearch?threadid=&q=cube+size&objid=c4&daterange=all&numre...

[Former Member]

Hi,

check whether you have followed the same procedure to set the DP size in source sytem

Please use the below mentioned formula to caclculate DP size

The packet size can be calculated as

packet size = (Maximum size of the OLTP/BW system *1000)/ Transfer structure size.

If the maximum line size in OLTP system is less than the result of formula,the maximum line size as in OLTP system is transferred to BW, else the size as obtained from the above formula is transferred to BW.

For further information refer OSS note 409641:Examples of packet size dependency on ROIDOCPRMS.

to check MAXLINES defined

. Log on to R/3

2. Go for SBIW

3. Expand Data transfer to SAP Business Information

warehouse

4 .Expand General settings

5. Execute Maintain control parameters for data

transfer

please let me know if you need any help!!!!!!!!!!!!!

Regards,

Swapna.G