Resolved: Class Enrollment Dataset Shows No Data Before Academic Year 2014

Update 11/25/2025: 

The issue with terms prior to the 2014 Academic Year on dashboards built off of the Class Enrollment Dataset has been resolved in Campus Data Warehouse production. Grades, FSSD, and Course Enrollment Demographics should now show the historical data when selecting prior Academic Years on the dashboards.

Example from Course Enrollment Demographics > Trends showing historical data prior to 2014 Academic Year.

Example from Course Enrollment Demographics > Trends dashboard with most recent Academic Year 2013 selected and 15 prior years of Spring terms data visualized on the dashboard.


Original issue:

The dashboards built on the Class Enrollment Dataset in QuickSight are not displaying data before the 2014 Academic Year.  

This issue impacts all Grades dashboards, FSSD, Course Enrollment Demographics, etc. 

Both Stage and Production environments show the same behavior. 

Example of Course Grade Distributions dashboard showing only Academic Years back to 2014 available on the dashboard filter.

Identified issue as a filter in the SMSP code that needs to be changed to allow earlier Academic Years and Terms to appear.

Optimize Case: GC0007863