Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Navigate between Requests based on UNION's... not working correctly

633313Jun 2 2009 — edited Aug 17 2011
Interesting problem with UNION type requests and navigating between them...wonder if this is a bug or just me doing something wrong...

I've created a request based on a union of two requests (combine with similar requests) and then "Navigate" to a second request (that is also a union of two requests). My second request has a column that "is prompted" based on the value passed from the first request (drill-down effect). But then I noticed that the prompted value is not passed to the WHERE clause of my second request. My second request are being displayed, the filter is just not applied correctly.

I played around a bit and noticed the following behavior:

a) UNION request Navigate to UNION request - does not work (my first example above)
b) Single request Navigate to UNION request passes values correctly
c) UNION request Navigate to Single request - does not work
d) Single request navigate to Single request works (obviously...)

Has anybody seen this behavior (or managed to be able to navigate between requests that are UNION's)?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details