Technote (FAQ)
Question
What is Query Based Reporting (QBR) or Ad Hoc Reporting?
Answer
Query Based Reports (QBR) are enabled to meet the Ad-Hoc Reporting Needs of Users. QBR’s enable Users to create their own unique report by selecting columns, specifying sorting and grouping, and the query the report will run against. Once the user saves the report, this information is fed through an API to create an xml report design file, which is then executed thru the BIRT Report Engine.
This document reviews the QBR functionality and its process flow. It then details how an End User can Create and Execute Ad Hoc Reports. Finally, it concludes with information on the setup work involved in enabling Ad Hoc Reports, including Administration and how to enable Report Object Structures.
**Note: A number of feature updates were made to the QBR Functionality in Maximo Base Services Release 7.1.1.6, which was released in December 2009. Because of the extent of these changes, a separate guide is available detailing the QBR Functionality in the 7.1.1.6 and future releases. This guide can be accessed here
For more details on other reporting features, access the Maximo Report Wiki Pages available here
http://www.ibm.com/developerworks/wikis/display/maximo/Reports
or the Maximo Report Reference Materials located here
http://www.ibm.com/developerworks/wikis/display/maximo/Report+Reference+Materials
Revision History
Revision 5 – September 2012
Updates include (1) Added information on Security Best Practices (2) Added reference material section (3) Included text for error messages for searching ease (4) Miscellaneous text updates for clarification
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Systems and Asset Management | Tivoli Asset Management for IT | All | 7.1, 7.1.1 | ||
| Systems and Asset Management | IBM Maximo Asset Management Essentials | All | 7.1, 7.1.1 | ||
| Systems and Asset Management | IBM Maximo Asset Management Essentials | All | 7.1, 7.1.1 |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.