Data Warehouse quick reference guides

State agency resources

Quick reference guides for Data Warehouse use.

Below are training materials with step-by-step instructions.

Most Frequently Used Cognos Reports

#1 AM02 Expenditure Summary by Unit

(opens in a new tab)

#2 AM01 Expenditure Transaction Detail by Unit

(opens in a new tab)

#3 AR04 Current and Aged Receivables by Customer Name

(opens in a new tab)

#4 MA02D - Master Agreement Detail Report - Expenditures

(opens in a new tab)

#5 Chart of Accounts

(opens in a new tab)

#6 Line Item Status Report

(opens in a new tab)

#7 Search by Payment Number

(opens in a new tab)

#8 AM12 Revenue Summary within Unit

(opens in a new tab)

#9 IN 26 - Commodity Catalog Search

(opens in a new tab)

#10 AM31 Report

(opens in a new tab)

Data warehouse support resources

Accessing Vantage Financial data, using data warehouse

(opens in a new tab)

Accounting Journal & Labor Distribution

(opens in a new tab)

Building refreshable data warehouse query in Excel

(opens in a new tab)

COGNOS navigation basics

(opens in a new tab)

COGNOS upgrade changes

(opens in a new tab)

Enable Excel legacy Microsoft query

(opens in a new tab)

Finance web and warrant queries

(opens in a new tab)

How to download the Chart of Accounts to an Excel workbook

(opens in a new tab)

How to print a report from data warehouse

(opens in a new tab)

How to run a report without closing

(opens in a new tab)

Introduction to Chart of Accounts

(opens in a new tab)

Modifying an existing Excel query using data warehouse

(opens in a new tab)

Modifying or removing a scheduled report in data warehouse

(opens in a new tab)

Subscribing and scheduling reports in data warehouse

(opens in a new tab)

Using Excel to query data warehouse

(opens in a new tab)

Using Access to query data warehouse

(opens in a new tab)

You might also like...

Feature set release quick reference guides

(opens in a new tab)

Vantage Financial user guides

FINET user guide resource page

(opens in a new tab)

Finance forms

Forms listed by functional area

reports for state agencies

 

PCI Compliance