Oracle BI Mobile Application Designer (MAD)

Oracle introduced another great application called “Oracle BI Mobile App Designer (MAD)” in Release 11.1.1.7.1 of Oracle Business Intelligence Enterprise Edition (Oracle BI EE).

The Oracle BI Mobile App Designer (MAD) is a new design tool for business users to easily create stunning and interactive analytical applications for use on any major mobile device.  With Oracle BI Mobile, businesses have been able to deploy full interactive dashboards with no additional development using Oracle BI Mobile HD on iOS devices. Now, you can create purpose-built mobile analytic applications for any smartphones and tablets with drag-and-drop simplicity using Oracle BI Mobile App Designer. BI Mobile App Designer complements BI Mobile HD and is packaged with Oracle BI Foundation Suite and the BI Mobile option to OBIEE.  Some of the MAD highlights include:

Mobile-first Business Apps – BI Mobile App Designer is the ideal solution for users that want targeted, business-specific mobile apps that are easy and fast to build, require no programming expertise, and can be delivered to users across all the major mobile platforms and devices. Apps are built with support for touch and gestural interactions built in.

Intuitive App Design Interface – BI Mobile App Designer has a simple drag-and-drop interface that allows business users to select their data visualizations, including: tables, charts, navigation panels, repeating grids, images, text narrative, etc. These elements can then be dropped onto a palette to create mobile apps within minutes. Third-party plug-ins like Google Maps, Sunburst Visualizer, etc., can be incorporated and used in a similar manner. A preview function allows users to see their apps within a computer’s browser, or on a mobile device by scanning a QR code, without requiring any installation or configuration.

Portable Device, Platform, Screen-size Design  – BI Mobile App Designer is certified to support iOS, Android, and Windows Mobile Smartphones and Tablets. Since it supports HTML5, most mobile browsers can run BI Mobile App Designer apps. No plug-in, installation, or download from a third-party app store, is required.

Enterprise Integration – Oracle BI Mobile App Designer is a part of and is fully integrated with the Oracle BI Foundation. Users can create mobile apps with enterprise data from the BI Semantic Layer (RPD), with data from BI Publisher data models, or Excel data files with seamless support for, and the benefits of, role-based data-level security that the Oracle BI Foundation suite provides.

Drag and Drop – The easiest way to create UI is to drag and drop. MAD has beautifully incorporated this feature where one can build the entire BI Mobile Application just by dragging and dropping components and data fields as required.

Oracle Mobile Application Designer Drag n Drop

Interactive  – MAD is based on the “gestural” principal of touch and swipe. As most mobile apps use this technology for interaction, MAD has followed suit to adapt gesture interactivity for all the components in its libraries.

App Library – Users can share their new mobile apps across organizations using the publish feature. They can subscribe to these apps and receive updates when changes are being propagated to their subscribed apps.

Security – As MAD is integrated with Oracle BI Foundation Suite, the BI content has proven enterprise level security and performance capabilities.

HTML5 – The complete BI Mobile Application Designer output is generated in HTML5 including the data visualization charts. It can run on any platform device or operating system without any glitches. MAD follows the philosophy of “Build once, distribute anywhere.”

A sample Mobile App Designer Screen:

The result in iPad:

Other features include…

  • Supports drill down charts.
  • MAD comes with a separate filter component.
  • Multiple types of data visualization supported such as; Line, Bar, Area, Bubble, Pie, 3D graphs, Circular and Funnel.
  • Simple tables as well as complex pivot tables can be built.
  • Images can be added by uploading them, using the URL link, or inserting them from a database field.
  • MAD’s greatest strength is its repeater components! (ex: Tile and Accordion.)
  • Complex frame sets can be created by including frames for laying out the components to make them aesthetically appealing.
  • Choice of many Black and White themes.
  • MAD applications can be built using three types of data sources: subject area, data sources, and external excel files.
  • Drag and drop feature of the data fields from data source into the visual components.
  • Clean layout, perfectly aligned component sets and toolbars help in building complex dashboards using few clicks.

Limitations of MAD include…

  • Have to build support dashboards for Mobile and Tablet devices
  • Theme change effect is not being applied to all the properties of components (you can see the black text on chart labels in the black theme). These kinds of glitches can also be seen on the tables
  • Backspace does not work
  • Deleting a column from a table is not user friendly
  • Cannot add columns if there is no space

How do you get this?

  • BI Mobile App Designer is available now as a patch to Oracle Business Intelligence Suite Enterprise Edition, version 11.1.1.7.1. (patch number 17220944 at support.oracle.com)
  • BI Mobile App Designer is licensed at no extra charge with Oracle BI Foundation Suite and Oracle BI Mobile

eVerge Group is an Oracle Platinum Partner with extensive Oracle implementation experience in Oracle Business Intelligence. For more information about our business solutions, contact us at our website. http://www.evergegroup.com/contact.php

About the author: Garrett is Director of EPM Solutions who has worked with eVerge Group since 2005.

BI Success Checklist

It goes without saying that there are many reasons why BI implementations fail or succeed.  However, my experience over the years has taught me that some are more important than others.  My top ten are….

  1. Choose the right tools
  2. Obtain buy-in from stakeholders (business support is paramount)
  3. Agile implementations win
  4. Bring the right competence on-board (the right skill sets make a world of difference)
  5. Set goals, make plans and follow through
  6. Set up routines for data quality (your data is likely worse than you think)
  7. Set up and maintain meta-data (think re-usability)
  8. Do not forget about scale and performance
  9. Ensure organization is mature
  10. Make it last  –> BI is a journey

eVerge Group is an Oracle Platinum Partner with extensive Oracle implementation experience in Oracle Business Intelligence. For more information about our business solutions, contact us at our website. http://www.evergegroup.com/contact.php

About the author: Garrett is Director of EPM Solutions who has worked with eVerge Group since 2005.

Formulating and Executing a BI Strategy

A good BI Strategy has been and continues to be a hot topic.  How to start?  Where to start? Who and what do we focus on?  These are all valid questions and can go in many directions.  Having worked with many organizations, I’ve found that a good BI Strategy focuses on three primary aspects.

Faster

Today, companies get their financial and performance metrics in a number of ways. More than likely, it involves analysts in the organization combing existing excel spreadsheets and/or reports to aggregate the data to build a performance dashboard which is then circulated and elevated to the executive team. A good BI strategy starts with understanding these existing processes, and works to build solutions that expedite this process and enables ad hoc reporting.

A CFO should be able to open a BI tool, and ask whatever question they might have around their financial performance and get an accurate response within a certain level of detail (state vs city, product vs SKU, etc). If they have to wait a week and worry about accuracy, then it’s a key pain point to focus on during the faster aspect of the strategy.

Smarter

Beyond simply providing faster analysis within an organization, a good BI solution should make people smarter about their company by providing analysis and insights they couldn’t otherwise get on their own. As I mentioned in the previous section, organizations are getting reports today and know roughly how they’re doing (especially if they’re public) but having correlations between different silo’s of data can reveal things that executives may have not noticed before. This is a big reason for big data, but you can have very little data from different groups tied together in a single data warehouse and then leverage BI tools to help pull it together in a report, and get a great deal of value. A good BI strategy will focus not just on existing data, but new insights gained as well, from the BI activity.

Clearer

Getting good analysis, and smarter insights doesn’t guarantee that everyone has a single version of the truth and that they all understand what they’re seeing. Having a plan for how the data will be visualized, and ensuring the right controls are in place to validate the output is essential. Putting checks and balances in, so you can leverage tools like Oracle Business Intelligence to build new types of visualizations can make all the difference on transformation useful data to actionable data.

eVerge Group is an Oracle Platinum Partner with extensive Oracle implementation experience in Oracle Business Intelligence. For more information about our business solutions, contact us at our website. http://www.evergegroup.com/contact.php

About the author: Garrett is Director of EPM Solutions who has worked with eVerge Group since 2005.