Sales Order - Line Level Information in Info cube

[Former Member]

Hi BW Guru's,

We are using the following scenario: -

Info cube = Sales Order – Line level information (yes, we want to capture the product level sales order information in info cube for our internal reporting purpose)

ODS = NO. we are not using the same

Info Source – Same as data source (standard one)

Data Source – 2LIS_11_VAITM (standard business content data source for sales order information)

Delta in above data source = contract related information (5 extra fields) – working fine – added as append structure in the data source

Extractor = Standard using SBIW - Perform setup - SD Sales Order (SD – 11)

Number of Sales order line records / month = 80,000

Historical Sales order data to be uploaded = 1 year = 80,000 * 12 = Nearly 1 Million records

Hardware Configuration = 4 * 750 MHZ, 8 GB RAM

Please advice on the following things: -

1) How long it will take to upload 1 million records in BW?

2) Does our server capacity sufficient enough to take 1 million load?

3) Which delta procedure should we follow for day to day Sales Order line level data updation? Please advice on data selection procedure.

4) In case, last month Sales Order is changed, how to reflect the same in our info cube? Please suggest the suitable method.

Waiting for your reply.

Thanks

Rajiv

[Former Member]

Hi Rajiv,

1) How long it will take to upload 1 million records in BW?

This depends on your network, on the width of your data record, the performance of your machine, on the settings for communication between BW and R/3 ....

It can be done in 2 hours, in 3 hours, it can take a whole day. There is no exact answer possible.

2) Does our server capacity sufficient enough to take 1 million load?

If your disc space is enough, no problem. If you already loaded your master data, there is not too much space necessary to load the transactional data.

3) Which delta procedure should we follow for day to day Sales Order line level data updation? Please advice on data selection procedure.

Just run your initial setup and initialize your delta. Run a daily delta package (this is what most companies do).

4) In case, last month Sales Order is changed, how to reflect the same in our info cube? Please suggest the suitable method.

The extractor takes care about this, just post the delta to your cube, that's it.

Hope this helps,

regards

Siggi

[Former Member]

Siegfried,

Thaanks for ur valuable info.

can you please provide more detailed information on Q. 3 & 4..

Please help

Cheers

Rajiv

[Former Member]

Hi Rajiv,

what exactly do you want to know?

Siggi