FAQ
Data Warehouse - Data Dictionary
Information Data Warehouse has published a Data Dictionary, sharing all of the State Datawarehouse Tables and Fields. Some tables have details and joins to use, where other less commonly used tables simply share the field names. This should be ...
Excel Querying Data Warehouse (Microsoft Query)
It appears recent Office 365 Updates (2024) have impacted the menu choices for those of you who use the Microsoft Query to access State Data Warehouse. If you no longer see the Microsoft Query in the 'Other' query option, please see below for ...
COGNOS does not open / COGNOS URL not found
Oddly when attempting to open Finance Cognos, the URL ufbi.finance.utah.gov/bi/bi may come up This .../bi/bi URL will not open cognos. It will display the Not Found error. Instead , make sure you are the correct URL, when using type ahead in your ...
API Connections
The Division of Finance is currently working on establishing the platform, security and procedures for API connections to FINET. While we hope to be able to open FINET API in the near future, at present we are in the very preliminary stages of this ...
What are the Account Type Codes in the Online Accounting Journal
Background Data Warehouse has an Account Type Column in the Online Accounting Journal. These codes are only in Data Warehouse and are not pulled from FINET. They are present to organize the different accounts in Data Warehouse. Legend Below is a ...
ODBC Connection Error When Connecting to Data Warehouse via Microsoft Access or EXCEL
Problem An error is received when trying to access. ODBC call failed Specified driver could not be loaded due to system error 126: The specified module could not be found. (Adaptive Server Enterprise, C:\Sybase\DataAccess\ODBC\dll\sybdrvo.dll)(#160) ...
Error Using Warrant Queries "Check/EFT"
error "Alert - There is a problem retrieving query data. Please contact System Administrator" RESOLUTION - just type the number in without the "F" No alpha character in front of the check number, just numbers. You do not need to include the leading ...