Hi
You can add a new role or updating existing records using XOG Operation.
incremental="true"
It will update rate matrix rows, if record present in input xml and Rate Matrix
it will be add a new rate matrix rows, if record present in input xml and and it doesn't available in Rate Matrix
it wont delete any records from Rate Matrix, if the corresponding rate matrix rows doesn't available in the input file
by default
incremental="false"
if incremental tag is false, it will be deleted the rate matrix rows if rate matrix records don't available in the input XML
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_matrix.xsd">
<Header action="write" externalSource="NIKU" objectType="matrix" version="15.5.1.240"/>
<matrices>
<matrix defaultCurrencyCode="EUR" incremental="true" name="Rate Matrix Update" type="Cost/Rate">
<columns>
<column name="inputTypeCode"/>
<column name="resource"/>
<column name="resourceRole"/>
<column name="resourceClass"/>
</columns>
<matrixRows>
<matrixRow actualCost="20" currencyCode="EUR" fromDate="1990-01-01" inputTypeCode="*" rate="20" resource="962203" resourceClass="*"
resourceRole="*" standardCost="20" toDate="2019-12-31"/>
<matrixRow actualCost="10" currencyCode="EUR" fromDate="1990-01-01" inputTypeCode="*" rate="10" resource="954296" resourceClass="*"
resourceRole="*" standardCost="10" toDate="2019-12-31"/>
</matrixRows>
</matrix>
</matrices>
</NikuDataBus>
Thanks
Senthil