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
• 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