Viewing SQL Query in WebI BusinessObjects Reports

Environment

BusinessObjects

Issue

How do I see the SQL Query in my WebI BusinessObjects report?

Resolution

  1. Open the report and switch to Design Mode.
  2. Open the Query dialog which is the first icon in the query section (looks like a grid with a gear over it).
  3. Click on the link to View query script which is the last icon in the add query section (looks like a page with a checkmark on it).

Additional Information

Need additional information or assistance? Contact the ITS Service Center.

Print Article

Related Services / Offerings (1)

ITS-BusinessObjects
This service is the supported query and reporting tool for the U-M Data Warehouse. Use BusinessObjects to run UM-maintained reports and to create and run ad hoc reports. BusinessObjects interfaces (also known as universes) have been developed for all data in the U-M Data Warehouse.