Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

To get week ending dates from week number in obiee report

Received Response
485
Views
25
Comments
13»

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Can you try the below formula,

    timestampadd(SQL_TSI_DAY,3*7,TIMESTAMPADD(SQL_TSI_DAY,-DAYOFWEEK(timestampadd(SQL_TSI_DAY,-DAYOFYEAR(CURRENT_DATE)+1,CURRENT_DATE))+1 ,timestampadd(SQL_TSI_DAY,-DAYOFYEAR(CURRENT_DATE)+1,CURRENT_DATE)))

    Pass the week number to the formula and check.

    pastedImage_0.png

    pastedImage_1.png

    pastedImage_2.png

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Dear Christian Berg,

    You have been one of the most helpful person in this forum(You are Gandalf the grey ).. I have got help from you several times in past few years. But many people here will not understand sarcasm or wit as english is not our mother toungue(but somehow we managed to learn a bit). So people who see your sarcasm could think it is an insult .

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Me? Wrong guy I guess :-D

  • Gianni Ceresa
    Gianni Ceresa Mod

    Christian sarcastic? Really? Him? Never ever ... we must be talking about another Christian

    Worth to have a look at https://www.youtube.com/watch?v=Gznq3_tDQy4 to get to know him a bit (but I find that one really simple on the sarcasm side, he can make lot better )

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Thanks Asim, appreciate it English isn't my mother tongue either so probably there is just quite some "lost in translation" bits without any of us being Scarlett Johansson. @Thomas Dodds could be mistaken from Bill Murray though if you blur his avatar a bit


    @Gianni Ceresa you just HAD to post that didn't you?