Question:
A report can take 1 minute to 40 minutes to refresh. BW Speed is really erratic. What can cause this?
The network guys say its not A WAN capacity or response time.
The BW guys say the ABAP response is ok. BW has 20 million records but the tables are not full.
We are on citrix. The BW server resides in the US but my Excel is in the UK.
If I change a query the query will change but I wont see the changes in Excel. I'll then crash out or be crashed out of Excel, losing the workbook changes.
What causes the delay between the server and my Excel sheet ?
I am at my wits end and this problem seems to fall between IT depts.
Any ideas would be appreciated
Answer:
First, activate statistics on your BW system if not done, then analyse steps of querying to be sure of the reason.
Second, create aggreggates on your infoprovider.
Third, if this only occurs on certain queries, analyse them with RSRT1...
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Fred
Many thanks for your reply. Its much appreciated.
Regards
Answer:
Hi,
split the report by useing Go to options.
-vkt
Answer:
Hi ,
How to activate the stats in BW. Is it all activating the cube and enabling that for reporting or I am missing something more?
Regards,
Answer:
Steps
1)Turn on the BW Statistics: RSA1, choose Tools -> BW statistics for InfoCubes
(Choose OLAP and WHM for your relevant Cubes)
2)Check wherther u have overall query performance problem or Single Query Performance problem
a)overall query performance problem
Use ST03N -> BW System load values to recognize the problem. Use the
number given in table 'Reporting - InfoCubes:Share of total time (s)'
to check if one of the columns %OLAP, %DB, %Frontend shows a high
number in all InfoCubes.
You need to run ST03N in expert mode to get these values
2)Single/specific Query performance
TX- ST03N
Use Details to get the runtime segments
possible causes for the performance
A) High Database Runtime
B) High OLAP Runtime
C) High Frontend Runtime
Depending upon ur analysis
A)Strategy - High Database Runtime
Check if an aggregate is suitable (use All data to get values
"selected records to transferred records", a high number here would
be an indicator for query performance improvement using an aggregate)
Check if database statistics are update to data for the
Cube/Aggregate, use TX RSRV output (use database check for statistics
and indexes)
Check if the read mode of the query is unfavourable - Recommended (H)
B)Strategy - High OLAP Runtime
Check if a high number of Cells transferred to the OLAP (use
"All data" to get value "No. of Cells")
a) Use RSRT technical Information to check if any extra OLAP-processing
is necessary (Stock Query, Exception Aggregation, Calc. before
Aggregation, Virtual Char. Key Figures, Attributes in Calculated Key Figs, Time-dependent Currency Translation)
together with a high number of records transferred.
b) Check if a user exit Usage is involved in the OLAP runtime?
c) Check if large hierarchies are used and the entry hierarchy level is
as deep as possible. This limits the levels of the hierarchy that must be processed.
Use SE16 on the inclusion tables and use the List of Value feature on the column successor
and predecessor to see which entry level of the hierarchy is used.
C)Strategy - High Frontend Runtime
1)Check if a very high number of cells and formattings are transferred
to the Frontend ( use "All data" to get value "No. of Cells") which
cause high network and frontend (processing) runtime.
2) Check if frontend PC are within the recommendation (RAM, CPU Mhz)
3) Check if the bandwidth for WAN connection is sufficient
Hope it Helps
_________________
Chetan
@ CP...
Answer:
perfect answer from chetan...
thanx
Answer:
first thing to check:
goto InfoCube > Manage > tab Performance
Check Statistics
if it doesn't bring up a green light, refresh (or create) the statistics
cheers,
El Belgio
Answer:
SAP recommends to use Web Application to access data over WAN. Depending on the network technology, Web Application displays query 4 to 20 times faster than on the excel. Hope this helps!!
Answer:
So far there has been a lot of attention to the BW performance, a mention of WAN performance, but in this case there is another link in the chain - Citrix.
Citrix runs virtual desktop sessions on a server - so in the UK you are just getting an image of a session on a server in the US. I have experience problems with running the BW Analyzer on Citrix at a client of mine. It turns out the the Analyzer is very CPU intensive, though you don't notice on your own desktop. Multiply that out by a number of BW and R/3 sessions and you start getting problems. The eratic response time points to this. My client still chooses to use the Analyzer and live with potential problems, however using web reporting would transfer all the processing to the BW Web Application Server and remove the Critrix factor.
Ken
Answer:
Lot of discussions going on and i had looked at the other Forum answers as well.
But to be fair i agree with fanna -CHETAN's analysis was quite a a bit lucid and understandable.
and to be Honest Too GOOd as an INTERVIEW perspective for person like me
Thanks again CHETAN