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
Error with report — 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

Error with report

Received Response
19
Views
10
Comments
edited May 16, 2017 6:42PM in Reporting and Analytics for Taleo Learn 10 comments

Summary

When I add a location table I lose over 100 enrollments

Content

I started by creating a report of future enrollments.  I have the following tables 

  1. LearnCenters
  2. Users
  3. enrollments
  4. Enrollments Progress
  5. ILT Session

When this report runs I get 2289 lines of data

When I add the Location table and join location to session I get 1692 lines of data.  I lose 101 enrollments.  I have double checked the session to make sure the sessions has a valid location and it does.  I have worked on this report for several hours and clearly cannot see where the difference is coming from and why the it is skipping over some of the enrollments.  Any help  would be appreciated.  I am including the export files for these two reports.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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