IBM Support

BiLog: QBE – Extending thru QBR

Technical Blog Post


Abstract

BiLog: QBE – Extending thru QBR

Body

 QBE (Query by Example) is an excellent way for you to quickly take the results of your application query and/or filters and export them to Microsoft Excel.  You can then view each of the list tab fields, and perform additional analysis, combine the data with other queries, print, or save.

However, often users want to see additional fields in the exported data.  And the fields that one user may want to see are not the same as fields another user may want to see.  You can modify the list of fields that displays with the Application Designer.  However, this involves resources, planning, and space limitations.
 
You can provide your users the ability to

             Apply application filter and/or query

            Select their unique fields or database attributes

            Download to Microsoft Excel

            Without Application Designer Modifications

 thru QBR (Query Based Reporting).   QBR is available from essentially any application, and you can quickly select the fields you want to export to Microsoft Excel with a few simple clicks.

 You can execute this a single time, or save your QBR report to execute again in the future.  You can also schedule the QBR so the results appear in your email inbox – along with others - on a preconfigured time period.

 You can find more details on the QBR functionality at this V7.5x QBR guide located here or the V7.1x QBR guide located here

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11134549