Enabling Navigation to a Web page in OBIEE 11g

From Oracle BI and passing contextual information from Oracle BI

· Build the following report: time hierarchy, Company, Revenue

· From revenue column click on column properties, select interaction tab, select primary interaction as "Action links" for value.

· Click on add action link(+), click on create new action select navigate to a web page.Enter the URL information as below. URL: http://www.google.co.in/serach?q=@{1}.

· Click on define parameters click on add parameters in the name leave it as 1, in prompt search, in value select value as column, select column as Company.

· Click on OK.

· Click on conditionally, add a filter on revenue operator as greater than value as 1000000, click on OK.

· Enter the link text as search in Google. Click on OK, Click on OK.

· Save the analysis, Click on results.

· Notice that only two records have revenue greater than 1000000, Click on revenue for "stock plus inc" and you can see an action link in double box search in Google, Click on that you will see following message:





· Click on execute, it directly goes to Google and searches on that particular value.

Practice with the following:

· When you are defining parameters explore options of fixed, hidden, optional by selecting that option and looking at output.





Create a web service Action:

· Invoking web service allow you to initiate target operations, functions, processes and work flows in external system.



· To create a new action, you perform the following steps: --> Create a new connection

--> Execute the new action.