ABOUT BOBJ (WEBI)

[Subhasmit]

Hi All, 

We have created some Reports in BOBJ(WEBI). The reports are scheduled, after successfully refreshing the reports from yesterday it is giving the below error (The report is working fine for the view mode but for the latest instance it is giving the below error)

Earlier with the "In" function the report was working fine and giving the correct values for both view mode and the latest instance.

 But now with the "In" function the report is working fine for the view mode but for the latest instance it is giving the following error

Previously, in the "Created not confirmed Actual Difference" formula we have used "In"

But in the latest instance, if we changed the “IN” function in the formula to the “ForEach” function, then the report shows the correct values after the refresh.

Question 1- 
How is it possible that the report is running fine in view mode but giving an error in the latest instance mode? 

What should we do now ? 

Please help.

[nachtaktiv]

as described in the error message: Check the values of your data set

in() works differently than foreach(), so there may be some different/new rows with key values in your current data that can lead suddenly to a different result