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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Incorrect drill-down results (action link to BI content) when using UNION in OTBI Analysis

I've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakouts. My summary is giving me the perfect results. One of the columns in my pivot tables is providing the perfect drill-down results. However, the other column is bringing back all the results, not just the ones that should be in that column. I've checked that all my prompted criteria is all correct. I've attached a screenshot of my summary analysis, and the XML:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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