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!

Applying Prompt on Direct Database Request in OBIEE 11g

Sher Ullah BaigJul 7 2013 — edited Jul 10 2013

Hi

I am creating Analysis by using 'Direct Database Request' and i am executing SQL Query to direct Database i am NOT creating Business and Presentation Model in RPD. Now i have to apply Filters on Report. any idea how i can do that?

Example:

Prompt (filter) :   Year                 Employee Department

                          2011                    HR

                          2012                    IT

                          2013                    Finanical

Employee Name |    Employee Age   | Gender  | Leave Status     |    Leave Type

abc                            31                      male       on leave              Sick leave

xyz                             39                    Female    on leave               Annual leave

i want to filter by YEAR and Employee Department.

Regards

Baig
This post has been answered by SriniVEERAVALLI on Jul 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2013
Added on Jul 7 2013
#bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
10 comments
7,452 views