Populating Child Waterfall Property Sets

When creating a new waterfall output, you first populate a child waterfall property set for each output row of the PSP procedure.

To populate a child waterfall property set for each output row of a PSP procedure

  1. Create new UMS message types to format text for your new waterfall output. See Creating Message Types.

  2. Define PSP actions to create the waterfall output in your PSP procedure.

    1. Use the {Row.Waterfall Name} += New() syntax to create a new waterfall record and append it to the desired waterfall property set. The New() function has the following syntax:

      New('Waterfall',  Name 1 =  Value 1,  Name 2 =  Value 2,.)
      

      Name n and Value n are the waterfall output field names and values; for example:

      Currency Code = USD
      
    2. Use the LookUpMessage function to format text in the appropriate language with variable values substituted through a call to the UMS business service, with the following syntax:

      LookUpMessage('Message Name',  Name 1 =  Value 1,  Name 2 =  Value 2,.)
      

      Name n and Value n are the payload field names and values that will be used by the UMS business service to construct the message text; for example:

      Price List = Americas Price List