pfx-api:calculate, pfx:dmCalculate

This component is used to calculate values of derived columns in a Datamart table.

Attributes	Description	Required by Spring Bean	Required by pfx-api

Attributes	Description	Required by Spring Bean	Required by pfx-api
`id`	Name of the route for referencing into URI.	yes	not available
`typedId`	ID of the object from Pricefx that performs the calculation, usually a Data Load.	yes	yes
`targetName`	Name of the target Datamart or Data Source.	yes	yes
`objectType`	Defines the object type. In this case it is always DM.	not available	yes
`label`	Can be used instead of `typedId`.	not available	no

To get typedId, you need to display the typedId field in the grid. In Data Loads, right-click the table header, select Columns and check what Typed Id is selected.

Available from 1.1.15:

Code sample

<to uri="pfx-api:calculate?objectType=DM&amp;targetName=DM.ReadyTransactions&amp;typedId=3899.DMDL"/>
<to uri="pfx-api:calculate?objectType=DM&amp;targetName=DM.ReadyTransactions&amp;label=Transactions"/>

Deprecated from 1.1.15:

Code sample

pfx:dmCalculate id="calculateDM_ReadyTransaction_Enrichment" typedId="3899.DMDL" targetName="DM.ReadyTransactions"/>