Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 12 Next »

Technical Details

Current Release Version: 2022.0.2

Release Date: 

Report Location: PowerBI / Apps / SPS Projects

Security Roles: All SPS Users

Requested Features

Current Cycle

Release 2022.0.3 [May 2022]

Features to Complete

  • Not started

Features to Consider

  • Not started

Features Ready for Release

  • Not started

Previous Cycles

Release 2022.0.2 [April 2022]

  • 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'

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
  • No labels