Friday, April 8, 2016

Display all RPD variables on a dashboard (UI)


This lists details of all repository variables within the current running BI Server metadata repository. BI Server query metadata procedures are used to gather this information on the fly.



Some configuration is needed to display all the RPD variables on UI. This feature is very helpful for developers as well as users to understand what variables to use while reporting. 

  1. “analyticsRes” is an application deployed in OBIEE where all the skins and styles reside.  The path looks like this, which may differ based on your installed location:        /app/oracle/biee/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes                                                                                                                                                                          
  2. Create the folder structure under analyticsRes as: /app/oracle/biee/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/CustomApp/customjs                                                                                           
  3. Under  ' customjs' folder create a file ' listRepVars.js’. Write the following code in the file and save the file with extension '.js':

OBIEE 11g Performance Monitor


OBIEE 11g performance monitor (perfmon) is available to use on the UI.

1) To invoke the utility, you simply need to add "?Perfmon" to the end of your standard URL for Oracle BI:
Or you can also use the embedded content on the dashboard as shown below:



2) Log in using the Admin user name & Password.


A screen will then appear with loads of statistics about concurrent and peak usage of your BI application. It lists all open sessions and details of logical requests. For example, there is info about active/current/peak presentation services sessions.



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,

OBIEE Drilling to Endeca Information Discovery


Passing parameters from OBIEE to Endeca Information Discovery can be achieved using Go URL:
Once the OBIEE criteria has been selected, go to the column properties from which you wanted to drilldown and click on Interaction tab.

Action Links  -->  Navigate to a Web Page

http://localhost:8001/eid/web/orders/new-page?deeplink=[ {'queryFunctions': [{'class': 'RefinementFilter','attributeKey': 'ORDER_ID','attributeValue': "@{P1}"}]}]

  •          “/orders/” is the target Endeca App;
  •          ORDER_ID is the corresponding attribute in the list of refinements