When a prompt is added to a report in OBIEE, it will ask user to provide the prompt values when the report is opened. Report results will be filtered by the values chosen by user in prompts. After that, user can’t change the report’s filtering condition as the prompts are no longer visible. To solve this, we will add button with a link to take the user back to prompts.
How to add Go to Prompts button to the report?
Let’s add a Static Text view in report’s results page.
Inside the Static Text view check the Contains HTML Markup box and add the following HTML code:
<button onclick="window.location.href='saw.dll?PortalGo&Action=prompt&path=%2Fshared%2FReports%2FSales' ">Go to Prompts</button>
replacing the path= parameter with the path to the report starting with forward slash / (%2F in URL encoding).
Below the Static Text field you can see the preview of the button. Add the Static Text view to report’s Compound Layout.
Now the report displays ‘Go to Prompts’ button that takes user back to prompts.