Skip to Content
0

BO report fetching incorrect data for working days this month

Feb 14, 2017 at 09:31 AM

73

avatar image
Former Member

Hi Folks,

BO publication is fetching following two fields(BO variables) from Webi report:

following is the formula(logic) for both fields:

# of days:

# of days this month:

both fields were supposed to display following information when yesterday scheduled at 8 am CET:

# of days: 8, # of days this month:20

However field # of days this month populated with incorrect data 19.

yesterday after re-scheduling at regular interval, finally after 8 hours, data in both field populated as expected 8, 20. Webi report also displayed same.(11.30 PM IST13-Feb-2017). same values 8, 20 for both field for 12.30 AM IST, 14-Feb-2017).

I re-ran the publication today 14-feb-2017 at 8.45 AM IST and data was correct as expected, 9, 20.

surprisingly at 1.30 PM IST today 14-feb-2017, I checked the Webi report again, field

# of days this month populated with incorrect data,

# of days: 9, # of working days this month: 19

Automatic publication is scheduled at this time and it also populated with incorrect data as 9, 19 instead of 9, 20.

This issue reported is from DEC 2016, is it something due to DAY LIGHT SAVING? or I am not aware of.

Any help and suggestions are much appreciated in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers