Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

OBI EE SQL Query

Received Response
1
Views
3
Comments
298781ba-c6cc-410a-8310-f25351749235
298781ba-c6cc-410a-8310-f25351749235 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

I am looking at running a reoccurring agent daily reporting on Newly hired employees from the day before using OBI EE

When I add an sql filter:

"Submission Dates"."Hire Start Date" = TIMESTAMPADD(SQL_TSI_DAY, -1,
CURRENT_DATE)

The report Errors out

Is there a better sql filter I could use.

Also is there a way for the report to run no matter the result eg including a null result and therefore a blank report

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    298781ba-c6cc-410a-8310-f25351749235 wrote:"Submission Dates"."Hire Start Date" = TIMESTAMPADD(SQL_TSI_DAY, -1,
    CURRENT_DATE)The report Errors out

    The question is WHY does it error out? And HOW does it error out?

    What does the log file say? It's not normal that such a mundane filter throws an error!

  • Naeem Akhtar
    Naeem Akhtar Rank 3 - Community Apprentice

    The error could be due to mismatch in date format in the condition. other option could be to use variable holding yesterday date in filter. you can assign default value to variable as well in case of error.

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

    @298781ba-c6cc-410a-8310-f25351749235 Have you given up on this?