Add total in a chart using Calculated Items in OBIEE

How to add an additional category for the total to a graph in OBIEE?

Sometimes in the requirements you need to present a breakdown of values by categories and their total on one chart. In the example below this is done for horizontal bar graph, but it can be done for any graph using the Calculated Items feature.

OBIEE Chart Example Continue reading

Edit reports starting on Criteria tab in OBIEE

How to start editing a report on Criteria tab instead of Results tab?

By default the when you click on Edit report, you OBIEE Answers opens it on the Results tab. This triggers the report’s query execution and most of the time you want to go to the Criteria tab anyway. So it can save you some time if you change your account settings to navigate directly to the Criteria tab when editing. Continue reading

Display custom message in No Results view in OBIEE

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:

OBIEECustomNoResultsView

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.

Continue reading

Oracle Alta UI color palette

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 designOracleAltaUI1 Continue reading