Skip to Content
avatar image
Former Member

DTP is taking long time while loading data from DSO to cube or Cube to Cube


Hi ,

When i try to load the data from DSO to cube or cube to cube , dtp is taking long time.

we are using dropping?creating step in PC.

we are loading 10 lakhs records which is taking 1.30 Mins.

No Start/End routine. No formula.

In DTP monitor, i found it is taking time in "Conversion of Characteristic Values to SIDs" step.

could you please advise.

Regards,

Vinay Saraf

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    May 20, 2015 at 11:15 AM

    Hi Vinay,

    This error is coming because SID is generated at the time of loading data to info cube. So better to create SID at the time of activation of DSO only. So data loading will be good and time will be less because conversion of characteristics to SID will be avoided.

    Loading data from cube to cube is rare.

    Follow DTP performance activities also.

    Thanks,

    Swapna Jain

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vinay,

      Anyhow, you loaded master data first and then you are loading transaction data. So SID is generated at the time of loading master data only. But if for some characteristics SID is not generated, then it will get generate. Now the question is When it should be created?

      You are transferring data from DSO->Cube right. First you are loading data to DSO but you are using it as a staging layer so skip SID generation upon DSO activation.

      But if you are having reporting on DSO then you should do SID generation upon activation. So the reporting performance will be good.

      Thanks,

      Swapna Jain

  • May 20, 2015 at 08:13 AM

    Hi,

    can you increase the parallel process in the DTP screen.

    increase to 3- 6 process.

    select the DTP -> go to the go to menu-> select setting for batch mangaer -> increase the process -> save it execute the DTP.

    check the process avalibility in SM50/51.

    -Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vinay,

      please look into the sap note, which talks about compression how it improves your create or delete index performance.

      590370 - Too many uncompressed request (f table partitions)

      407260 - FAQs: Compression of InfoCubes

      Regards,

      Vengal.

  • avatar image
    Former Member
    May 20, 2015 at 12:21 PM

    Hi All,

    Look at the below screen shot.

    I was taking about this.


    Capture.PNG (6.1 kB)
    Add comment
    10|10000 characters needed characters exceeded