WEEK_OF_YEAR in OBIEE11g always adds one additional week — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

WEEK_OF_YEAR in OBIEE11g always adds one additional week

Received Response
51
Views
4
Comments
3218183
3218183 Rank 2 - Community Beginner

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.

Answers

  • handat
    handat Rank 5 - Community Champion

    I haven't used 10g version before, but what was the range of values it returned? Was it 0-52? In 11g, the range is from 1-53.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.

  • 3218183
    3218183 Rank 2 - Community Beginner

    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

  • 3218183
    3218183 Rank 2 - Community Beginner

    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?