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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

BI report omitting users

edited Dec 12, 2022 8:40AM in 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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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