Oracle BI Mobile App Designer - Version 2

  • 11th September 2014
  • Mobile
  • Anne Lavery

Oracle BI Mobile App Designer - Version 2

The long-awaited new version of Oracle Mobile App Designer has been released.  This is the first patch update from Oracle for Mobile App Designer, and it includes many new features and enhancements.  Throughout this blog, I will compare old with new where possible and highlight any new features that have been released.

Some interesting new features available with Version 2 include:

  • Map Visualisation
  • Custom Maps
  • Set of new functions with redesigned calculated fields

Other new features include components which have enhanced and improved functionality:

  • Redesigned authoring UI
  • Exploration template
  • Application level calculated fields
  • Filters

New Features and Enhancements

User Interface

The first major difference is the look and layout of the MAD interface. In the first release, the space available for development interface was restricted by the toolbar along the top.

In V2 this has been removed and instead the components can be accessed from the expandable button which has maximised the space for developing the app.  Alongside this, the save and preview functions have been placed in one location at the top of the App Designer.

From these expandable buttons developers can also add a new page, and while this core functionality was in the first release, the expandable button makes the user interface appear more simplistic and consistent.

Another redesign that improves the development experiences is the new location of the properties pane at the side of the screen - users have the option of hiding the pane or having it viewable when developing apps.

Calculated Field

In version 1 of MAD, calculated fields were created using the ‘Formula Editor’. In V2 this has been re-designed from the ground up to make the creation of custom calculated fields a lot more intuitive and simple, yet flexible with a set of newly introduced functions.  In the example below, I have created a field for the number of days from when an order was first placed to the current date.  According to your customer requirements, you can adjust this to close date of order; therefore you can view how long the order was open for.  Each calculated field you create can be saved and used within another page/component, whereas in V1 you had to setup your calculated field for each component.  Version 2 of Mobile App Designer has seen the introduction of new functions such as CASE logic, Date Related Calculations and Conversion Text, Math etc…

Multiple Filters

With version 1 we had to set up the filter for each component, yet with version 2, within the filters section we can create a number of saved filters and apply them to a certain cell or field within the app.  We can also have multiple filters in place, which couldn’t be done with V1.  Not only can you have filters placed on a text field or a numeric field, you can also apply another filter without the first filter taking precedent.

Users can drag and drop Filters or Calculated Fields to any component and assign filters from the newly re-designed property window.  Having the ability to save a number of Filters and Calculated Fields allows the user to apply these to different pages throughout the app.

Exploration Page

Another feature available with V2 is the ‘Exploration Page’.  This is only available when building a Tablet App.

Within an exploration page, you can drag and drop the data fields into the filter area.  Based on the data type, the data becomes either an expandable drop down option for text fields, or a slider bar for numeric data.


Another added bonus of the Exploration Page and to any type of page is the Sidebar feature.  This is so users can find point of interest information quickly without opening another page.  In the example screenshot, I have enabled this feature on the graph, so when the user selects data from the graph, the sidebar appears containing more information.

New Map Visualisation

New Map Visualisation has been included to help business users to easily visualise their data with maps and to interact on mobile devices, to zoom in and out, drill down and filter.

From the example below we have been able to set the longitude and latitude by using the fields from the data subject area.  User can choose to select the data they wish to filter down into.

Users can also customise the look of the markers and the way data is displayed on the map.  By selecting the field you wish to customise, you can edit this from within the properties pane.

New Custom Map

In version 2, as well as the pre-seeded map types (e.g. US states) Version 2 allows customers to add their own regions and maps by simply uploading their own geoJSON files for polygon boundaries.  Flexible custom keyword matching is also included as well as support for native interaction and filtering.  Users should then add their new custom map file to the configuration file.

From the example below, you can see ‘Peak Countries’ has been added to the list of types.


V1 of Mobile App Designer supported custom plug-ins to be added as new data visualization components.  In V2, the developers have added an SDK for easier development of custom plug-ins.  If you are to create your own custom plug-in, you will have to install Node.js.   The kit contains the plug-in javascript file, the development server, and sample data.  You can develop and test a plug-in from your desktop.  After you install the prerequisite software and set up your environment, you are ready to download the SDK with sample data. After you download the SDK you are ready to design you’re plug-in.

You can test your plug-in on your desktop before deploying to your environment.  Once the plug-in is created, it must be uploaded so it becomes available in the gallery.

Other Features

One problem I encountered during the first release was that each time I saved and previewed the app: the preview would reload the entire app. However, in V2 when I use the preview function it takes me to the page I have been editing. This is a simple feature but one I have found to be very useful.

Another theme has been added in V2:

An issue I have encountered when developing Apps for clients occurred when I had placed a graph component on a page then dragged a numeric field to display on the graph.  For example, if there were any Null values contained in the data then we would use a Line Graph for display, the line would create a space for that Null value then continue with Line graph data.

As a workaround I created a data model and created the tables and columns I wanted to use within the App.  I then applied a filter so that there were no Null values appearing in the data.  With version 2, this has been solved; instead we have a tick box which enables developers to prevent end users seeing Null values.

Another feature which has been included is the ability to search for an app within the Apps Library or within your Apps section.  This feature is very useful as there can be a large number of apps in the library and this functionality makes finding a particular app easier and faster.  Users also have the ability to share QR codes by copying and embedding these within web pages or blog posts.

In conclusion, after looking through and developing some apps myself, I have observed many beneficial enhancements in version 2 of mobile app designer.  When building and developing apps, the extra space for adding components within the main body is one of the main benefits for me; I am not constantly using the scroll bar to move through the page.  The additional features included with this upgrade, such as the exploration page, sidebar, and the extended drill down functionality improve the end user’s interactive experience.   Features such as multiple filters, and easier control of the appearance of nulls on tables and graphs really improves the developer experience too.  Therefore in my opinion this version has improved upon an already great tool.

Subscribe to our Newsletter

If you enjoyed this article why not get great insights straight to your inbox

Leave a comment