Skip to content

Introducing the New UW Summarized Cube!

March 19, 2025

The Reporting & Analytics team (R&A) and Finance DATAGroup have released the new UW Summarized Cube! This cube provides a multi-year view into actuals and budget1 data, summarized at the month level for fiscal year 2024 through the present.

What is a Cube?

A data cube is a powerful analysis tool, which allows users to quickly and easily slice and dice data across multiple dimensions, in a single view. For an introduction to cubes, including their benefits over traditional analysis tools such as reports, refer to the What is a Cube introductory video.

Note: If working remote, you’ll need to connect to the VPN to access the links on this page. For more information, refer to Husky OnNet.

How is the UW Summarized Cube different from the UW Finance Cube?

UW Finance Cube

The UW Finance Cube provides a detailed view of UW finances, by fiscal year, including revenue, expenses, and beginning balances. Users can analyze transactions at various levels using dimensions such as Ledger Account, Cost Center, Fund, Function, and more! However, because this cube drills-down to transaction-level detail, the dataset is large, so each cube is limited to one fiscal year for optimal performance. This cube does not include any budget data and it is refreshed daily.

UW Summarized Cube

The UW Summarized Cube provides a high-level view of UW finances by year, quarter, and month. Because it doesn’t have date-level transactions, users can analyze this summarized data across multiple years, using the same dimensions as the UW Finance Cube. Unlike the Finance Cube, this cube includes budget1 data and it is refreshed weekly, on Sundays.

How will the UW Summarized Cube help me?

  1. Summarized Financial Insights: View summarized financial data across multiple years and dimensions. Whether it’s analyzing trends in research expenditures, gift revenue, or procurement expenses, you can gain a holistic view of your financial landscape.
  2. Budget1 vs. Actuals Data: Compare budget1 data with actuals from Workday, broken down by year, quarter, and month.
  3. Preferred Analysis Tool: Connect to the cube via your preferred analysis tool (for example, Excel, Power BI, or Tableau) for seamless integration.
  4. User-Friendly Pivot Tables: If using Excel, connect to the cube and effortlessly create pivot tables by dropping prepopulated measures and dimensions into place.

How do I get started?

Refer to UW Finance Cube Resources – Workday Data to download the base workbook and get connected to the new cube!

Note: This page includes base workbooks for each cube in the suite of Finance Cubes, including one for the UW Summarized Cube.

Questions?

Please contact help@uw.edu with “UW Summarized Cube” in the subject line.

1 Budget data in this cube comes from Workday Adaptive Planning, which does not include grant budgets. Grant budgets are managed separately in SAGE and are not included in this cube.