Requested Features

Current Cycle

SQL-ONLY: Updated a2_ru_sps_usage_pbi procedure to merge Admissions Summary and Academic Programs with previous report names

Download the SPS Audit MS Excel file.
- Remove the first row from the SPS Audit MS Excel file.
Rename the fields name from (Report Name, Activity Date, User UNI, First Name, Last Name, Activity) to (Report_Name, Activity_Date, UNI, First_Name, Last_Name, Activity)
Save the file as 'SPS Audit'
Drop the table 'pbi_ru_sps_usage' (drop table [cereports].[dbo].[pbi_ru_sps_usage])
Import the 'SPS Audit' MS Excel file in the CEREPORTS database and create a table as pbi_ru_sps_usage