Running Data Warehouse Reports with Excel

Run standardized Data Warehouse reports of historical BASIS data using the SAS Add-in for Excel. Data Warehouse access is required before running reports, and the SAS Add-in and ODBC driver must be installed.

  1. Install the SAS Add-in for Excel.
  2. Open Excel.
  3. From the SAS ribbon, click Reports.
  4. Double-click the U of A Standardized Reports folder.
  5. Double-click the category folder that you need. 
  6. Select a report to open.
  7. Complete the pop-up form, and click Run.

When off campus, you must connect to the campus VPN to access Data Warehouse. 

Print Article

Details

Article ID: 134
Created
Thu 1/11/24 2:22 AM
Modified
Sun 2/25/24 9:48 PM

Related Articles (4)

Installing SAS Add-in for Excel to Use with Data Warehouse
Download and install the SAS Add-in for accessing Data Warehouse with Excel.
Installing SAS ODBC Driver to Use MS Access with Data Warehouse
The SAS driver for ODBC connects your computer to Data Warehouse reports when using MS Access.
Running Data Warehouse Reports in SAS EG
Run standardized Data Warehouse reports of historical BASIS data using SAS Enterprise Guide (EG).
Running Reports from Data Warehouse
Data Warehouse is a repository made up of over 270 tables of financial (purchasing, payroll, general ledger, etc.), academic (UAConnect) and historical BASIS data copied from live production systems at regular intervals where staff and faculty with appropriate access can run queries and reports of university data.