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.
Tagged:
0