OBIEE BI Mobile App Designer Installation

Christmas is out of the way, New Years resolutions made (and some broken - sigh).

I promised myself last year to take a look at the OBIEE Mobile App Designer module as soon as time permitted, and to cut a long story short, I made time.

What are the prerequisites for installation.

You must be running OBIEE 11.1.1.7.1, if you are not then you will need to patch up to this version:
1. If you are on versions below 11.1.1.6.* or less then patch to 11.1.1.7.0 first
2. Apply the patches 16556157 which is a collection of patches which you apply one after the other and the a required patch 16569379.
3. you are now in a position to apply patch 17220944 which is the BI Mobile App.

The first patch on to my 11.1.1.7.0 system was a hefty 2.5Gb download on Windows 64 and contained 8 patches and when we include the required patch managed to eat up a good couple of hours of my day to install.

Make sure you follow the readme documents, there's nothing surprising there, but pay attention and you should be fine.

The final step is to install the BI Mobile App (patch 17220944).

1. Stop the OBIEE components OPMN, Managed Server and then Admin Server.
2. Apply the patch using opatch apply (see your documentation for environment variable settings).

The following steps are to deploy and configure the Application and the surrounding security.

You will need to run the WebLogic Congiguration Assistant to deploy the OBI Mobile App Designer.

Start--> Oracle Weblogic--> Weblogic Server 11gR1--> Tools--> Configuration Wizard.
1. Select extend an existing domain.
2. Select a WebLogic Domain Directory (bifoundation_domain).
3. Select Extension Source (select Extend My domain using a template and select <mw_home>/Oracle_BI1/common/templates/applications/oracle.bimad_template_11.1.1.jar)
4. The next few screens do not apply and you can click through using Next to the Configuration Summary screen where you click Extend.
5. You are finished with the configuration Assistant and can close the wizard.

Now you will upgrade the security configuration.

1. start only the WebLogic Administration server, Not Managed server or OPNM. (<mw_home>\user_projects\domains\bifoundation_domain\bin\startweblogic.cmd)
2. Run the python WLST script to integrate with Oracle Fusion Middleware
cd <mw_home>/Oracle_BI1/install
now run
<mw_home>/Oracle_BI1/common/bin/wlst.cmd addMADCodeGrants.py t3://<yourservername>:7001 weblogic

Enable the Mobile App Designer from Presentation Services.

1. Edit the instanceconfig.xml file in (<mw_home>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1)
2. Add the <EnableMAD> element above the closing </ServerInstance> tag as follows
  <ServerInstance>
    .....
     <AdvancedReporting>
         <EnableMAD>true</EnableMAD>
    </AdvancedReporting>
  </ServerInstance>

Start the Managed Server and OPMN.

Set up the local App Library 

1. Create a folder in the Catalog to be the local Apps Library. Under Shared Folders create a folder called named "Apps Library".
2. Open the xmlp-server-config.xml file. It is located under <DOMAIN_HOME>/config/bipublisher/repository/Admin/Configuration.
3. Add the property "APPS_LIBRARY_FOLDER_LOCAL"and set the value to be the path to the folder you created in Step 1. For example: <property name="APPS_LIBRARY_FOLDER_LOCAL" value="/Apps Library"/>
4. Restart the bimad (BI Mobile App Designer) application.

You should now see the Mobile Application on the "Home" page and from the "New" dropdown menu. Recent changes to apps appear in the Others section under Recent Dashboards.

Let me know if you have any problems.