Skip to Main Content
Forums

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!

SQL query as a filter in OBIEE

999127Mar 27 2013 — edited Mar 27 2013
i have a list of student_ID in one table ( lets say A) and its subset in another table( table B)
i want a filter such that only the student_ID in table A which are not in table B are selected.

i am selecting operator "not equal to/ is not in" of the student_id in table A and choosing SQL query option for adding the value.

select distinct student_id from DatabaseName.B

Its not working. Its giving error after a lot of minor tweaks.

Can you help how to resolve this
This post has been answered by SriniVEERAVALLI on Mar 27 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2013
Added on Mar 27 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
3 comments
1,594 views