Oracle BI Got MAD and You Should Be Happy

Oracle BI Got MAD and You Should Be Happy
Christian Screen & Jayant Sharma
RittmanMead BI Forum 2014
Abstract
• This session will explore several use cases for implementing Oracle BI mobile
in the enterprise, specifically via development of mobile applications using the
Oracle BI Mobile Application Designer (MAD). Attendees will learn how to
develop plug-ins for Oracle MAD using the new Plug-In SDK utilities. They will
gain an understanding, through examples of cutting-edge visualizations, and
location intelligence how integration of Oracle BI MAD objects within the Oracle
BI iOS application as well as the traditional OBIEE dashboards can be
accomplished. We will also look at the plumbing of this relatively new addition
to the Oracle BI Suite. At the end of session the audience should have learned
the end-to-end development life cycle and security implementations for Oracle
BI mobile in order to achieve mobile analytics coverage from C-Level
management all the way to the field users.
RittmanMead BI Forum 2014
Analytic Vision
• Analytic Vision is a Management Consulting Firm specializing in the
implementation of Oracle’s Enterprise Performance Management and Business
Intelligence Products
• Oracle’s EPM Suite | Hyperion Financial Management | Hyperion Planning | Hyperion
Strategic Finance | Essbase Analytics
• Oracle Business Intelligence Enterprise Edition (OBIEE) | Integration with Essbase
Analytics and Oracle EPM products
• OBIA pre-built applications over Oracle EBS, PeopleSoft, and JDE
• Data Warehouse design and development to fully support total solutions
• Founded in 2001, currently a team of 50 consultants
• Headquartered in Charlotte, NC
RittmanMead BI Forum 2014
Jayant Sharma
•
•
•
•
•
Decades of Product Development Experience
Oracle BI Development Team
Oracle MapViewer Development Team
Oracle MAD Developer Team
Oracle Speaker and Instructor
RittmanMead BI Forum 2014
Christian Screen
•
•
•
•
•
•
•
•
•
•
•
Oracle ACE
Oracle BI 11g Specialist
Oracle Deputy CTO & EPM/BI Counselor
Hyperion Essbase Certified Consultant
Co-Author of the 1st Book on Oracle BI 11g
13+ Years in BI/Data Warehousing
Open Source Software Contributor
Contributor at ArtOfBI.com
Creator of BITeamwork for Oracle BI
BI Practice Lead at Analytic Vision
Co-Founder Art of BI Software - BITeamwork
RittmanMead BI Forum 2014
@artofbi
Agenda
• Background on Oracle Analytics Mobility
• Mobile Application Designer (MAD) Overview
• Pre-Built MAD Applications
•
•
•
•
Demonstration (10 minutes)
Building a MAD Plug-In
Mobile Security
Demonstration and Wrap-Up
RittmanMead BI Forum 2014
Oracle BI Got MAD and You Should Be Happy
BACKGROUND
RittmanMead BI Forum 2014
Some Time Ago – Testing the Waters
• Oracle Indicators iOS Phone App
• Oracle BI Mobile 1st Release
RittmanMead BI Forum 2014
Mobile BI Challengers vs. Leaders
• MicroStrategy was killing this
market in 2011-12
• Oracle stepped-up their game
with a good iPad release in
2012-13.
• PC First vs. Mobile First
Development Strategies
RittmanMead BI Forum 2014
What Was Missing in Oracle BI Mobile
• Updates coordinated with the Oracle BI
platform
• Major mobile device release plan
• HTML5 graphing + charts
• Development Integration & SDK
Interoperability
• Enterprise Security for Mobile Device
Management
RittmanMead BI Forum 2014
Why HTML5 is “King” On Mobile
•
•
•
•
It’s flexible, and all devices can render the graphing
It’s dynamic and allows the most cutting-edge CSS/JS capabilities
It’s not Flash (Adobe Flash or Shockwave) file based
Required for cross-browser and cross-device compatibility
RittmanMead BI Forum 2014
Getting MAD
• Oracle BI Foundation Suite
• Oracle BI Trial Edition
• This is a bit different than what you
get from the OBIEE install
• Roll that “demo footage”
RittmanMead BI Forum 2014
Oracle BI Got MAD and You Should Be Happy
MOBILE APPLICATION
DESIGNER OVERVIEW
RittmanMead BI Forum 2014
New Wave of Oracle BI Mobile
• Separate tool and editor from
OBIEE, but it isn’t
• Different way of thinking about
consumption of mobile
analytics
• Brings in consideration of
purpose built applications vs
reuse of existing
dashboard/reports for
consumption
RittmanMead BI Forum 2014
Net New Development vs. Reuse
• Having the means to reuse work done in traditional OBIEE for mobile
consumption versus redeveloping new reports and mobile applications
in MAD for end-user consumption.
• This is not a valid concern anymore as MAD is an extension of OBIEE
and Oracle BI Mobility
MAD App
Oracle BI
Server
OBIEE Portal
Android App
iPad App
RittmanMead BI Forum 2014
Desktop/
Mobile
Browser
MAD Applications
• Stand-alone mobile applications based in HTML5
• Generally purpose built
RittmanMead BI Forum 2014
Purpose Built Applications
• Are generally purpose built for
a particular business need
• Think about industry verticals,
ex: healthcare, manufacturing
• Aren’t these just accelerators?
• Could this be an extension to
OOTB BI Applications?
RittmanMead BI Forum 2014
Purpose Built Applications +
• Per Business Unit
• Per Oracle BI Analytic
Application
• Could this be a new Business
Model for building Templates
for mobile BI platforms?
RittmanMead BI Forum 2014
MAD Editor
• New Editor, so something new to
learn and uses the concept of
“Pages” for navigation.
• Straightforward design and
development meant for power
users
• BIPublisher Architecture
• Oracle BI MAD Trial Edition is a
Desktop Install – Get It!
RittmanMead BI Forum 2014
Integrated with OBIEE Thru & Thru
• Yes, but no, not really - but it
is possible.
• Adding MAD Apps as
favorites or embedding in a
dashboard gets you there. Or
just search for it.
• Security is applied
seamlessly
• Native mobile browser is
always an option for MAD
RittmanMead BI Forum 2014
Integrated with OBIEE Thru & Thru +
• Embed MAD directly within
the OBIEE Portal.
RittmanMead BI Forum 2014
Revisit Understanding of Mobile First
• How about using all development technologies together
Third Party
Plug-In
MAD App
OBIEE Portal
Android App
iPad App
MDM Containers
RittmanMead BI Forum 2014
Desktop/
Mobile
Browser
Oracle BI Got MAD and You Should Be Happy
DEMONSTRATION A
RittmanMead BI Forum 2014
Easily Demonstrated Features of MAD
•
•
•
•
•
•
MapViewer Integration
Third-Party Calls as Services
Use of Plug-Ins
Integration with existing OBIEE Subject Areas
Integration with ad-hoc data sets via Excel (think BIP Data Models)
Visualizations
RittmanMead BI Forum 2014
Oracle BI Got MAD and You Should Be Happy
PLUG-IN TO MAD
RittmanMead BI Forum 2014
What’s In a MAD Plug-In
• An extension to the MAD editor.
• Essentially the output is data, or an object
available in one or more MAD pages
• It is JavaScript based (Not Java)
• An SDK is on its way
• These are reusable across implementations
and several open source examples exist
today
• Ultimately a way to integrate and extend
Oracle Mobile BI
RittmanMead BI Forum 2014
JavaScript is NOT Java!
• Think GruntJS, NodeJS, JSON, YEOMAN, etc.
• Not Eclipse, JAR files, JEE, etc.
RittmanMead BI Forum 2014
Some MAD Plug-In Examples
• MapViewer Integration
• Simple Logo
• YouTube Video
• Plug-In Location in OBIEE File Structure:
• /home/oracle/obiee/user_projects/domains/bifoundation_
domain/config/bipublisher/repository/Admin/Plugins/
RittmanMead BI Forum 2014
Oracle BI Got MAD and You Should Be Happy
MOBILE SECURITY &
PROVISIONING
RittmanMead BI Forum 2014
General & Native Security
• Encryption / Access
• SSL
• Single Sign-On (VPN)
• Lock Out (Device Management)
• Mobile Device Security Code Lock
• Mobile Device Management (MDM) Solution
• Privilege
• OBIEE Privilege to Disable Oracle BI Mobile Access
• Oracle BI Security Toolkit for Oracle BI Mobile
• MDM Containers
RittmanMead BI Forum 2014
BitzerMobile Acquisition & Forward
• Mobile Device Management – The
new MDM?
• Full Enterprise Mobile Security via
Containers
• IP rolled into Oracle Access
Management 11g R2
• Matt Milella of Oracle Product
Development has a good YouTube
video on how to implement Oracle
BI Security Toolkit
• Requires Xcode 5.x
RittmanMead BI Forum 2014
BitzerMobile Acquisition & Forward +
• Mobile Device
Management via
OAM 11gR2
RittmanMead BI Forum 2014
Set Up the Server Provision XML File
1. Create the shared web folder for /analyticsRes
or other deployment
2. Create XML structured file, save as
obim_configuration.xml for example and make
the file available in /analyticsRes location
3. Provide a link using Apple iPad protocol,
oraclebi://oraclebusinessintelligencemobile/con
figure?xml=http://server.my.company.com:700
1/obim_configuration.xml
4. Users then are linked to the Oracle BI Mobile
HD app with the connection information
provided. Passwords still need to be entered.
RittmanMead BI Forum 2014
Set Up the Server Provision XML File +
RittmanMead BI Forum 2014
Oracle BI Got MAD and You Should Be Happy
DEMONSTRATION B
RittmanMead BI Forum 2014
Oracle BI Got MAD and You Should Be Happy
WRAP-UP
RittmanMead BI Forum 2014
Key Takeaways
• MAD is here to stay and evolving with Oracle BI mobility.
• Plug-Ins are fairly easy to create but limited by creativity and
supporting documentation.
• The SDK should be amazing for us who like to innovate and extend.
• Incorporating BI MAD into Oracle BI mobile apps should be an
understood option when looking at BI Mobility in the organization
• Security should be a part of the plan for releasing mobility in BI. If not
using OAM use Air Watch or another MDM vendor.
• Start thinking about cloud services for MAD plug-ins and….
RittmanMead BI Forum 2014
…Go Build Something
RittmanMead BI Forum 2014
RittmanMead BI Forum 2014

Download Report