I have migrated a BO4 universe to IDT (unx) and I have noticed that there are quite some differences in the report formula definition (between UNV and UNX universes). For instance: I have a detail object, employeetype (numeric) which is a detail from employee (character).
In Webi XI I’m allowed to create the following report variable:
=Sum(Revenue) where (employeetype = 1)
In Webi 4 however I need to change the formula to:
=Sum(Revenue) where (employeetype = "1")
The most annoying thing is that, when you try to change to source of the data provider to the UNX universe it returns the following error:
“the expression or sub-expression at position 103 in the ‘=’ function uses an invalid data type (IES 10037) (WIS10037)”.
It doesn’t tell you which formula is causing the issue. (Or even that a incorrect formula is causing the issue.)
I have a similar issue with a numeric dimension object, In XI you are allowed to use the sum function on this dimension object. In Webi 4 (when you use the UNX universe!) you have to first cast the object to an int/numeric (with the function ToNumeric())
Is there anyone who experienced similar issues?
Jurr (BOB member since 2011-08-24)