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)

Features to Consider

• Not started

Features Ready for Release

• None

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