How to change the week definition to ISO-8601 (1st day of the week being a Monday) — Oracle Analytics

Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How to change the week definition to ISO-8601 (1st day of the week being a Monday)

Received Response
205
Views
1
Comments
Bert.Borst
Bert.Borst Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

In OTBI the week definition is using the American standard, Week = Sunday - Saturday.

But in Europe we do use ISO-8601. Week = Monday - Sunday.

Also week number itself can be different. ISO-8601 always has 7 days per week and this makes reporting per week consistent. American week at the end and beginning of the year can be fractional and hence the numbers per week will be much lower than in 7 day weeks.

How to change the OTBI-config so that week numbering will follow ISO-8601?

Answers

  • Ron van Wolferen
    Ron van Wolferen Rank 3 - Community Apprentice
    edited Feb 27, 2024 4:15PM

    for Strategy review:

    pls acknowledge the omission in functionality as discussed in this tread.

    Deloitte encounters this issue at multiple implementation projects where client has a requirement to report on ISO week level in OTBI reporting tooling

    rewriting physical SQL "to_char(<date>,'IW')" functionality to Logical SQL with all its limitations is no feasible way forward (particularly for less proficient business end-users creating reports from self service perspective)

    pls consider to have EVALUATE function enabled trough SR request

    ( Currently, OTBI will not allow for evaluate function to be leveraged ==> [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000) )

    as also requested in: https://community.oracle.com/products/oracleanalytics/discussion/18024/enable-evaluate-function-for-otbi-reporting

    or introduce a function "ISO_WEEK_OF_YEAR " alike existing "WEEK_OF_YEAR" (which gives the US week).

    ps. next to OTBI this also goes for the FDIP (FAW) tooling