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 |
What is the difference between canceling the sales order and closing the sales order?
What are the different types of datasources ?
AFTER A PURCHASE ORDER HAS BEEN APPROVED, AND PRINTED, AND THERE IS NEED TO MAKE CHANGES ON THE P O, DO I CANCEL THE OLD P O OR DO I JUST EDIT AND SEND FOR APPROVAL?
i am raj i have attended lot of interviews but i could not get job. the interviwer asking me some real time scanrions please tell me any one . 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ?
If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.
Difference between filter and condition in sap bi
Can anybody explain the what is "OLTP"(Online Transaction Processing) and "OLAP"(Online Abaytical Processing) in SAP BW/BI? and also plz explain What is the differences between those two? Thanks in advance, Phani
What are three dimensions provided by SAP?
Can we do aggregation in sap crm planning cube?
Hi Experts, What are the common Transport errors in SAP BW?
What is a/p invoice ?
How to fill data in recordset ?