Finance Data Warehouse

Department of Government Operations

Data Warehouse

The Division of Finance provides accurate financial data in a timely manner to assist state agencies with their management and reporting needs. State Data Warehouse is a repository of state financial information to be used for reporting and data analysis. The primary reporting tool is IBM's Cognos. Information stored in the State Data Warehouse is uploaded nightly from FINET, Payroll, Department of Human Resource Management, and other financial information systems.

COGNOS Business Intelligence

COGNOS Business Intelligence provides access to hundreds of custom FINET reports, along with many other complex reports designed to assist state agencies reconciliation, balancing and forecasting, providing accurate validated results.

COGNOS Finet reports
Old Data Warehouse (1995-2006)
Cognos help documents
Person working in Cognos

Chart of accounts

Chart of accounts provides an index for all financial accounts for the state’s general ledger. View your organization's coding such as fund, program, appropriation and more. Use the chart of accounts to see transaction codes and their description by filtering your search with reports, fiscal year, and department. The more details filtered, the more specific the results you will return!

Chart of accounts
Person working on a chart of accounts

Finance queries

Finance web queries allow users to use predetermined fields and customize the criteria to search by, as well as the criteria and fields they want in the results. Whether you’re searching for payments and their clear date, or for a transaction with a specific vendor, all that and more can be queried here.

This tool allows all users the ability to perform queries into the data warehouse. These results can then be exported to Excel.

Online accounting journal
Warrant and EFT queries
Labor Plus
Vendor name lookup
Online travel query
A laptop displaying some finance web queries

Running queries in Microsoft

If DTS has configured your workstation with the ODBC settings for Finance State Data Warehouse, you can use what is referred to as ‘ODBC’ to access tables and fields in the data warehouse, using MS Access or MS Excel. Access the PDF with instructions.

Using Access to query Data Warehouse
Using Excel to query Data Warehouse
A person running queries in Microsoft

Accounting types and posting codes

Posting codes in FINET track revenue and expenses by a classification. Within data warehouse, we have consolidated these many categories into a shorter list called Account Type. This data translates FINET Posting codes (hundreds) and summarizes them down to a short list of codes to use when querying data warehouse.

View all codes
A computer displaying a spreadsheet

Data Dictionary

Please refer to the linked list, containing data warehouse table names and field names. The data dictionary provides end users the tables that exist in the state data warehouse, that they have access to query. Included in the data dictionary are the field names, and field types, to aid end users in which values to extract data with.

View all field names
Person entering data in a spreadsheet

Help and documentation

Have more questions or want to learn more, follow this link to view how-to documents as well as frequently asked questions.

View all help documents
Person going over some help documents