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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to get the value of multi-select in the Dashboard Prompt

island_manJul 29 2013 — edited Jul 29 2013

I have a multi-select prompt in the Dashboard Prompt,  what I want is,   how do I know that user has choose one value,

for examle,  for some reasons,  if user didn't choose any value,  then I will set one column in answer as "customer office" , if user choose one value, then the column in answer will be "customer name". 

any comments, thanks.

Comments

937325

Hi,

first define the presentation variable for the required column prompt. ex: PV

Then in report level set the filter for that column = @{PV}{customer office}. here u have to give default value as "customer office", so by default the report in dashboard will show customer office even though the user does not select any value from dashboard prompt.

Mark If Helpful/correct.

Thanks.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 26 2013
Added on Jul 29 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #prompt
1 comment
243 views