For the latest information regarding technology support for the Coronavirus situation, please visit UCI TechPrep.

FAQ Lists

General

    

Most financial reports are open to the general campus with a valid UCI WebAuth login. Employee or Payroll reports will require additional KSAMS roles in order to access.

Please sign up for the UCI-DWH mailing list via this link: https://maillists.uci.edu/mailman/listinfo/uci-dwh

Please check out our 'Data Warehouse Weather Report' section on https://datawarehouse.uci.edu

Your report parameters may be too broad. Cognos has a 60-second server timeout and if the report exceeds that timeout, you will see the timeout error. Please try to narrow down your report parameters some more and re-run.

Please double-check your report parameters to ensure you entered in the proper values. If you believe your report should have returned data, please reach out to the OIT Help Desk to submit a ticket so that the appropriate team can help assist you.

Please use the 'View Query' button on the query page and double-check the 'Qualified Items' to ensure you entered in the proper values. If you believe your report should have returned data, please reach out to the OIT Help Desk to submit a ticket so that the appropriate team can help assist you.

Most of the previous BLISS queries have been converted to DWQuery. You can find them under the 'Legacy Queries' section.

You must be connected to the Campus VPN in order to access DWQuery. You can find more information about the Campus VPN here: https://www.oit.uci.edu/help/vpn/

 

Cognos

---

 

DWQuery

You can email KFS@uci.edu with your suggestions or comments.

No, the KFS GL DWQuery only shows data in KFS, which begins with Fiscal Year 2015 data.

DWQuery is refreshed nightly Tuesday - Saturday. Users can begin running queries at 7am.

Yes, all existing BLISS queries that are still being used will eventually be converted over to DWQuery. As more subject areas get moved over, you will see additional tab at dwquery.oit.uci.edu.

 

Financial Data, Reports and DWQuery

---

 

Research Data, Reports and DWQuery

---

 

Student Data, Reports and DWQuery

---

Scroll Up