Skip to Content
author's profile photo Former Member
Former Member

Tracking Hits etc statistics on BW queries

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2004 at 02:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 26, 2005 at 08:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.