understand the different DTP processing mode

[Former Member]

hi!

I have a master data infoobject that startet to load data very slow some time ago. I started to investigate the log of the load to see if there are any difference between tht fast load and the time the load started to go very slow.

What I did see is that the "Processing mode" in the DTP had been changed. It had gone from mode "Serial Extraction, Immediate Parallel Processing" to mode "Serially in the background Process". In addition I can see that the numbers of parallel load are sett to 5 (in the Goto -> setting for batch manager" when having the DTP active). Do not know if the last one can have any affect on the performance

I have tried to see if I can create a DTP that give me the first mode, but I am not able to get this as a selection.

[Former Member]

Hi,

double click on your DTP:

go to "Execute" tab and if you check processing mode it should give following three options

1: Parallel extraction and processing

2:Serially in the dialog process (for Debug)

3: No data transfer ;Delta status source:

so you can select parallel extraction and processing and execute.

If you select second option that is serially in dialog processing it is only if you have breakpoint fix and you need to debug your routine or code.

attached JPG file.

Thanks,

Bhupesh

[Former Member]

Hi!

I only have two options:

Serially in the background Process

Serially in the dialog Process (for debugging)

So how can I get the option called "Parallel Extraction and Processing" options available?

[Former Member]

use:

Serially in the background Process

Thanks,

Bhupesh

[Former Member]

use folloing link.. it might help you..

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/47/e8c56ecd313c86e10000000a42189c/frameset.htm

http://sapanalyticsguru.com/downloads/BI/LOADING/Explore%20to%20the%20Execute%20Tab%20of%20Data%20Tr...

Thanks,

Bhupesh

[esjewett]

Hi Helge,

Something must have changed if your processing modes changed. Here is a very helpful decision tree ... in German: http://help.sap.com/saphelp_nw73/helpdata/en/48/0371981fc43c99e10000000a42189c/frameset.htm

(Someone probably needs to have a little talk with the SAP content and documentation team about this . )

Is it possible that Semantic Groups in your DTP were turned off? That could cause this problem in some situations. Or do you have semantic grouping turned on but no key selected somehow? That could also cause the problem. Depending on your support package, semantic grouping may be incredibly buggy. BW 7.0 SP14 - SP18 were a very bad time for semantic groups, if I remember correctly. You may need to delete the DTP and recreate it to get a new grouping to "take".

Regards,

Ethan