EDW Payroll data will include NWH and UWP employees

As part of the Enterprise Data Warehouse’s support for the Northwest Hospital Integration effort, beginning with the next payroll, pay period Jan 1-15, the EDW payroll data will include the Northwest Hospital (NWH) and UW Physicians (UWP) employees who are all now UW employees as of the beginning of 2020. If you have any questions…

Test News

Testing 1.2.3.

RPG Release: New Current Student Information Report in BI Portal

The Report Prioritization Group released a new report to the BI Portal, Current Student Information. This report consolidates two previous reports: Current Student Information by Major and Current Student Information by Minor. Remember to update your bookmarks to point to the new report location. Report Summary: This report displays a population of students that have…

RPG Release: New Filters and Fields on Class List Report

Based on user feedback, the Report Prioritization Group just released several updates to the report Class List By Curriculum Course Section. Run the report to see for yourself! Change Summary: Based on user requests, we made several updates to functionality, including: Selected Qtr Class column: First, some context. When you select “Class” from the Columns…

Connecting Remotely in Inclement Weather

As the promise of snow flutters into the local forecast, we wanted to take a brief moment to remind our users how to remotely connect to their machines. In order to successfully connect remotely, the following requirements are necessary: Have administrator privileges on your computer Adjust power settings to ensure the computer is on and…

Column Change: EarnType in BudgetActivityDetail

The Change The length for column EarnType (description) in the BudgetActivityDetail table has been increased from a varchar(25) to a varchar(255). This change will occur in the following ODS tables: BudgetActivityDetail BudgetActivityDetail2Bien BudgetActivityDetailCurrentBiennium BudgetActivityDetailCurrentBienniumMinus1 BudgetActivityDetailCurrentBienniumMinus2 BudgetActivityDetailCurrentBienniumMinus3 BudgetActivityDetailCurrentBienniumMinus4 BudgetActivityDetailCurrentBienniumMinus5 BudgetActivityDetailCurrentBienniumMinus6 BudgetActivityDetailCurrentBienniumMinus7 How will this affect me? If you query the tables directly, you may be affected….

UWSDBDataStore Reorg on February 1, 2020

Hello, The student database (SDB) will go through a reorganization on February 1, 2020 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on Monday, February 3, 2020. (However, data on the new objects will be available as soon as the Data…

New Report: General Ledger Transactions by Month

Enterprise Reporting and Analytics has partnered with the DATAgroup in Financial Management to release a new report to the BI Portal: General Ledger Transactions by Month.  Report Summary: This report gives users who are responsible for auditing and reconciling GLs a way to see individual transaction data for a specific GL Account/Fund Code combination by…

Tableau Server Upgraded to Version 2019.4

We have completed the upgrade of the UW Tableau Public, Transitional, and Production servers to Version 2019.4.0. You can read about the new features in the latest version here: Tableau 2019.4 What You Need to Know: Latest Version: If you’re ever curious what is the latest server version, you can see for yourself. Follow the…

RPG Release: New Filters and Fields on Study Abroad Report

In July, we added the Study Abroad Students by Unit Report to the BI Portal. Following that release, we received feedback from many users on how to make the report better. Based on this user feedback, the Report Prioritization Group just released several updates to the report. Run the report to see for yourself: Study…

Next Page »