Current Position:Home > query to generate report summary in awr

query to generate report summary in awr

  • Query on generating report using XMLP based on a search spec Updated:11-30

    Hi, We are using XMLP reporting tool to generate reports for our application. Our requirement is to generate reports based on a search spec. Should I send this search spec as a input parameter to the FO processor? In other words, what is the exact pr

  • Query to generate report in order Updated:11-30

    Hi , I want to generate report in below order using sql query. In this col2, col3 and col4 will have only 1 value at time remaining will be NULL. What i want is i want to group by Axx or Bxx or Cyy in a specific order based on col2, col3 and col4. pl

  • Report Summary in Awr Report Updated:11-30

    Hi, I have doubts in Report Summary scection in AWR report.Please anyone clear it. 1,What is W/A MB processed? 2,What is the difference between logons in load profile section and Sessions in snap info section? Logons means connection which may one or

  • FIFO Query to generate report Which relates the out-quantity to in-quantity Updated:10-11

    Dear Experts, I am trying to generate a report to find out the Inward documents of Items which are issued or transfered. Items are managed with FIFO. Certain Items are serially managed and certain not. I am using the tables OIVL, OIVE and OIVQ for ge

  • Urgent ; SAP Query for generating report  from BLNR ,DOCNR and oth in NEWGL Updated:11-30

    We are posting document to 5 ledgers.There is a leading ledger and 4 non leadING ledgers. One Ledger contains the detailed information , and I need to add all the fields information when I create that report. We want BLNR field to be the reference fo

  • How to fetch latest data from database instead of clicking on Generate report in RSRT? Updated:11-30

    Hi all, We are not able to get latest data of BEx query.Everytime we have to click on Generate Report  button in RSRT for getting latest value. Is there any way to get latest value automatically? We are not doing any changes in query. When we click o

  • How to define the PLD of a Query generator report Updated:10-11

    Hi All, I want to define the PLD of a Query Report. Currently I am Convertning it to Excel format. But my client wants it in PLD format.  so please tell me the process of defining the PLD for a Query generator Report. Thanks & Regards Pankaj Sharma.H

  • Generating report from Backend Query in OIM Updated:11-30

    Hi, I am trying to generate a report in OIM. The requirement is to generate a query that can be executed in the database to retrieve the following: All the users in OIM with out the access (Not in provisioned or Enabled state) to Active Directory I t

  • GRAPH in Query Generator Reports Updated:11-30

    Hi Experts, I would like know what is the logic to generate graph in Query Generator report. you can see there is graph button in Query Generator window, if you click on this button, shows popup window with graph. i am not sure what is the logic they

  • Cannot build the query or generate the report. WIS 30351 Updated:11-30

    I am trying to create a docuemtn using SDK. I have created a document and when I try to add dataprovider and update the document, I am facing the below error Cannot build the query or generate the report. WIS 30351

  • Cannot build the query or generate the report - BI4.0 Dashboard on WebService Error Updated:11-30

    Hello All,      I am trying to create a Dashboard with WebService connections in SAP BI4.0 SP04. While running the dashboard I am receiving the error, Cannot build the query or generate the report. I have already set the refresh parameter to TRUE (bo

  • Query to generate a report for incoming pending payments as per Item Group! Updated:11-30

    Dear All, I need a Query to generate a report for incoming pending payments through Item Group. Please provide me the same. Thanks in advance.......................... Edited by: Param Deshwal on Nov 22, 2011 7:11 AMHi      try this SELECT T0.[DocNum

  • Generating report based on dynamically generated sql query Updated:11-30

    I have to rewrite asp reports to oracle reports. The original application has forms in asp where reports are generated dynamically based on the options selected. There are many options to select. Some add filter criteria to where clause. I have no pr

  • Unable to generate BUG summary report in RME Updated:11-30

    Hi, I am unable to generate bug summary report in RME. Even I can not generate PSIRT report as well..LMS always gives error "incorrect credential. enter correct credential" I have checked my credentials are correct... it gives me error

  • Generate matrix summary report in SQLplus Updated:11-30

    I have following coloumns in a table PERSON      (id) EDU     (educated,non-educated) CITY     citycode COUNTRY     countrycode I have to generate matrix summary report in SQLplus. I have to print countrycode in vertical coloumn(LEFT MOST), I have to

  • Not able to generate Report Updated:10-11

    hi, In matrix report as the Number of column field and row field are not certain how do I get to know or point to each column field value for particular row. Other details:- In simple matrix report with column field as 'Division No' and Row field as

  • Error in Generating reports with large amount of data using OBIR Updated:10-11

    Hi all, we hve integrated OBIR (Oracle BI Reporting) with OIM (Oracle Identity management) to generate the custom reports. Some of the custom reports contain a large amount of data (approx 80-90K rows with 7-8 columns) and the query of these reports

  • Error when opening a BW query with Crystal Reports Updated:10-11

    Hi all, I am having problems when opening a BW query with Crystal Reports, the strange thing is that it only happens with the bo user I have created. If I use a user that already exists and that has SAP_ALL authorization it works. I don't know if thi

  • FREC Error while Generating Reports in Quality Center Updated:10-11

    Hi, We usually generate reports using Dashboard module of Quality Center . While generating reports on  a particular PC, we are getting the following error. The SQL Query <sheet1> has failed to run, with the following error: Returned Result is not v

  • Multi-query group above report creates more pages Updated:10-11

    Hi, I have a multi-query group above report (paper only), the parent group creates 5 rows(subframes) all onto the same page, but then creates 4 more IDENTICAL pages!!? at the end I have 5 repating frames and 5 pages. If I set Maximum Records per Page