on 09-18-2007 10:24 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.