Requested Features

Current Cycle

Release 2022.0.2 [April 2022]

Features to Complete

• Add the staff table and join with SPS Audit table and show the data by the Department. Filter (Andy, Bryon, Claire and Mohammed)
• Import the Report Usage data on 4/7
• Change the Report_Name from Applicant to Admissions Summary in pbi_ru_sps_usage table:

  UPDATE [cereports].[dbo].[pbi_ru_sps_usage]

  SET [Report_Name]='Admissions Summary'

  WHERE Report_Name='Applicant to Matriculant'

Features to Consider

• Not started

Features Ready for Release

• Update the data on pbi_ru_sps_usage table form the Report Usage data provided by CUIT on 4/7
• Change the Report_Name from Applicant to Admissions Summary in pbi_ru_sps_usage table:

  UPDATE [cereports].[dbo].[pbi_ru_sps_usage]

  SET [Report_Name]='Admissions Summary'

  WHERE Report_Name='Applicant to Matriculant'

Previous Cycles

Release 2022.0.1 [March 2022]

• 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