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: multiple filters return no results but when filters used individually returns records

Summary:

I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportunities together, i.e. "Priority Projects". The OOTB SAs are Sales - CRM Opportunity Note and Sales - CRM Opportunities and Products Real Time.

I am attempting to filter by the group initiative name = "Priority Projects" and want to pull in the last note updated for the opportunity. I referenced this article to get the last updated note (https://community.oracle.com/customerconnect/discussion/comment/488870#Comment_488870) and works BUT only if I have it as the filter in the report.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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