migrating from 5.1 to XI

building reports webintelligence
1

I have this line of code written in a cell in 5.1
" =<3 Mo Avg> Where(=“Spike”) "

as well as this line of code in another cell
" =Sum(<Selling UM Adjusted Qty Ordered(Query 3 with SDSrvLNE)>In Body) Where (=“Spike”) "

when I migrated to XI i used that exact same line of code
same data source same user everything but it isn’t coming up with the same number as it does in 5.1 which is clearly the correct answer.
I was wondering if maybe XI doesn’t support some part of that syntax and if so what part??

markamosch (BOB member since 2010-05-05)

2

Welcome to B:bob:B!

Which exact BO version do you use?

The thing is that the BO calculating engine was changed from, I think, version 5.1.3 to 5.1.4 (or 5.1.4 to 5.1.5?). So if you use an earlier BO version that it’s possible that what you experience is the result of this.

If that’s true then there should be somewhere on the internet a document that describes changes in the calculating engine. Would be worth of reading it.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Im using full client 5.1.4 and XI 3.1 versions of desktop intellegence

markamosch (BOB member since 2010-05-05)