Skip to Content
author's profile photo
Former Member

Query View Usage statistics

Hi ,

We are analysing the statistics data in 0tct_c01 and 0tct_c02 to determine the query view usage.

But the query view information is not recorded along with query information. We already raised a issue with SAP but they say

that this funcionality is currently not availavle.

Is there any way by which we can find query view usage per user?

Regards,

Shital

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Feb 02, 2011 at 07:39 AM

    Hi Shital

    Check this below step - might help you

    1) Run the Transaction code ST13

    2) Select the tool name as : BW_QUERY_USAGE and execute

    3) Select the data range and execute based on the following selection

    All Queries?

    Detail1

    in SAP Netweaver BI 7.0 Query Runtime statistics is split into two major parts

    1) Front End and OLAP Statistics : Provides - Runtime of BI front end application and Runtime of Query in OLAP Processor

    2) Data Manager : Runtime for retrieval of data from BI Info Provider or the BI Accelerator

    Refer following SAP Documentation links :

    http://help.sap.com/saphelp_nw70/helpdata/en/43/15c54048035a39e10000000a422035/frameset.htm

    http://help.sap.com/saphelp_nw70ehp2/Helpdata/EN/44/57f2c19b1a311de10000000a155369/content.htm

    Let us know if this helps.

    Much Regards

    Jagadish

    Edited by: Jagadish Thirumalachetty on Feb 2, 2011 3:09 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 02, 2011 at 10:05 AM

    Hi Shital,

    Check the tables

    If you are working with

    BW 3.5 you can look in table RSDDSTAT

    In BI 7.0 it is RSDDSTAT_OLAP.

    Make a selection on the info cube and the OLAP Statistic Object which is the query ID and execute. Then you should see how often the query was executed, by whom and which date/time. in field Query ID you type in the tech name of the query

    Regards

    KP

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 02, 2011 at 08:33 AM

    ST13 does not give option to calculate statistics for query view.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      *We have different ways of finding query usage(By the user).

      1) in st03 transaction

      2) ST13 transaction.

      RSRT and ST13 are direct to know the details.

      Process:1 ST13 process:

      ST13-> BW_QUERY_USAGE-> Secify the user name and Time stamp and execute.

      Note: ST13 will be available only when ur system is upgraded to SP20 or more.

      Process:2 ST03 process.

      For Query Statistics: U can use RSRT or RSDDSTAT_DB & RSDDSTAT_OLAP tables.

      Go to RSRT -> give the query name->Execute + debugg-> select display statistics and execute the query -> go back of the session you wil find the query statistics i.e. OLAP time/dbtime/front end ...etc.

      Hope this helps you..

      Best Regards,

      Maruthi

  • author's profile photo
    Former Member
    Posted on Feb 02, 2011 at 09:22 AM

    Hi shital ,

    If you have installed BI Admin cockpit ,

    Then try these queries :-

    0TCT_MCA1_Q0141 and 0TCT_MCA1_Q0142 .

    or in the Bi Admin cockpit portal you can check underneath

    Query run time Statistics - > BI Application Object Status

    These will give you the required details .

    Regards ,

    Lokesh

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 02, 2011 at 10:08 AM

    Hi Shital

    Goto RSRT .

    Select your query.

    Click on Execute + Debug button.

    On others tab .

    Select Display Statistics Data.

    OK.

    After Execution.

    Click on Back button.

    Now you are on the tab of Statistics Data For Query Runtime.

    Hope this will help

    Thanks

    Avenai

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 02, 2011 at 01:18 PM

    All the above steps give details about query statistics. I wanted to know usage of query view.

    Since query view finally hits query , everywhere it is showing query usage.

    I want to know , is there any way find query view usage.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shital,

      Could you please let us know if you were able to get the query view usage statistics and what was your experince based on that.

      Many thanks

  • author's profile photo
    Former Member
    Posted on Nov 08, 2011 at 07:00 AM

    HI ,

    I am Also trying to solve same issue and I am not able to give time Stamp in proper format.

    Could u please help me with Time stamp format for ( 01.01.2011 to 07.11.2011) range.

    Regards

    Amit

    Add comment
    10|10000 characters needed characters exceeded