Equivalent “Next_Day” Oracle’s functionality in OBIEE

Standard

 

There is equivalent functionality in OBIEE, for Next_Day function in Oracle. 

          There is a question too in Oracle forums by me. And, excellent answer by mma1709 (Sorry to say this, as i don’t know his name and that is what there in forums too)

Here it’s…

TIMESTAMPADD(SQL_TSI_DAY, ( 7 – dayofweek(Time.ActualDate) + X ), Time.ActualDate) 

 

X = 1 will be sunday. If you want tuesday it will be 3. In that way, X will be replaced by the number depends on the next dayname you want.

Advertisements

About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

5 responses »

  1. Hi kishore,
    can u plze explain me in detail about next_day function in obiee. actually, i had tried bt i was unable to retrieve the data.so, plze explain me in detail if possible.

    • I want you break the code into detail functions.. then try with each piece..
      Now, you can understand..

      Let me know if you have any doubtz…

  2. Hi Kishore,

    I have read your posts on Oracle Forum. Great work!
    But in this case, why not just TIMESTAMPADD(SQL_TSI_DAY, 1, Time.ActualDate)?

    • Refer next_day function exactly on what it does.. It will just not retrieve next day. For given parameter of day it will give the next date. Read more about Next_day function in oracle

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s