Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Taleo OTBI Performance Tile Filter : How to get difference between 2 dates — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Taleo OTBI Performance Tile Filter : How to get difference between 2 dates

Accepted answer
30
Views
2
Comments
edited Jun 1, 2018 8:08AM in Reporting and Analytics Taleo Enterprise 2 comments

Summary

Taleo OTBI Performance Tile Filter : How to get difference between 2 dates

Content

Hi,

 

Currently, when I try to put a OTBI filter to get difference between 2 dates, it throws syntax error:

"

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. (HY000)

[nQSError: 43113] Message returned from OBIS. (HY000)

[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type. (HY000)

SQL Issued: SELECT "Submission CSW Status - Historical"."Historical Status Event Date"-"Requisition Dates"."First Fully Approved Date" FROM "Recruiting"

OK (Ignore Error)

"

 

I have put a 'New View' as a Performance Tile and in 'New Calculated Measure; , aggregation rule as 'Sum'.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!