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

How to schedule OTBI report to run on Monday to Friday where the days are incremented

Received Response
3
Views
1
Comments
User_FAWBO
User_FAWBO Rank 1 - Community Starter
edited Aug 13, 2024 5:04PM in Oracle Analytics Cloud and Server

I have an OTBI Report for order fill rate, I need to schedule this report to start to run on Monday to Friday. how do I add a date SQL which increments meaning if I run the report on Monday, it will only Monday data then on Tuesday's run it should have Monday and Tuesday's data? and start fresh on Monday again.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you look at functions there is one being the day number in the week: by using that you can write a logical expression dealing with what you want.