PRB: Cumulative Sum Functoid Sums the Whole Document and Is Not Limited by Its Input Parameter (813616)



The information in this article applies to:

  • Microsoft BizTalk Server 2002

SYMPTOMS

When you use any of the Cumulative functoids in a map in BizTalk Server 2002, you may notice the following behavior:
  • You supply a second parameter to limit the scope of the functoid. However, the functoid still accumulates the values for the whole document and does not stop at the specified level.
The documentation that is included with BizTalk Server states that this second parameter limits the scope of the functoid:

This functoid requires two input parameters. The second parameter specifies the hierarchy level (from the standpoint of the compiler link) from the source node. This parameter should be an integer greater than 0 and less than the node depth from the root node.

CAUSE

The functoids are operating as designed. This is a documentation error with respect to the use of the functoids. In the current version of Microsoft BizTalk Server, you cannot limit the scope of the functoids by using the second input parameter.

WORKAROUND

To work around this issue, do one of the following:
  • Create a custom preprocessor to work with the data before you go to the map.

    -or-
  • Create a custom application integration component (AIC) to accumulate your data after processing.

    -or-
  • Use a double-pass method where you modify the data into multiple documents on the first pass, and then you submit each resultant document to do your cumulative operations on the second pass.

STATUS

This behavior is by design.

Modification Type:MajorLast Reviewed:2/12/2003
Keywords:kbprb KB813616