Service News Category: Enterprise Data Services

BI Portal Update: New Filters on Fiscal Year Income and Expense Summary

The Enterprise Reporting and Analytics team just released an update that combines two BI Portal Finance reports: Fiscal Year Income and Expense Summary by OrgCode and Funding Source Fiscal Year Income and Expense Summary by OrgCode and Function Into one report, now called Fiscal Year Income and Expense Summary Why Should You Care? If you…

How To: Finance Date Functions in EDW

Do you ever get tired of building complicated date logic in your EDW queries? The EDW now supports several finance date functions to help you simplify your queries! These functions help enterprise data users to easily convert calendar dates, months, and years to UW fiscal calendar objects. These functions are most helpful to SQL developers…

Financial Activity 2019 Cube Update: New Attributes on Finance Cube

Based on input from users, we just published updates to the Financial Activity Biennium 2019 cube (finance cube). We added several new attributes to the cube that make it easier to get the finance data you need to do your work. In addition to the cube changes, we also want you to know about some…

RPG Release: Student Groups on Satisfactory Progress Policy Report

Based on user feedback, the Report Prioritization Group just released an update to the report: Satisfactory Progress Policy List The report now allows you to filter down to specific SDB Student Groups! This helps users answer the question, “are any students in a group I care about currently or projected to be in danger of…

EDW Upgrade to SQL Server 2019 Complete

The EDW successfully upgraded our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019.  We believe you will experience minimal impact, however, if you do experience any issues, please reference our IT Connect article titled, “Preview available for upcoming EDW server upgrade” which contains a list of known issues. Reporting issues If you experience any issues you…

FWS v2 is now available in EVAL to support Financial Transformation efforts

Preparation for UW Finance Transformation The Enterprise Data Platform is working closely with our partners to ensure that our services are in place to support you in your efforts to prepare for UW Finance Transformation (UWFT). If you would like to better understand the current state of  the UWFT program, please review the resources provided…

Upcoming changes on EDW process dates for WorkerPosition-related views

Update on 2/12/2021: EDW team is going to deploy this change on Saturday February 27th to give room for our Payroll data processing to take place in the week of March 1st.  If you have any concerns with the 2/27 deployment, please let us know as soon as possible by emailing help@uw.edu with the subject: “EDW WorkerPosition Changes”….

RPG Release: Degree Info now on Class List Report

Based on user feedback, the Report Prioritization Group just released an update to the report: Class List By Curriculum Course Section. The report now includes student degree information. Background: Advisers requested the ability to see student “degree information” fields on the report. The report still allows you to filter down to a specific quarter and…

RPG Release: New Filter and Fields on Major Codes

The Report Prioritization Group (RPG) just released new changes to the BI Portal report Major Codes. Change Summary: Based on feedback from the Graduate School and RPG, we updated the Major Codes filters and columns in the following ways: Filter Updates We added a new filter “Degree Level” to the report: The new filter allows…

EDW Customer Survey: The Results Are In

If you participated in the EDW’s Customer Survey, thank you! Understanding how you use the EDW helps us improve our services and enhances our ability to support you now and in the future. Over One Million You queried the EDW over one million times from August 2019 to August 2020. By Popular Demand By far,…

« Previous Page Next Page »