Financial Query Resources

The following Business Objects queries are available to units seeking additional resources for managing their financials. In order to run the queries, you must have access to the data warehouse and Business Objects. Information on access, training, and other resources for Business Objects can be found on the Decision Support website at: http://www.ds.uillinois.edu/web/Home/CreateReports/UsingBO.aspx.

Feel free to download the queries and alter to suit your specific needs. If you have any additional questions, please contact Matt Wolfersberger.

NOTE: To properly download the queries, you need to right click the query below, choose Save Target As... (in Internet Explorer) or Save Link As... (in Firefox), rename the extension of the file to .rep and save the file on your computer.

Query Name Purpose
Budget Memo Log View budget transactions (both sides of entry) (Business Object file)
Self-Supporting/Gift Cash & Fund Balances View cash & fund balances for Gift & Self-supporting funds (Business Object file)
State & Institutional BBA View State & Institutional Accounted Budget & BBA (Business Object file)
Expenditures by Account Type View aggregated expenditures by account type (Business Object file)
Banner Transaction Detail View banner transactions (Business Object file)

Last Updated: March 19, 2009