Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 2, 2013 11:30 AM by
Adding derived column in OBIEE Answers
Apr 2, 2013 12:31 AM
i have a student database with two tables school and activity club.
i want to display all students data with another column augmented in final dashboard.
This column has to be a Yes/No column. If student is present in Activity club then "yes" and on clicking the link "yes" it directs to Activity club table.
How to augment this derived column in OBIEE answers, so that i can provide it in dashboard.
This content has been marked as final.
Show 1 reply
Re: Adding derived column in OBIEE Answers
Apr 2, 2013 11:30 AM
in response to
Use case statement and add a drill down link on this field:
case when 'activity' is not null then 'Yes' else 'No' end