NW04s BI Statistics - Response Time does not include time in the SAP portal
Hello. We have a query that, when run through the web (without the SAP portal) runs in about 18 seconds. When run through the SAP portal, it takes about twice that much time, around 34 seconds.
When we look at the BI Statistics data for the query (in cube 0TCT_C02 and the RSDDSTAT_DM view,) the total response time always shows up as 18 seconds, regardless of how we ran the query.
<b>Questions:</b> (1) Why do the BI stats omit the time spent in the SAP portal? (2) Where can we get runtime / rendering time statistics for items displayed in the SAP portal? Does this data exist at all? Does it exist in a format we can extract into a BI InfoCube for analysis?
When you say run through web without portal is that using 3.5 runtime?
For getting detail info on the BI Java stats add the parameter profiling=x to the URL and it will give you details stats on the processing on the Portal side/