Clarity

I am being tasked to create a process to add allocations to a project but I am being given hours instead of percentages. Is there a way to add the allocations as hours instead of a percentage? Below is an example of the XML I am using to add a resource to a project with the allocations as a percentage. If it is possible, what would I need to change to add the allocation as hours? In this example I am adding the resource with 1 hour of time for each month.

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
 <Header action="write" externalSource="NIKU" objectType="project" version="14.3.0.298"/>
 <Projects>
  <Project name="Solution the Benefit Coding - Project-1" projectID="PR8163">
    <Resources>
       <Resource projectRoleID="hm_por_int_pel" resourceID="hm_por_int_pel" teamId="hm_por_int_pel">
        <AllocCurve>
         <Segment finish="2018-02-01T00:00:00" start="2018-01-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-03-01T00:00:00" start="2018-02-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-04-01T00:00:00" start="2018-03-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-05-01T00:00:00" start="2018-04-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-06-01T00:00:00" start="2018-05-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-07-01T17:00:00" start="2018-06-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-08-01T17:00:00" start="2018-07-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-09-01T17:00:00" start="2018-08-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-10-01T17:00:00" start="2018-09-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-11-01T17:00:00" start="2018-10-01T00:00:00" sum="0.0066"/>
         <Segment finish="2018-12-01T17:00:00" start="2018-11-01T00:00:00" sum="0.0066"/>
         <Segment finish="2019-01-01T17:00:00" start="2018-11-01T00:00:00" sum="0.0066"/>
        </AllocCurve>
        <CustomInformation>
         <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
        </CustomInformation>
        <SkillAssocs/>
      </Resource>
    </Resources>
  </Project>
 </Projects>
</NikuDataBus>

Same as the other threadproject team member allocation 

As per my knowledge, I do not think there is a way to do this. As an workaround you can calculate the percentage value of whatever Hours you want to add, and then input that result while doing the XOG. 

I had a feeling that this was the case and started exploring this option. The issue that I am have with this option is that I need to first determine the number of available hours for the month (need to exclude holidays and weekends) but I am not sure as to what tables I need to query to get this information. Can you provide some direction on how to determine the number of available hours for a given month?

You would get the the monthly allocations from the allocation slices.

But you will get to the problem that the available hours vary by the month

The slices are in PRJ_BLS_SLICES tables.

The slices for the user defined  daily availability the request ID is 1 and for the monthly it is 7.

There are also system/insta slices in  PRJ_BLB_SLICES_M_AVL and PRJ_BLB_SLICES_D_AVL

which have system defined sliced periods.

See

https://communities.ca.com/message/98940902?commentID=98940902#comment-98940902 

for more discussion