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

loading issue from WO DSP to infocube (no answer from this forum before)


Hi expert,

loading from write-optimized DSO to infocube is very slow. I trace the loading process by ST05. a lot of following select statements take up most of the time, which have different variable values. in the corresponding loading monitor, step 'Conversion of Characteristic Values to SIDs' take up most of the time.

I review a lot of threads in this forum, and perform following checks :

(1) SAP_INFOCUBE_DESIGNS, no issue

(2) master data are already loaded before this loading, so no issue with SID.

(3) even though there is no Number Range Buffering, but this is same true for another system , which don't have loading issue for this case. so I don't think Number Range Buffering will resolve this loading issue.

(4) we have 4120972 rows in table /BIC/PZASSET, which have same index as another system . another system does not have this loading issue. so I don't think index is the reason of this issue.

(5) for DTP setting, parallel processes is 10 and job class is 'A'

(6) index for infocube has been removed before loading

(7) this issue loading is the third time loading for this infocube, so I suppose most SID are already in SID table. so no time wasted to create SID while loading

I am wondering what system want to do with following select statement while perform step 'Conversion of Characteristic Values to SIDs' in the loading?

SELECT

"VERSION", "/BIC/ZASSET", "/BIC/ZAASTN", "/BIC/ZAAFEEDER"

FROM

"/BIC/PZASSET"

WHERE

"VERSION"=:A0 AND "/BIC/ZASSET"=:A1 AND "OBJVERS"=:A2 OR "VERSION"=:A3 AND

"/BIC/ZASSET"=:A4 AND "OBJVERS"=:A5 OR "VERSION"=:A6 AND "/BIC/ZASSET"=:A7

AND "OBJVERS"=:A8 OR "VERSION"=:A9 AND "/BIC/ZASSET"=:A10 AND "OBJVERS"=:A11

OR "VERSION"=:A12 AND "/BIC/ZASSET"=:A13 AND "OBJVERS"=:A14

Many Thanks,

Andy

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 12, 2014 at 08:43 AM

    Hi,

    Assuming as your doing full load between wdso to cube.

    There might be some inconsistency at your transformations.

    Try to activate your dso--> cube transformations and check it.

    same way, try to activate your transformation generated program.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Raman Korrapati

      Hi,

      I delete all data from target infocube, and reactivate transformation, and reload, it is very fact for first 260 data packages, but after then, it is very slow when perform step for 'Conversion of Characteristic Values to SIDs', could you please help for it, this is very urgent for me. appreciate very much.

      Many Thanks,

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.