Clarity PPM

Rate Matrix incremental update or add new rows

  • 1.  Rate Matrix incremental update or add new rows

    Posted 04-25-2019 12:42 PM

    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