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 |
If You Create a Compounding Attribute How many primary Keys it Generates?
How many types of Routines in SAP BI(7.0)?
29 Answers IBM, TCS,
How to use abap start routine and end routine what is the code? Where it be coded?
how to write a customise code in reporting replacement path
Why we are going for customization? Give me a scenario..
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
What are the different types of datasources ?
What is used in sdk for developing a form ?
hi frnds dc's suma.could u tell me this one.(suma.sapbi@gmail.com).I have 2 Data Sources sales and Billing.I have 2 Cubes called 1.sales cube and 2.Billing Cube with its own Data,Now i want to add Sales Data to Billing Cube.How Can it Possible,Can you any one Explain?
5 Answers Cap Gemini, HCL, IBM,
Can we format BEx reports/graphs using HTML and CSS
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
How do wé delete '0' values in the crm planning infocube 0crm_c01