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

Sales Order - Line Level Information in Info cube

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 12:17 PM

    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

    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.