12 31 2012

A suite of reports comprised of Accounts Payable (AP) data are now available in the SWIFT Data Warehouse via OBIEE (Oracle Business Intelligence Enterprise Edition), the SWIFT Data Warehouse query and reporting tool. In addition, associated AP subject areas are available for use with OBIEE analysis.

All users who have SWIFT inquiry roles for Accounts Payable data plus at least one General Warehouse role will have access to the OBIEE AP reports and subject areas through the SWIFT Data Warehouse Access page on the SWIFT Administrative portal.

New OBIEE AP Reports

This suite of linked reports, presented on the new Accounts Payable OBIEE statewide dashboard, includes:

• All AP Expenditures
• Payment Count
• Payment Remit Address
• Voucher/Voucher Line Count

Supporting Documents - Information about these new OBIEE reports is available on the SWIFT Website:

• Accounts Payable OBIEE Dashboard and Analysis Report Summary: This document provides summary information about the new OBIEE dashboard and associated reports.
  Accounts Payable (AP) OBIEE Dashboard and Analysis Report Summary (pdf format)

• Running OBIEE Reports: For an example of how to navigate through OBIEE to run reports, see the OBIEE General Ledger and Commitment Control Reports guide which provides step by step instructions for accessing and running reports.
  Running the OBIEE Commitment Control and General Ledger Reports (pdf format)
  

New AP subject areas for OBIEE analysis includes:

• Accounts Payable - Expenditures

(FMS - ALL- Expenditures)

This subject area contains source expense account entries that reconcile to the General Ledger and Commitment Control Expenditure Ledger. Currently this subject area contains only Accounts Payable accounting entries. Additional entries will be added as the AR, GL and PC modules are completed.

• Accounts Payable - Account Entries

(FMS - AP- Account Entries)

This Accounts Payable subject area contains all accounting entries posted by the Accounts Payable module.

• Accounts Payable - Voucher

(FMS - AP- Voucher)

This Accounts Payable subject area provides for analysis of AP information and related detailed payment information at a voucher payment level of detail.

• Accounts Payable - Voucher Distribution Line

(FMS - AP- Voucher Distribution Line)

This Accounts Payable subject area provides for analysis of AP information and related detailed spending information at a voucher line level of detail, including voucher line accounting distribution.

• Accounts Payable - Voucher Header

(FMS - AP- Voucher Header)

This Accounts Payable subject area provides for analysis of AP information and related spending information at a voucher header level of detail.

• Accounts Payable - Voucher Line

(FMS - AP- Voucher Line)

This Accounts Payable subject area provides for analysis of AP information and related spending information at a voucher line level of detail.

• Accounts Payable - Vouchers and Payments

(FMS - AP- Vouchers and Payments)

This Accounts Payable subject area contains supplier payment information for AP vouchers.

Supporting Documents - Information about OBIEE subject areas is available on the SWIFT Website: SWIFT Data Warehouse Main Content

A listing of all available OBIEE FSCM Subject areas is available at:

New to OBIEE? An online training course, Introduction to OBIEE: Learning Access, Navigate and find Data in the SWIFT Data Warehouse, is now available on the SWIFT website as well. This online course provides an overview of the SWIFT Data Warehouse, along with instruction on OBIEE navigation and running, printing, and exporting OBIEE analyses (reports).

Check here for additional information about the SWIFT Data Warehouse: http://www.swift.state.mn.us/swift-data-warehouse