Syensqo IS - Customer Support

Page tree

This report option will enable the PMO better track and report project progress of all running projects in their project portfolio.

Layout : Progress Report

Quickgrid : Progress Report

ticket : https://sbs-support.solvay.com/a/tickets/4053973

BRD https://docs.google.com/document/d/1cyRF39y8r1gfWK2dJ4oS0nXEaB_o938Xf-bopSP07yk/edit?usp=sharing
Mockup Progress report https://docs.google.com/spreadsheets/d/1xCADF0bmGh_z_0zBWteN_CFGx8QppkoQ9t5GsKfDrcI/edit?usp=sharing


View

Script executing custom view via API, See the Accolade API Reference for more information.

List of custom view used in progress report

  • CRV_Initiative_V3
  • CRV_RTCostUploadedOn
  • CRV_ProjectStatusHistory
  • CRV_ProjectKFDUpdate


Script

ProgressReport.js

List function

  1. bindEvent
    1. binding activities to event pageload/quickgridload
  2. setInitial
    1. set initial values or parameters
  3. addPrintbutton
    1. add print button into layout
  4. executeQueryCost
    1. get data of project cost from CRV_Initiative_V3 via API
    2. write cost data into quickgrid
  5. getRefCostLastUploaded
    1. get data of cost reference table, when the last uploaded from CRV_RTCostUploadedOn via API
  6. getProjectPhases
    1. get datd of project phases via API
  7. getStatusHistory
    1. get project status history (last 6 ) from CRV_ProjectStatusHistory via API
  8. executeQueryKFD
    1. get Key Financial Datasheet from CRV_ProjectKFDUpdate via API
  9. setKFDColor
    1. set color of KFD updated
  10. setKPIColor
    1. set color of Ontime KPI and Onbudget KPI
  11. setTableLine
    1. format table lines
  12. setProgressBar
    1. set progress bar, completion percentage of each phase
  13. PrintDiv
    1. Open report in new windows, including html, style-sheet and call print function.
  14. getStringDateShortMonth
    1. format date to MMM dd, yyyy - example Mar 18, 2020
  15. getStringDateFullMonth
    1. format date to MMMM dd, yyyy - example March 18, 2020

The best way to get IT support is to use the new Service One Platform.