Duplications Causing Inflated Values for Metrics on APDB Dashboards

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.

QuickSight:
Uploaded Image
Oracle:
Uploaded Image
Example Class:
Uploaded ImageUploaded Image
Duplications in Redshift:
Uploaded Image
SELECT
    unification_id,
    count(*)
FROM
    "prod"."csdw"."wcs_csu_apdb_section_f"
    WHERE unification_id LIKE 'MB000~batchsc~AFTERCENSUS_APDB_2244~2244%'
    group by unification_id having count(*) > 1
    order by 1
    ;

Requested by: Michael Dorsch
Created by: Michael Dorsch on Wed 10/23/24 9:06 AM Pacific Daylight Time