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

Question

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?

Ron van Wolferen · Answer

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