This tutorial covers the basic features of the Oracle BI Mobile App Designer, introduced in Release 220.127.116.11.1+ of Oracle Business Intelligence Enterprise Edition (Oracle BI EE).
Time to Complete
Approximately 45 minutes
Oracle BI Mobile App Designer enables you to design purposeful apps for mobile phones and tablets from one of the following data sources:
- BI Subject Area
- BI Publisher Data Model
- Excel Spreadsheet
Hardware and Software Requirements
The following is a list of hardware and software requirements:
- Oracle BI EE 18.104.22.168.1 with 2 patches. See installation instructions in the Installation Guide.
- The default Sample App Lite repository should be available
- Optional: a tablet with a QR code scanner to preview applications on a mobile device
Creating Basic Mobile Apps
In this topic, you create a mobile app for tablet devices, based on the information in the Sample App Lite subject area in Oracle BI EE. To create a basic mobile app, you must sign in to Oracle BI EE and open the Mobile App Designer. You can explore the designer interface, modify the cover page, and add pages and content to your app. When you're done, you can preview your app on a PC or mobile device.
Starting the Oracle BI Mobile App Designer
Exploring the Mobile App Designer Interface
Modifying the Cover Page
As the first step to building your first app, you want to customize your cover page. Note: You are not required to have a cover page for your app.
Adding Pages to Your App
You can add pages to your app using either the provided layout options, or you can insert a blank page and design a custom layout. In the following steps, you add a page with a bar chart that shows revenue by quarter, a pie chart that shows revenue by organization, and a table that shows revenue detail by quarter, product type, and product.
Previewing Your App
Designing Apps with Tile Pages
Tile pages provide a scrollable grid of cells, each containing identical components that are repeated for a specific field in your data. You can use tile pages to provide an instant view of a key measure across a specific dimension. This view not only provides a complete picture within each cell, but also enables an at-a-glance comparison across the data set. You can further enhance the visual impact of the values represented in each cell by creating stoplight formatting to highlight cells whose results fall outside the range of specific threshold values.
In this topic, you learn how to create the following tile page, which shows a line chart of revenue over time, repeated for each product type. Spotlight formatting is enabled, which lets you instantly see which product types fall outside a specific range, when compared to target revenue.
Inserting Tile Pages
Formatting Tile Pages
Creating Subpages for Additional Detail
A subpage presents detail information of the main page to which it is associated. Typically you navigate to a subpage by tapping a data item on its main page (such as a repeating grid cell, or a chart value). The data presented on the subpage is automatically filtered based on the item you tapped on the main page. The subpage does not display in the app table of contents. When swiping sequentially through the pages of the app, the subpage displays with no filters applied.
These steps show you how to add the following subpage for the Product Revenue tile page. The detail page displays the Product Type name, a chart of revenue by product, and a detailed table with monthly product revenue and target revenue by office.
Note: A main page can have multiple subpages beneath it; however, only one level of hierarchy is supported; you cannot add a subpage to another subpage.
Creating Navigation Lists for Investigating Data
Navigation pages enable you to define a navigable set of filters that you can use to filter the data visualized on the page. The navigation area of the page contains a hierarchy of dimensions that you tap through to drive the display on the detail side of the page; you can see successively more refined sets of data, or navigate up and down the hierarchical filters to see the subset of data that interests you.
In this topic, you learn how to create the following navigation page, which enables you to navigate from a yearly revenue summary, to revenue for lines of business, and then to revenue for individual offices.
Inserting Navigation Pages
Creating the Navigation Hierarchy and Content
Formatting Navigation Hierarchies
Similar to tile pages, you can add Stoplight formatting to navigation hierarchies to highlight values conditionally, based on static threshold values, a comparison to a target value, or a comparison to another field. This section shows you how to add Stoplight formatting to revenue values, based on a comparison to target revenue.
Additionally, if levels in your navigation hierarchy have too many members to display on one page, you can add a data filter to the column. Data filters enable you to search for specific members in the column. This section also shows you how to add a data filter to the Office column.
In this tutorial, you have learned how to:
- Create basic mobile apps
- Design apps with tile pages
- Create navigation lists for investigating data
The following resources are available online for more information relating to the Mobile App Designer and Oracle BI EE:
- Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Mobile App Designer (PDF)
- To learn more about Oracle BI EE, search for additional OBEs in the Oracle Learning Library.
- Lead Curriculum Developer: Lisa Alexander
- Other Contributors: Kan Nishida and Kasturi Shekhar
To navigate this Oracle by Example tutorial, note the following:
- Hide Header Buttons:
- Click the title to hide the buttons in the header. To show the buttons again, click the title again.
- Topic List:
- Click a topic to navigate to that section.
- Expand All Topics:
- Click the button to show or hide the details for the sections. By default, all topics are collapsed.
- Hide All Images:
- Click the button to show or hide the screenshots. By default, all images are displayed.
- Click the button to print the content. The content that is currently displayed or hidden is printed.
To navigate to a particular section in this tutorial, select the topic from the list.