Exposing the Waterfall Output

Next, you expose the waterfall output on the user interface.

To expose the waterfall output as a drilldown on a field in the UI

  1. Create a new virtual business component based on class CSSBCVWaterfall.

    1. Create fields for each waterfall output column.

    2. Create a field called Name, which is used internally to query the correct data by the waterfall name.

    3. Compile the virtual business component.

  2. Create a new pop-up applet based on class CSSSWEFrameListPopupWaterfall using the VBC created in Step 1.

    1. Set its search specification to query the field Name with a value of the created waterfall, such as:

      Name = "Cost Waterfall"
      
    2. Define the column layout.

    3. Compile the applet.

  3. Create a drilldown link to the new pop-up applet in each list applet that displays the field calculated by the PSP procedure.

    1. Add a drilldown object to the applet defining the field on which the drilldown is displayed and the drilldown name. Leave all other fields blank.

      Example:

      Name = "Waterfall Popup 2"; Field = "Cost"
      
    2. Add a user property to the applet indicating which waterfall pop-up applet to display upon each drill-down:

      Example:

      Name = "Waterfall Popup Applet 2"; Value = "Cost Waterfall Popup List Applet"
      
      Note: Multiple waterfall drilldown links are supported by incrementing the index at the end of the Waterfall Popup Applet N drilldown name.

      Applet classes CSSSWEFrameListQuoteItemEC and CSSSWEFrameListWaterfall support waterfall drill-down.

      Note:

      CSSSWEFrameListWaterfall is derived from class CSSSWEFrameListBase directly.

    3. Compile the applet.