Current Position:Home > How to find last runtime of query and who ran the query

How to find last runtime of query and who ran the query

Update:10-11Source: network consolidation
Advertisement
Hi,
I am doing the analysis for  all the queries  , their last run time and who ran the query
Since there are almost 6000 queries , is there any way to find out last run time and who ran the query
in one step or through any transaction else It would huge effort taking task to check the data in BW statistics
table for each query
Please suggest
Regards,
Vivek

The Best Answer

Advertisement
Hi,
Statistics should be switched ON for all the queries first. You can check this in RSDDSTAT.
Statistics data is stored in BW for a specific period only. This setting can be maintained in table RSADMIN (Field : TCT_KEEP_OLAP_DM_DATA_N_DAYS). If the value for the field is 30, then 30 days old statistics will be available at any point.
Not all the queries will be ran daily. Some are ran daily, monthly and yearly depending upon User requirement.
1. You can check in RSDDSTAT_OLAP for the details you needed.
2. You can install the BI Technical Content and run the respective query for the details you needed.
Hope this helps.
Regards,
Sunil
  • Unknown Column Name "XYZ" not detemined untill runtime.Select query. Update:10-11

    Hi, I have written a query in ABAP.I am getting following error.Can some one help me resolve this.There is a column "LANDX" in standard table T005 of PI which i need to get values from. The problem is that the column is visible only at runtime a

  • I need the Design Repository name in my Runtime repository query?????? Update:11-30

    Hi, I want to execute a query on Runtime repository user. I need to know: Design Repository User (own of mapping execution error) , Mapping Name and Error Message. With this query I have the Mapping Name and Error Message. BUT HOW CAN I OBTAIN THE De

  • Query runtime vs Query execution time Update:11-30

    Hi, I am trying to find the most executed queries (how often queries are executed) in our BI system. I got query runtime from Hitlist in st03 Reporting analysis. could someone tell me if its same as query execution time or where can I check most exec

  • Dynamically set iChart pen colors at page runtime when query data changes Update:10-11

    I have a page with an iChart (3D Bar Chart) where I am currently allowing the pen colors to set automaticlly inthe diplay template.  However, the SQL Query that supplies the data, will return a different number of rows depending on user selections. 

  • How to find last runtime of query and who ran the query Update:10-11

    Hi, I am doing the analysis for  all the queries  , their last run time and who ran the query Since there are almost 6000 queries , is there any way to find out last run time and who ran the query in one step or through any transaction else It would

  • Dynamic calculation of values at query runtime Update:11-30

    Hello, Everybody, I have situation in which I have calculate the value for characteristic at query runtime. Query is based on Infoset SEMPLDATA. In Infoset I have fields u201CEmployee IDu201D, u201CBirth dateu201D, u201CAgeu201D dedicated as virtual

  • Long Query Runtime/Web-template Loading time Update:11-30

    Hi, We are having a very critical performance issue, i.e. long query runtime, which is certainly not acceptable by client as well. <b>Background Information</b> We are using web application designer (WAD) 2004s release to design front end of o

  • Dynamic database connections at Runtime dbAdapter Update:10-11

    Hi I need to connect to a database defined a runtime in a BPEL process using the dbadapter. All the configuration parameters for making the connection are provided at runtime (connectionURL, User, Password) and i need a way to configure them in the d

  • Building a new Cube Vs Restricted Key figure in Query - Performance issue Update:11-30

    Hi, I have a requirement to create  a OPEX restricted key figure in Query. The problem is that the key figure should be restricted to about 30 GL Accounts and almost 300 Cost centers. I do not know if this might cause performance issue in the query.

  • Creating a Query Update:11-30

    Hi experts,       I have a cube with following infoobjects.      Material        Material Description      Customer      Quantity      Value      Year      I have a requirement to design a query with the above data. Which displays      the records of