Mobile App designer
provides lot more control and flexibility over the
layout, allowing to create “executive information system”-type dashboards, or
ones focused on particular role or LOB. People can include images, text and custom
navigation features using Oracle BI Mobile App designer. It is supported
Android and other non-iOS devices, with no need for App Store downloads. Also,
there’s no need to get the mobile app signed or approved by corporate security,
as it’s a 100% thin-client, no-install application, with no data stored on the
device.
Below are the steps to be followed to install
and configure MAD into OBIEE11g.
- OBIEE 11.1.1.7.1 version is needed to apply MAD patch. If the version of is not 11.1.1.7.1 then download Patch 16556157 from My Oracle Support and apply the patch
- Ensure all OBIEE 11g services are down including Weblogic admin and managed server
- Next step is to Apply OBIEE 11.1.1.7.1 MLR Patch 17004920 (using OPatch Utility) which is also necessary to support MAD
- Download OBIEE Mobile App Designer patch 17220944 from My Oracle Support and apply the same using OPatch Utility
- To deploy the OBIEE Mobile App Designer (MAD) using Weblogic configuration:
a.
Go to Command prompt and Navigate to
<MW_HOME>\Oracle_BI1\common\bin\
b.
Run Config.bat file to start Weblogic configuration
tool
c.
select ‘Extend an existing WebLogic domain’ option and click Next
d.
Select the domain bifoundation_domain
e.
On the ‘Select Extension Source’ screen choose
Extend my domain using an existing extension template and set the template Location and click on
Next
Template Location: <MW_HOME>/Oracle_BI1/common/templates/applications/oracle.bimad_template_11.1.1.jar
f.
Configure the JDBC Component Schema
g.
Review the configuration summary and click on Extend
button
h.
Click Done upon successful configuration
i.
To update security configuration for using MAD
on OBIEE11g presentation services navigate to <MW_HOME>\Oracle_BI1\bifoundation\install
and run the following command:
<MW_HOME>\Oracle_BI1\common\bin\wlst.cmd addMADCodeGrants.py t3://<hostname>:7001
<weblogic username>
e.g. prod_mwhome/Oracle_BI1/common/bin/wlst.sh addMADCodeGrants.py
t3://myserver1:7001 weblogic
j.
Navigate to \instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
and open instanceconfig.xml file
k. Add the <EnableMAD> element to the file:
<ServerInstance>
…
….
<AdvancedReporting>
< EnableMAD >true
</ EnableMAD>
….
….
</AdvancedReporting>
</ServerInstance>
l.
Start Weblogic Admin & Managed servers and
then OBIEE11g services using OPMN
m.
On successful logic click on New and a new
application category will appear called ‘Mobile Application’. Under this the ‘Mobile
App’ module will be visible
n.
On the Catalog page select shared folder &
create a folder to create the apps library. Set the permission. App designers
that will be publishing apps to the folder must have Write permissions. App
consumers that will be viewing apps in the library must have Read permissions
o.
To register the folder in the catalog to act
as the Apps Library, add a property entry to the xmlp-server-config.xml configuration
file.
p.
Access to Mobile App designer apps is granted
through BIConsumer application role
q.
The first choice you’re prompted with after
selecting New > Mobile App, is to select the device type; either Phone or Tablet
r.
After saving the application to presentation services catalog it will
then present with a cover page with list of data items down the left side and
option to create new pages and application elements
s. With BI Publisher
templates, each pages created can have a grid-type layout, to which components
such as charts, tables, pivot tables and navigation items can be added
t. A new component
type introduced in this application is the Tile component, which takes a
grouping column, then displays a set of charts or other components grouped by
that column. As well as filtering data using Filter components, there’s also
what’s called the “Accordion” component – this lists out a set of column values
plus subtotals
