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

extraction time

when we r modelling to do lo extractions we have some questions to be answered

1. How much extraction time is expected ?

2. How much data load size

3. Who will have access for which role and if any exceptions ?

If already designed is completed then how to check to get the answers for the above questions. If designed is in starting phase how to check to get the answers for the above questions

Any help is appreciated.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 08:40 AM

    Hi Prasad,

    1) Time depends from several reasons, some of these:

    A) R/3 and BW resources (CPU - Ram - Table Spaces allocation - Number of Dialog and Batch process - ...) --> To be tested on systems.

    B) Volume of data to be transferred. Look at point two.

    C) Number and complexity of routines in CMOD R/3, Transfer and Update Rules --> To be tested on systems.

    D) When upload is done: have you user working on BW during upload ?

    E) Design of Logic Partitioning for cubes.

    2) You can have an idea, but only an idea, of volume to be uploaded checking volume of tables underneath the specific extractor. Also check number of new records every day for understand delta volume. Ask also number of data expacted by users.

    3) It depends by internal roles of company, generally you built a map table in MS-Excel with User V.S. authorization.

    Point 3 is valid if design is already defined or not, due to the fact that with BW you can define authorization also for single values of a Characteristic.

    For point 1 and 2 when design is already defined you can only make checks, and eventually change something (Distribution of process, time for extraction, ...).

    Ciao.

    Riccardo.

    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.