cancel
Showing results for 
Search instead for 
Did you mean: 

BW performance issues

Former Member
0 Kudos

Hi gurus,

today i import a my developpemnts on the production system and everything is Ok exept time of update. when i load data into PSA there's no problem but in the infocube update step it is too long.

But on my dev or itegratin system for the same infocube and sema volume of data i didn't have any such problem

I don't know where i have to check.

ST22 --> nothing

SM21 --> Nothing

Thanks

Cyril

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Cyril,

Data loading to data target (cube ) can take time if your update rule , or some routine must be working slow. Check update rule & routine.

It could be because of Index (primary /secondary) . Check the table in DB02.

To improve the load performance delete cube index and rebuilt them after data is loaded.

Hope this helps

Former Member
0 Kudos

thanks for your feedback

i already check SM50 and SM51 without something special.

But i find my problem : in update rules there was a link with 0calmonth, calyear,... affected to calmonth and calyear from infosource but in the transfer rules there is no affectation so the problem was that it updates value '00000' in the infocube.

I found the problem with RSRV and the difference with my test system is due to a bad transport.

Thank s for help the problem is solved.

Cyril

Former Member
0 Kudos

Hi,

first of all you need to check wether a process is running or not via sm50 or sm51. If that is still the case, I think you need to improve the coding in your update rules or you have lots of characteristics in the cube and the time for gettings sids and dim ids takes to long.

regards

Siggi