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 are the different objects in di api ?
your process chain link with ABAP Program,suppose your ABAP Code need some changes how you do this(your process chain is in running stage)
what is cumulative and non-cumulative key figures in sap bi?
Why we are going for customization? Give me a scenario..
What is di api in sap business one?
Difference between filter and condition in sap bi
What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution
1 Answers GHG, KPIT, Mind Tree, NTT Data,
How to use abap start routine and end routine what is the code? Where it be coded?
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 UNION and UNIONALL
1 Answers Axtria, ITC Indian Tobacco Company, TCS,
What are the different types of transactions supported by di api ?
Why we have only 16 Dimension tables in a cube.Is there any reson.Is it a limitation?
4 Answers Enteg Technologies, IBM, Infosys, TCS, Wipro,