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
BI report omitting users — 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

BI report omitting users

Received Response
21
Views
6
Comments
edited Sep 16, 2016 6:43PM in Reporting and Analytics for Taleo Learn 6 comments

Summary

Trying to run a BI report that shows all users regardless of other filters

Content

I'm trying to create a particular report, using BI Reporting, inside the LMS.  The report lets the runner specify a list of users.  It should return rows detailing each user, each course that user took for credit, and the credit value of each course.  I've attached a sample report with sensitive data omitted, and a screenshot of the data views and joins used in the report.

The problem I'm encountering is when the report runner tries to specify a timeframe, all users with no credits earned in that timeframe are omitted from the report.  I need all the users to still be listed.  Note that in the attached spreadsheet, the test user "blank_history_test" still appears on the report despite not having earned any credits.  Yet, if I filter for credits earned in 2016, none of the three users on the spreadsheet show up.  I want all three users to show up, but have the credit-related fields be blank.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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