University of Wisconsin-Madison

SFS Data Warehouse

WISDM is not the only way to get SFS data. SFS data views are also available.

• Financial Data View Authorization Form - this form can be used to request access to the WISDM data views (30-Jan-09)
• Hyperion Setup for WISDM Data View Access - (Word | HTML) this document provides instructions for connecting to the WISDM data base (13-June-07)
• Setting up an ODBC connection to the WISDM Database - (Word | HTML) this document provides instructions for setting up an ODBC connection to the WISDM database. They pertain to the Windows 2000 operating system (18-Jun-04).
• Data View Documentation - Detail documentation is available for each of the WISDM data views.
  • Detail Accounting Transactions (Word | HTML) (20-Nov-08)
  • Summary Accounting Data (Word | HTML) (18-June-04)
  • Prior_Year_Fund Balance (Word| HTML) (18-June-04)
  • Detail Payroll Transactions (Word | HTML) (19-Aug-2009)
  • Detail GL and Payroll Transactions (Word | HTML) (20-Nov-08)
  • New Grants Data Views (HTML) (3-Nov-08)

Menu

• Search:
  Business Services 'How-To' Pages Accounting Bursar Internal Audit MDS Purchasing Risk Management SWAP UW-Madison
  
• Accounting Services Home
• Campus Groups
• Coding
• Dates and Deadlines
• Forms
• Policies and Procedures
• Related Links
• Staff Directory
• Training

---

• Areas:
• Accounts Payable
• Cash Management
• File Room
• Non-Sponsored Projects
• Property Control
• Purchasing Card
• Records Retention
• Shared Financial System
• Tax
• Travel and Expense Reimbursement