OBIEE – Navigation from one report to a different dashboard page without using value based interaction

Scenario – Your Overview dashboard page has a report, with a Description column. Based on the values in the description column, you need to navigate to different reports on the different dashboard pages. We need to drill through the same report to different reports on different dashboard pages.

Solution – HTML comes to rescue in this scenario. This change involves a small html code which needs to be used in the column description.

a. Consider a “Summary Report” report on Overview Page.
b. The report has a column called “KPI” with values as Inventory, Supplier_Scorecard and Sales
c. Depending upon the three values, we need to navigate to the Dashboard Page of Inventory Page, Supplier Scorecard Page and Sales Page which are already created.
d. In KPI column description, we can use ahref tag and navigate to the desired report on different dashboard page. Please refer to the Syntax section.
e. Change the Data Format for the “KPI” column to html.



Syntax –


where
/shared/folder_name/_Portal/dashboard_name: should be the path and name of your dashboard. &Page=page_name: should be the name of the dashboard page you want to navigate to. Value: should be what will be displayed in the KPI column value.

eg:


Note: I have used %20 if there is a space in between the words for the folder name, dashboard name or dashboard page name

Since here we have all the three values existing in the same table column, so we would need to use Case Statement.



Paste the above Case Statement in KPI column description in the criteria tab.

Advantages:
1. No usage of different guided navigation links for navigating to the different reports.