Prabhu DC’s DataWarehouse

2^n bits {n->∞}

InfoPackage/DTP Package Size

I learnt something new today about Package size while extracting from ECC into BI 7.0.

I happened to notice that one of the datasources which executes in delta mode from ECC to BI was transferring a very high number of packages. What was strange was that, although the number of packages were high, the number of records that each package contained was significantly less. This aroused my curiosity!

I did know that BW internally allocates the package size, but I did not know the criteria on which this was being done.

On reading a few posts at SDN, I figured out the logic behind this golden number called Package size.

[Credits to original posters at SDN]

Package size = MAXSIZE * 1000 / size of the transfer structure,but not more than MAXLINES.

I tried simulating and it worked out like a gem!

Read on to see the steps involved in this simulation. . .

Read more »

January 6, 2011 Posted by | SAP BI | 1 Comment

   

Follow

Get every new post delivered to your Inbox.