Skip to Content
author's profile photo Former Member
Former Member

BO report fetching incorrect data for working days this month

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.

Add comment
10|10000 characters needed characters exceeded

0 Answers