Resolved: ERS Student Dashboards - Visualization Problems fixed

Updated 12/11/2024:  

Visualization fixes are now available in Campus Data Warehouse production for the following ERS Student dashboards:  

  1. Shared folders > Dashboards > Chancellor's Office Reports > Enrollment Planning Report (EPR) > Enrollment Planning Report (EPR). 
    • Select FTEs metric selector fixed (corrected typo and error in logic so that correct data displays when changing metric). 
      • Uploaded ImageUploaded Image
  2. Shared folders > Dashboards > WASC > WASC. 
    • Annual Report. 
      • Fix the "Student Funding Type" filter to "Include" "Self Support" and "State Support" on Student Enrollment (new) and (old). 
        • Uploaded ImageUploaded Image
      • Fix the "Academic Plan Type" filter to "Include" "Certificate" and the "Academic Load" filter to "Exclude" "No Unit Load" on the "Certificates" table. 
        • Uploaded Image
      • On the "Programs by Modality" table, sort ascending on "College Description", filter "Program Delivery" to "Exclude" "Not Applicable", add the missing "WASC Modality" column to the table. 
        • Uploaded Image
    • Retention. 
      • Fix colors on First Generation graphs. 
        • Uploaded Image
    • Graduation. 
      • Fix colors on First Generation graphs. 
        • Uploaded Image


Original issue:

Ticket - 23412688 
Service - Report a Problem / Computer Software/Application Problem

Update - Changed Status from In Process to Completed.


Title - ERS Student Dashboards: Visualization Problems in PRD

The following visualization problems need to be fixed on ERS Student dashboards in QS PRD:
Shared Folders / Dashboards > 
Chancellor's Office ReportsEnrollment Planning Report (EPR)Enrollment Planning Report (EPR) CommentsBoth STG and PRD FTES - Student Level 2 - Annualized FTEs doesn't match OBIEE; also FTES - New Students 2-Annualized State FTEs wrong
EnrollmentEnrollment (Pre-Census Snapshots)Enrollment (Pre-Census Snapshots)Multilevel Crosstab TableCommentsStudent Funding Type filter is not working in STG or PRD 
*Note: this issue was resolved with SR23452078 and is already in production
WASC WASCAnnual ReportCommentsIn both STG and PRD data is wrong for 2023 compared to OBIEE because Student Funding Type filter is wrong in QS
Documented in the following Google Sheet: https://docs.google.com/spreadsheets/d/1MsbFTaKXiQ7CKcEv1BsXZ_-CzpYxULXoMd4jhUZAPyc/edit?usp=sharing

TSS-Help Desk, please assign to Michael Dorsch mdorsch@csumb.edu. 

Requested by - Michael Dorsch
Created by - Michael Dorsch on Tue 10/1/24 10:40 AM Pacific Daylight Time