Cal State Monterey Bay - Campus Data Warehouse Updates

  Amazon QuickSight product issues: "Favorite" folders not remembered (Favoriting dashboards works) Excess whitespace surrounding visualizations Lacks CSUMB branding When switching to a new Group Breakdown Category, the last remaining group breakdown item lingers in the dropdown Sorting issues (metrics, multi-level, dashboard list) No drill-drown links natively No cell text formatting to indicate clickable (interactions) Legibility of data labels on charts No customization of tooltip precision Ad hoc filters not captured in share links No customization of feedback to user when no data found Share links do not open if you are not already logged in the QuickSight Click the OKTA link to "Campus Data Warehouse" prior to opening a share link   Data Warehouse model/data issues: "ION" Visa Permit Type category appears in QuickSight but not in Oracle dashboard improved logic matches source but not Oracle Glossary update needed Degree Composite > Degree Honors -...

  For the   July 31 Move to Production (MTP)   Preview, note the following: GlobalProtect VPN is not required to access QuickSight Oracle (OBIEE) remains available at  Campus Data Warehouse The following dashboards are not available in QuickSight yet (continue to use Oracle) Admissions Projections APDB Faculty Workload (APDB Section is available) Executive Overview Graduation Initiative 2025 UROC Annual Report WASC Retention and Graduation Retention and Graduation pages of other dashboards Common Data Set Grades (Subsequent Course Grades) IPEDS Daily snapshots have not been transferred from OBIEE to QuickSight Expected in mid-Fall Most of the documentation/training materials are still in development A draft  Quick Start Guide Links to an external site.  is available Vendor documentation for  QuickSight is here Campus QuickSight Documentation AWS Service Status Report issues in TDx Known Issues at Go Live

 Additional Dashboard Topic Labels Executive Overview Faculty Student Success Financial Aid Grades Graduation Initiative 2025 Overviews Retention and Graduation WASC

Dashboard Topic labels correspond with the folders within the Dashboards folder in QuickSight. Academic Program Review Admissions Chancellor's Office Reports Common Data Set Cost of Instruction Courses Credentials Degrees Enrollment Enrollment Planning

Depracated

The Campus Data Warehouse team is aware of issues with the Race 4 - American Indian category fields across all ERS-based dashboards in production. The issue may impact other race categories as well. We are currently working on troubleshooting.    Ticket : 22661543   Date created : Mon 5/13/24 3:43 PM Pacific Daylight Time Service : Report a Problem / Computer Software/Application Problem Update : Post to CDW Updates Title: RACE004 inconsistent between front-end & back-end Transferring Jira ticket for post MTP The assumed criteria may no longer work for new tribal codes.  This needs further investigation. May impact the other races as well.  Here's the RPD join  from W_SIA_TERM_D T377 /* Dim_W_SIA_TERM_D_Term */ , WC_CSU_RACE_DTL_D T1184 /* Dim_WC_CSU_RACE_DTL_D_RACE004_AMIND */ , WC_CSU_SCHOLAR_ACDMC_MD T744 /* Dim_WC_CSU_SCHOLAR_ACDMC_MD */ , WC_CSU_SNAPSHOT_D T688 /* Dim_WC_CSU_SNA...

 

The Campus Data Warehouse team is aware of problems across ERS dashboards where the new Speech Language Pathology Credential Category is not updating properly. We are currently troubleshooting the issue. This impacts both modernized and legacy data warehouses.    Ticket : 22232186   Date created : Thu 2/15/24 11:51 AM Pacific Standard Time Service : Report a Problem / Computer Software/Application Problem Update : Post to CDW updates Title: Missing new Speech Language Pathology Credential Category Across ERS dashboards, the relatively new Speech-Language Pathology program credential is not being reflected in the dashboards (impacts both Oracle and new QuickSight dashboards). We need to figure out why the existing Oracle dashboard did not update so that the logic can be updated and fixed in QuickSight as well. Speech Language Pathology, code: 912 Most records appear as "-" for Credential Waiver Group and "Not Applicable...