OBIEE report should run based on the Prompt selection in the Dashboard

2844292

Hi Experts,

I have a requirement that is i have Dashboard , it has both Dashboard Prompts and Reports .Normally in the Dashboard Report runs for default Date period but i have a requirement that when ever user pick or user select some values from Prompt then only Report should run . If user won't select any value from the Dashboard prompt then Report should not be run the Dashboard . How can i over come with requirement ,please provide your suggestions to get it done .

Let me know whether this is possible or not ?

Please help me . Thank you for your help.

Kamna

Try This:

Got o Prompts -> Edit Analysis -> Select the Prompt, go to Edit -> Expand options and select "Require User Input". Click OK and SAVE the prompt. Run it and check

2844292

Thank you for the response .

still am not clear . here is i want , required user input mean that you have to select or provide some input to Prompt then this input value been prompted in the Results. this is what happen if i understand correctly .

Even though user doesn't provide the any prompt value or input values, any way report run by default . I want to restrict that report should not run unless user provide input values to the prompt .

Please clarify .

Kamna

Step 1: Create A new Condition on top of your analysis. The parameters defining your condition should be like XYZ Prompt values "is not null". Give a row count for the condition and save the condition.

Step 2: Go back to your Dashboard for which you have the requirement -If user won't select any value from the Dashboard prompt then Report should not be run the Dashboard

Edit this Dashboard and apply this condition on top of all the Sections available on your dashboard.

Try this, may fulfill your requirement..

2844292

Thank you will try .....can you elaborate Pls

Kamna

Check out:

https://docs.oracle.com/cd/E23943_01/bi.1111/e10544/conditions.htm#BIEUG1205

2844292

Thank you i tried and it worked ....i edited the dashboard and report condition i mentioned as rowcount(columnname)>0 or ROWCOUNT('Batch Control_Int_Period') ==0

Thank you so much for your help ..

Kamna

Welcome

Please mark the answer as correct