We're experiencing inconsistent behavior of the BI Statistics capturing mechanism, possibly after our recent upgrade to SAPKW70015. It appears that only queries run via the Bex Analyzer are correctly captured in log tables (RSDDSTAT), whereas queries run via the Portal are not (instead, we get unknown entries with object name RSDRI, rather than query/infoprovider names in the log tables).
We've developed a very sophisticated application to report on BI usage ( top n queries by infoarea, by infoprovider, by CPU, by DB-records, by OLAP-records, all queries used by a user etc) and to find out who is using which query, as well as associated resource consumption, at any given time, in real time.
This bug completely throws us off balance. We can no longer monitor query acitivites on the Portal; nor can we trust the BI statistics we've collected in the last two years. Another BI installation has reported the same problem to SAP. SAP seems to think upgrade to SP17, which could be a major step, will fix the problem. Is there anything we can do in the mean time to fix this problem without having to wait for upgrade to SP17 ? Is there an OSS note on this issue ?
(we have SAP_BW Release 700 SP15; SAP_ABA/SAP_BASIS Release 700 Level 13; SEM-BW Releae 602 Level 1; ST-PI 2005_1_700 level 5; PI_BASIS 2006_1_700 level 2; ST-A/PI 01H_BC0700 level 0)
Suggestions will be very much appreciated.
Henry Hone.