cancel
Showing results for 
Search instead for 
Did you mean: 

Tracking Hits etc statistics on BW queries

Former Member
0 Kudos

EP6.0 provides the functionality of tracking the number of hits on the iViews, allowing us to figure out who is accessing what kinds of data in BW.

Our customer has a question on how to do this in EP5.0, as their upgrade is an year away, or how to do it via custom code in BW itself.

Thanx and best regards

Sanjay

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

if stats are activated for your cubes (in RSA1), each run of query (anyhow via web, template, query, bex, workbook, view, even rsrt...) are recorded in table RSDDSTAT.

With cpu time, db time, nb of rows scan...

There are many doc or oss notes on table RSDDSTAT

Former Member
0 Kudos

The technical content provides an InfoCube 0BWTC_C02 and some queries that help you there.

Just activate it and check it, there are lots of interesting queries.

Best regards

Dirk

Former Member
0 Kudos

Hi Dirk

Thanx very much for your reply. Will check this out, looks very promising.

Thanx and best regards

Sanjay

Former Member
0 Kudos

Hi,

I have my BW statistics on.However only the queries that are run through BEx are being recorded for the data and not the reports that run through portal. How would I get info about the queries that are being hit in BW while running the reports on the portals side.

Thank You

Srishti

Former Member
0 Kudos

Statistics collection is set at an InfoProvider level.

Is it possible the web queries against a different InfoProvider than the BEx quereis and you just need to tunr statisitcs collection on for the InfoProvider?