How you approach when you find that your process chain take
a lots of time for loading,tell me the step to increase the
loading performance,
Answers were Sorted based on User's Feedback
Answer / guest
1) change log clean up.
In RSPC > Use process type 'Deletion of request from change log'. In process chain variant options > enter no of days for data in change log to be cleaned.
2)Use RSPC_LOG_DELETE to delete old logs.>> specify the time period for the old logs to be deleted.
3) if "delete index" and "create index" process types are there in process chain then remove those process types and create a separate chain with them.Schedule this chain when the load is low.
4) Check for table space in DB02/DB02OLD and contact basis.
5)Kill the long running backend jobs in sm66/sm50
Is This Answer Correct ? | 7 Yes | 0 No |
Data load has to be checked through RSMO. In which, data
load status to be monitored.
It might be problem with connectivity b/w BI and Source
system or it might be because of data load package size. If
it takes longer than normal load time, then mostly package
load will fail.
For that, data load has to be started manually.
NOTE: Data load mustn't be stopped in middle for ETL
process through PC.
Tocheck for connectivity we use SM59.
Is This Answer Correct ? | 1 Yes | 0 No |
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
What are the features of sap business one include?
What is a/r invoice ?
if someone interviewer ask me briefly explain your sales flow in your project ?-rajesh
how to migrate the cube data from bw to bi? explain and give me the steps
process chain failure notifications
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
Hi Experts, 1. Can any one tell about how to know the Cube size 2. How to delete single Wrong transaction in Cube
Explain core modules of sap business one?
why u r creating custom cube. wht is scenario to creating the custom cube.
How do wé delete '0' values in the crm planning infocube 0crm_c01