This website is not affiliated with, sponsored by, or approved by SAP AG.

Data Load issues post SP8 upgrade

Business Warehouse

Moderators: Snowy, thx4allthefish

Data Load issues post SP8 upgrade

Postby dave0964 » Mon Mar 21, 2011 2:18 pm

I need some urgent help please.

We have noticed that since we upgrade our SAP BI 7.1 EHP1 SP3 to Support Pack Level 8, the timings for our data loads have increased, some of them significantly.

We have reviewed the data load processes, DTP's, transformation, RSRV tests, basis parameter settings and pretty much exhausted every avenue.

Has anyone had similar experience with SP8 upgrade and if so can you provide some direction.

We did engage with SAP and they advised us to run program RSDD_RSTMPLWIDTP_GEN_ALL to regenerate the write program but that doesn't seem to have improved anything.

This is an urgent issue and I would very much appreciate it if we could get a quick response.


Thanks in advance,

David
dave0964
 
Posts: 64
Joined: Wed Nov 06, 2002 12:43 pm
Location: Ireland

Re: Data Load issues post SP8 upgrade

Postby dave0964 » Fri Mar 25, 2011 7:34 am

Hi All,

Based on recommendations from SAP, we made some updates to coding with the transformation routines.

The SP8 seems to have highlighted inefficiencies in the coding which post upgrade were degrading the load process.

Once the modifications were made, our load times returned to acceptable levels.


Thanks,

David
dave0964
 
Posts: 64
Joined: Wed Nov 06, 2002 12:43 pm
Location: Ireland


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 8 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.