Cal State Monterey Bay - Campus Data Warehouse Updates

Update 10/28/2024 : This issue has been resolved. The updated Enrollment Fast Facts (Census) dashboard is now available in production. College Description, Degree, Group, and Major Long Description have replaced Academic Plan filter controls across all dashboard pages and are working as expected.

Update 10/28/2024 : The issue has been resolved. You will now find 2024 Fall data on the Admissions Funnel (Census) Overview dashboard in production.

Update 10/25/2024 : Campus Data Warehouse production is now available to users again.  If you notice any additional problems, please submit a problem ticket .

New feature available! Campus Data Warehouse users will now be able to see active alerts from the Campus Data Warehouse Updates blog directly within the Navigation and Help dashboard in Campus Data Warehouse. Reminder: You can add this dashboard to your favorites so that it is easy to find when you log in to Campus Data Warehouse 

Update 10/24/2024:  The problem has been resolved and the updated dashboards are now available to users in Campus Data  Warehouse production. You will now find the CSU Academic Plan Owner filter control contains the correct values and filters the dashboard as expected.

The Campus Data Warehouse team is aware of a problem in production where Academic Planning Database (APDB) dashboards display inflated values for the 2024 Fall census data due to duplication of values for some classes in the database. We are currently working on a solution. A resolution is estimated to be available by mid-November. In the meantime, you may use the APDB dashboard in our legacy data warehouse which remains available at  csumb.edu/datawarehouse . This issue is being worked on in ITSR# 23514725.   Ticket : 23514725   Date created : Wed 10/23/24 9:06 AM Pacific Daylight Time Service : Report a Problem / Computer Software/Application Problem Title: Fall 2024 Duplications Causing Inflated Values for Metrics on APDB Dashboards After the Fall 2024 (2244) APDB census load in AWS, we are seeing inflated metric values on the APDB Dashboards in QuickSight.  This appears to be caused by duplications in Redshift....

The Campus Data Warehouse has been loaded with APDB census data for the fall and summer of 2024.  Alert! We are working on a  problem where we are getting duplicate records that are causing some metric values to be inflated on the dashboards in QuickSight. In the meantime, you may use the APDB dashboard in our legacy data warehouse, which remains available at csumb.edu/datawarehouse. You may now find updated census data on the following dashboards: Overviews: APDB Overview Courses: Academic Planning Database (APDB) > APDB Section - Annualized FTES Academic Planning Database (APDB) > APDB Section - Avg Class Size and Credit Load Academic Planning Database (APDB) > APDB Section - Faculty Instruction Academic Planning Database (APDB) > APDB Section - Multilevel Crosstab Table Academic Planning Database (APDB) > APDB Section - Term FTES and SFR Academic Program Review: Student Faculty Ratio > State Sessions (APDB) Common Data Set I - Classes Note: This is the fi...

The Campus Data Warehouse has been loaded with ERS applicant and student census data for the fall and summer of 2024.  We are working on a problem where the dynamic default control values are not updating as intended. You may have to change the "Academic Year" and "Term" controls on the dashboards to view the updated data.  You may now find updated census data on the following dashboards: Overviews: Enrollment (Census) Overviews Admissions Funnel (Census) Overview (Note: we are working on a problem on this dashboard where several visuals are not updating to display the 2024 Fall data)  Enrollment: Enrollment (Census) > Terms Detail Enrollment (Census) > Academic Years Detail Term Enrollment Fast Facts > Enrollment Fast Facts (Census) Admissions: Admissions Funnel (Census Snapshots) > Admissions Funnel Detail Academic Program Review: Admissions Demographics Several Common Data Set and Chancellor's Office Reports dashboards. Note: This is the first r...

The Campus Data Warehouse team is aware of a problem with various ERS dashboards in production where the default control values are not updating to the most recent available data. We are currently working on a solution. A general resolution is estimated to be available by October 31, but some dashboards may need to be addressed on a case-by-case basis and could take longer. In the meantime, you may need to manually change the "Academic Year" and "Term" controls on the dashboards to view the updated data. This issue is being worked on in ITSR#23487825 and ITSR#23487606   Ticket : 23487606   Date created : Thu 10/17/24 9:10 AM Pacific Daylight Time Service : Report a Problem / Computer Software/Application Problem Update : Wynter Nichols assigned the "EDM-Campus Data Warehouse Team" group to this Incident on Thu 10/17/24 9:33 AM Pacific Daylight Time. Title: Default prompt values are not updating with ne...

We are experiencing ongoing issues with migrations of dashboards from the QuickSight stage to production environments in Campus Data Warehouse where some visualizations with conditional display rules or conditional formatting are breaking when migrating to production. This may result in the following scenarios: View selectors not working as expected or not displaying the selected objects Visuals seem to overlap on the dashboard Conditional color or symbol formatting based on metrics not working on the dashboard Not correct: Correct:  Errors appear on the dashboard after migration While we are doing our best to test and fix these problems after any migration to production, the complex interactive nature of our dashboards makes it difficult to test every scenario.  If you see any of these problems, please submit a Campus Data Warehouse problem ticket .