Skip to Content
avatar image
Former Member

Enhancement of the datasource is taking lot of time

Hi Experts,

we enhanced the datasource 0employee_attr almost 35 fileds but every thing fine when we are loading it taking almost 20hrs . these reports are using every day .how to reduce the loading time .iam not written any routines i thought its happened in R/3 side because lot of select statement.can any one suggest me on this issue.

Regards

sivaraju

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 08, 2008 at 08:00 AM

    Whats the time it takes when you check in RSA3 ???

    You can trace using ST05 as to where its taking more time in the R3(source system) side.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 06:07 AM

    Hi,

    it may be due to performance issue in data source 0EMPLOYEE_ATTR.

    Check SAP Note Number: 1063469

    Hope this helps you ..

    Reagds,

    shikha

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Akshay Chonkar

      HI,

      its already in production almost 4 reports are using on this . if i go for redisgn they wont agree .do u have any other solution.

      regards

      sivaraju

  • avatar image
    Former Member
    Oct 08, 2008 at 07:58 AM

    Is the time taking in the cmod? - check the job logs in R3 to check this or is it in the RFC scheduler

    Have you traced the cmod code - are you going in on indexed fields?

    Have you put extra indexes on the tables whereyou are doing non indexed selects

    As with all BW implementations - we earn our money anticpating data volume problems before stuff goes into production

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2009 at 11:53 AM

    Hi Kolli,

    I am facing a similar issue with my 0EMPLOYEE_ATTR extract (RSA3 times out also as taking too long). Did you manage to get your problem fixed - if so, what was the solution? Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded