WEEK_OF_YEAR in OBIEE11g always adds one additional week

Question

WEEK_OF_YEAR function always adds one additional week number in OBIEE11g.

When I evaluate the function WEEK_OF_YEAR(CURRENT_DATE) it provides the value as 17.

Ideally i should be 16.

Is there a local settings I can change to display the correct value.

Since we moved from OBIEE10g to OBIEE11g it is impacting all our existing reports.

Please note this is not due to start of the week parameter.

3218183 · Answer

This is one of the legacy system. We need to migrate it immediately.

For our new system we will definitely consider this suggestion.

I understand start of the week can be modified by using locale settings config file.

Any such configuration change can make this happen?

3218183 · Answer

Both the versions provide week numbers in the range of 1-53.

Actually this is nothing to with OBIEE10g to OBIEE11g.

What I see here is that it is not matching the ISO week number

Thomas Dodds · Answer

This is precisely why these types of attributes should be built into your Time dimension ... since you have to go and modify/update your reports, you might as well get a fully formed Time dimension and do it once.