Friday, April 8, 2016

Passing filters from OBIEE Dashboard Prompt to Endeca Information Discovery

Oracle Endeca can be seamlessly integrated with existing BIEE deployment.
In this example EID Orders application is embedded via iFrame within OBIEE dashboard and obeys to the OBIEE page prompt.


Step1:

Add dashboard prompt for the column which needs to be passed as a refinement to Endeca app.

Set Presentation Variable to the prompt value.



Step2:

In the dashboard section,
add “Text” object and write the iframe code as below ( Make appropriate changes to the parameters). 

Select “Contains HTML Markup”


<IFRAME id="_myframe" src="http://localhost:8001/eid/web/orders/sales" width="1350px" height="500px" scrolling="" frameborder="0"></IFRAME>
<script>
document.getElementById('_myframe').src = "http://" + location.hostname + ":8001/eid/web/ sales?deeplink=[{'orders-app': {'queryFunctions': [{'class': 'RefinementFilter','attributeKey': 'DimGeography_CountryRegionName','attributeValue': '@{country}{}'}]}}]";
</script>


@{country} is the presentation variable that was set in step 1

You are done with the configuration. The Iframe from the text box displays the embedded Endeca app. When the obiee dashboard prompt is selected, the value will be passed to the URL as a parameter which will be applied to the Endeca app

No comments: