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
Multiple Query BO report with Historical Tracking- Help to convert to OBI — 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

Multiple Query BO report with Historical Tracking- Help to convert to OBI

Received Response
30
Views
3
Comments
edited May 5, 2016 8:25PM in Reporting and Analytics Taleo Enterprise 3 comments

Summary

We have a number of reports which use the concept of a main query and then other queries to isolate status events from tracking history. I cannot seem to replicate this result in OBI.

Content

Requirement- Report filters on candidates who had an interviewed scheduled (based on step/status history) in the previous 7 days.

Then displays scheduled date (from above query) and other workflow dates based on separate queries. (e.g. to be scheduled date, user who moved the candidate to the to be scheduled date).

In OBI, if I filter on the main query of those scheduled in the previous 7 days, then I cannot apply case statements to get the other dates because I've filtered out the results already.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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