IBM Support

Maximo v7 Ad Hoc (QBR) Reporting

Question & Answer


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
or the Maximo Report Reference Materials located here

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

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"BIRT","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"","label":"All"}],"Version":"7.1;7.1.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":"All"}],"Version":"7.1;7.1.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21368000