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
edited Dec 12, 2022 8:40AM in Taleo Learn 6 comments


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


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.


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