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

OBI - get Friday, Saturday, Sunday

Received Response
21
Views
4
Comments
User_0MQRB
User_0MQRB Rank 1 - Community Starter
edited August 2024 in Oracle Analytics Cloud and Server

Hi,


Struggling with formula to generate report for Friday, Saturday, Sunday weekdays in one go. Any tips?

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    What do you mean?

    Is a "report" a BI Publisher report or an analysis? What you mean by "generate"?

    If you add a filter and pick the 3 days of the week, it should do what you need...

  • User_0MQRB
    User_0MQRB Rank 1 - Community Starter

    Its analysis. Every monday i need it to automatically send me report with last Friday, Saturday and Sunday.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Create an analysis with the filter on the day of the week (there is a function returning that from a date), schedule it with an agent to be executed and delivered on Monday.

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru

    Adding to Gianni's answer:

    DayName("SomeDimension"."ThisIsADateField")

    Yields Mon, Tue, Wed,.... depending on your locale settings. Then put the filter Gianni mentioned to

    XYZ in ('Fri','Sat','Sun')