How to change or remove the No Results message in OBIEE?
When the results of an analysis return no data, the following default message is displayed to users:
We can modify the No Results view, by adding custom message or more explanation on the use of report or hints on how to filter values. We can also change it’s visual formatting.
The colors of Oracle’s new user interface
Oracle announced Alta User Interface – a new design and set of guidelines for the developers for the latest Oracle applications (cloud-based products, Fusion Middleware and mobile applications) and the next Oracle products to come. Alta UI is created as a responisve, mobile-ready, flat and clean interface design Continue reading
How to remove bevels, spaces and box shadows from OBIEE Dashboard?
By default, dashboard sections are visually separated from each other using spaces, borders, bevels and box shadows. Also the default color of dashboard background is light blue. We may want to remove it to get a cleaner dashboard display.
How to hide a column or section from the dashboard display?
This workaround allows you to embed dashboard objects that are hidden from the view. Using this property you can hide Dashboard Column, Section or Alert Section objects. To hide particular reports or prompt you need to put them inside the hidden column or section.
We will need to use CSS formating to hide the dashboard elements. First, go to the top right corner of the column or section you want to hide and click on Format Section (or Format Column):
Click on Custom CSS Style Options (HTML Only) and check Use Custom CSS Style.
In the text box put:
The element with this property won’t be displayed on the dashboard. Note that this affects only the display of the dashboard, if you export the dashboard contents to a PDF the objects hidden with the CSS formatting will be visible.
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.