Does Where operator work different in DeskI and WebXI?

[system]

Hi all, i have tried to find documentation about my issue with no success
Here is the problem:
i have a report with a variable that use the “Where” operator.
In Desktop Intelligence (XI R2),
If i write the variable in this way:
Sum(<SellOutStdQty(SellOut_YTD)> Where (<MerchYear(SellOut_YTD)>=2008 ) )
it works!
If i write it as:
Sum(<SellOutStdQty(SellOut_YTD)> Where (<MerchYear(SellOut_YTD)>= ) )
it does not work! (in this case is equal to year(CurrentDate()) )
It returns “Syntax Error DMB0007” but I am not able to find documentation about DMB0007 error…

The weird thing is that the second espression works fine on WebIntelligence (XI version…)

Any suggestions?Does it exist a pdf document with the list of different behaviour between deski and webi functions and operators?

Thanks in advance
M.

---

bilux_team (BOB member since 2008-01-17)

[system]

mmmhhhh maybe here FAQ: Reporter there is a tip…if only the search function of this site do not stopp all words i use to search for my problems!!!

btw i do not understand why it works on webi…
thnaks

---

bilux_team (BOB member since 2008-01-17)

[system]

It is not the problem with Where it seems… but with the angle brackets you use in your formula…

In Web-I, you have to use square brackets…

for e.g. Use [SellOutStdQty(SellOut_YTD)] instead of <SellOutStdQty(SellOut_YTD)>

Also where accepts only constants to be compared…

So it is better always to use If() instead of Where.

Hope this would help you.

---

Jansi (BOB member since 2008-05-12)

[system]

Jansi, in WEBI (changing brackets of course) it works.
I do not understand why it works on webi but not in deski…
thanks
ciao

---

bilux_team (BOB member since 2008-01-17)