Hi,

We've upgraded one of our non-production MII environments from MII 12.0.2 (build 88) to 12.0.9 (build 23), and some of our dashboard apps are not working correctly.

One issue that I've tracked down sounds similar to this post: []

But is different. We have a BLS that has a local property (called Hold_qty) that acts as an accumulator of a QUANTITY value that is returned in multiple rows from the associated SQL query.

Under 12.0.2, Hold_qty is defined with data type String. There is a repeater, with an assignment that assigns Local.Hold_qty the value of Local.Hold_qty + Order_table.Output(/Row/QUANTITY). This worked fine on 12.0.2, as the String would be converted to integer automatically (with value 0), then would accumulate the QUANTITY values.

Now in 12.0.9 it is no longer working and the Hold_qty value is NA after the repeater is done. It seems that MII is no longer converting the string type to integer before attempting the addition, thus the addition is attempted with Hold_qty having string NULL value, instead of integer Zero value. Because it is null, then MII calculates the result to NA. The MII manual does state that "Calculations that include null values return a value of NA".

My question, is why did the precedence of type conversion vs. property evaluation change between the versions? Is this change documented somewhere? I didn't have very good luck finding a list of changes in all of the versions between 12.0.2 and 12.0.9. Can someone point out where I can find such a list? I searched SAP notes and it seems that only some of the SPs between 2 and 9 have Notes but not all of them.

I changed the data type of Local.Hold_qty to Integer in the BLS and now it works correctly on 12.0.9, but I'm still curious as to why the change, as using Strings instead of integers and allowing the type conversion was a recommended approach in at least one post in the past: []

Thank you and best regards!