Skip to Content
author's profile photo
Former Member

DTP and dialog processes?

Dear BW-colleagues,

I am loading data from an DSO to an InfoCube by using a DTP.

It seems that the DTP is <b>always</b> being executed by background jobs.

Is there a possibility to use a DTP by means of dialog processes to fill a cube?

I can not find any setting regarding DTP and background/dialog. If this is not a bug but a normal behaviour, can someone explain me why they choose this approach? Just to get to know the logic, maybe there is a logical explanation.

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 11, 2007 at 02:40 PM

    Hello Bart,

    you can switch to dialog mode for debugging and simulation:

    http://help.sap.com/saphelp_nw70/helpdata/en/45/8594ebd17f1956e10000000a11466f/frameset.htm

    But g

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Ralf,

      Thank you very much for your fast reply.

      I was aware of the simulation/debug option.

      Unfortunately this is not really loading data. I would like to load data in the cube for real, not only to simulate or debug the update rules for instance.

      Is it possible anyway to load data with a dtp in dialog processes?

      Kind regards,

      Bart

  • author's profile photo
    Former Member
    Oct 12, 2007 at 05:21 AM

    to my knowledg, we can't change it. Execute in BGD will increse loading performence.

    If it uses dialog process, you can't use that session till process completes. you don't need to wait till it completes. if you execute any program or loading in Background, you don't need to worry about Time Out.

    Flat File Loads from Local WorkStation or Debugging or Simulation always uses Dialog Process (even in BI 7.0).

    Nagesh Ganisetti.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 11, 2007 at 02:46 PM

    Generally a DTP is executed in background.

    This has many advantages, there is no time_out because of the maximum dialog runtime, you find logs in SM37, if no process is available the job will not fail etc.

    So using background processes is really an improvement. You only have to take this into account when you define the number of dialog and batch processes. With BI7.0,

    Best regards,

    Ralf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thats correct and you can increase the number of BGD processes as below if you are running out of processes.

      RSA1>Administration>Current Settings>Batch Manager>Settings for Parallel Processing>Select Process>DTP_LOAD-->Hit parameter settings

      here you only see background processing available and can check which process can be executed in Dialog or Parallel.

      Hope it Helps

      Chetan

      @CP..