We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

What is the best way to show all employees for a specific element even if they do not have it?

Received Response


I need to build a report showing all employees, but needs to show a specific element if the employee has it, and leave a blank if they don't

Content (required):

Show all employees that have london weighting, but also show all employees that don't.

Is there a simple way of showing everyone and then displaying the data to show whether they have this element or not?

Version (include the version you are using, if applicable):

OTBI - Oracle Business Intelligence

Code Snippet (add any code snippets that support your topic, if applicable):


Howdy, Stranger!

Log In

To view full details, sign in.


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