DWQuery Guide

Welcome to DWQuery!

Accounting and Office of Information Technology is pleased to announce DWQuery, a new tool to help UCI employees extract and explore their data. This is a new and optimized rebranded version of the BLISS or Datawarehouse Queries that many UCI employees are familiar with.

DWQuery provides the ability for users to access general ledger financial and budgetary transactions for query and analysis. Users may query the data warehouse in detail, including the option to search and find unique transactions within the details of the General Ledger. In addition, search results may be exported to Excel for further data management and reporting. DWQuery is updated at the end of every business day and the performance of the system is quick and very responsive. DWQuery is intended to be a key tool for financial staff and managers.

DWquery represents a significant upgrade to the existing BLISS tool, with many new features and improved functionality. Listed below are some of the available enhancements:

  • Search and explore functionality for analyzing result grid data
  • Multiple Fiscal Year queries
  • Streamlined query criteria selection to quickly build and create queries
  • Significant performance improvements that allow for downloading a large datasets
  • Easier query management options: Edit, rename, delete, and share user queries
  • Enhanced user interface
  • Expanded responsive design

Deployment of the new version will automatically be available on 01/04/18 by navigating to dwquery.oit.uci.edu or selecting DWQuery from the Decision Support portlet in the KFS/Finance tab.

For more information on how to use DWQuery, see the User Guide.

Accessing DWQuery

DWQuery is accessible on ZotPortal in the Finances/KFS Tab. Locate the KFS Decision Support portlet, expand the DWQuery section, and click the DWQuery - KFS General Ledger link.

dwquery loc

KFS BLISS Ad Hoc Query is Retiring

Please note that your saved KFS GL BLISS Queries will not be migrated over. KFS GL BLISS will be retired soon, and we encourage everyone to use DWQuery as a replacement and to rebuild their queries in the new DWQuery.

KFS DWQuery Support

General Financial Management questions should be directed toward the Chief Financial Officer(s)/Fiscal Officers of your unit/department, as there may be specific unit/department policies relating to your financial operations.

For general help with the KFS GL DWQuery, contact the KFS Helpdesk at kfs@uci.edu. For technical assistance with the interface, contact the OIT Help Desk 949-824-2222 or oit@uci.edu.