Update Allocation by Period in bulk by hours not percentage

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Is there a XOG gel script or DB table that I can update allocation by period in bulk by hours not percentage?

Example: I want to change allocations for the month of April from 130 to 120 hours. 

Environment

Release : All Supported

Component : CA PPM RESOURCE MANAGEMENT

Resolution

The one option would be to calculate the percentage value of the hours you want to use, then add that value to the XOG file. The XOG file (prj_projects_alloc_act_etc_read.xml) uses percentages versus hours.

 A DB script would not be supported. 

While it is not possible via XOG, it is possible through the Modern UI and REST.

Here is an example REST call.  

However, it can be done via REST

https://servername/ppm/rest/v1/projects/5225591/teams/5515858
Request Method: PUT

{
  "_type": "tsv",
  "isFiscal": "false",
  "dataType": "numeric",
  "workEffortUnit": "hours",
  "segmentList": {
    "segments": [
      {
        "start": "2022-06-01T00:00:00",
        "finish": "2022-06-30T00:00:00",
        "value": "56"
      }
    ]
  }
}

Additional Information

See also: Change allocations for multiple team members in bulk