IT Connect

Information technology tools and resources at the UW

Quick Reference

Access
Before connecting to an EDW cube, you must have access to the EDW. Learn if you already have access or how to request it.
Help

  • When logging in, make sure you enter “netidyournetid” without the quotes and replacing yournetid with your UW NetID
  • Send questions to help@uw.edu

Understand cubes
Familiarize yourself with materials on the Analyze Data Using Cubes webpage


Connection Steps – Video

Check out the series of three videos to learn how to connect to and use the Research Data cubes. Read on for written instructions.

Connection Steps – Written

Note: These instructions use the Financial Activity cube as an example. The same basic steps apply to all Enterprise Data Warehouse (EDW) cubes.

  1. Open Excel with your UW NetID Credentials
    Note: Your permission to access the EDW is associated with your UW NetID. When you connect to the EDW through Excel or any other tool, you do so with your UW NetID username and password. Follow the instructions in the Basic Steps to Connect to Data and Reports section to learn how to use the RunAs command to open Excel with your UW NetID credentials.
  2. Open a new blank workbook in Excel
  3. Under the Data tab, select From Other Sources, then From Analysis Services
  4. In the Data Connection Wizard window,
    • Server name : cubes.uw.edu
    • Log on credentials
      • Use Windows Authentication if you log into your computer with your UW NetID credentials or if you used the RunAs command to open Excel
      • You may need to select the Use the following User Name and Password option when you connect and enter your own NetID and password as shown below.
      • Mac Virtual Windows Connection
      • When you connect through a Mac Virtual Windows connection, you will need to enter your own NetID and password as shown below.
  5. Select the database from the drop-down, then select the cube from the list in the list below the drop-down
  6. Enter your own File name, Description and Friendly Name, or keep the default. Select Finish to save this Office Database Connection (.odc file)
  7. Select OK to place the pivot table in the default location
  8. Select fields from the Pivot Table Field List panel on the right side, by clicking on the checkboxes in the upper portion of the panel, or by dragging them to the four lower boxes
  9. Sample results pictured below

Congratulations! You’re connected.

Note – You only need to perform the connection steps once per cube. Excel will save this connection in your Connection list and/or directly in your worksheet for your next visit. When opening a new workbook, select the existing connection under the Data tab, then Existing Connections.