extraction time

[Former Member]

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.

[Former Member]

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.