Week Start day on OTBI

Diego Andres

Hello experts,

I created a simple Analysis from Time and Labor and i used the attribute Calendar Week Start Date, but i see that the week start day is Sunday, but for the custome the week start on Monday,

How can i change the week start day?

RVohra

Can you try Time.Calendar Week Start Date + 1 and see if it works for your customer?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27359/week-start-day-on-otbi

Hi @Diego Andres,

Welcome to the Oracle Analytics Community!

You can use function like TIMESTAMPADD to add duration with your existing date values. Please take a look into the following Oracle note which might be useful.

https://docs.oracle.com/en/cloud/saas/taleo-enterprise/22a/otbou/c-datetimefunctions.html#TIMESTAMPADD

Hope this help.

Thank you.