Go to main content
1/16
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New in This Guide
New Features and Updates Release 12c (12.2.1)
1
Introduction
1.1
What Is Oracle BI Mobile App Designer?
1.2
What Data Can I Use?
1.3
How Do I Access the Oracle BI Mobile App Designer?
1.4
What is the Apps Library?
1.5
How Do I Access the Apps Library?
2
Creating Apps
2.1
Launch the Create App Wizard
2.2
Choose Your Device Type
2.3
Choose Your Data Source
2.4
Save Your App
3
Getting Started with the Designer Workspace
3.1
The Oracle BI Mobile App Designer Workspace
3.1.1
Setting Properties
3.2
Setting App Properties
3.2.1
Setting the App Color Theme
3.2.2
Adding a Cover Image
3.2.3
Limiting Data Rows to Return for Design and Preview
3.3
Adding and Editing Pages
3.3.1
Selecting a Page Template
3.3.2
Changing the Page Name
3.3.3
Changing Between Main Page and Subpage
3.3.4
Moving Pages
3.3.5
Copying Pages
3.3.6
Deleting Pages
4
Adding Pages
4.1
Cover Pages
4.1.1
Updating the Cover Page Background Image
4.2
Exploration Pages
4.2.1
Customizing Text Filters on the Exploration Page
4.2.1.1
Specify Default Values for Text Filters
4.2.1.2
Enable or Disable Search for Text Filters
4.2.1.3
Customize Selected Background Color and Font Weight
4.2.2
Setting the Operator and Values for Numeric Filters on the Exploration Page
4.3
Tile Pages
4.3.1
Creating a Tile Page
4.3.2
Adding a Subpage to a Tile Page
4.3.3
Customizing Tiles
4.3.3.1
Specify Number of Columns
4.3.3.2
Apply a Background Color
4.3.3.3
Apply Filters
4.3.3.4
Sort
4.3.3.5
Add Stoplight Formatting
4.3.3.6
Resize Tile Margins
4.4
Analytics Pages
4.4.1
Analytics Page: Worked Example
4.4.1.1
Create the Variables
4.4.1.2
Create the Calculated Fields and Filters to User on Your Analytics Page
4.4.1.3
Create the Analytics Page
4.4.1.4
Add Components
4.5
Adding Navigation Pages
4.5.1
Navigation Page for Tablet
4.5.1.1
Adding a Search Filter
4.5.2
Navigation Page for Phone
4.5.2.1
Adding a Search Filter
4.5.3
Stoplight Formatting for Navigation and Accordion Pages
4.5.3.1
Apply Formatting Based on Static Values
4.5.3.2
Apply Formatting Based on Percent Achievement
4.5.3.3
Apply Formatting Based on Percent Growth
4.5.3.4
Customizing the Colors
4.6
Adding Accordion Pages
4.6.1
Adding Stoplight Formatting to the Accordion Page
5
Designing Apps
5.1
Inserting Images
5.2
Inserting Frames
5.2.1
Adding a Border or Background Color
5.2.2
Inserting Additional Rows and Columns
5.2.3
Joining and Unjoining Cells
5.3
Inserting Tables
5.3.1
Customizing Tables
5.4
Inserting Pivot Tables
5.4.1
Inserting a Pivot Table
5.5
Inserting Stacked Tables
5.6
Inserting Charts
5.6.1
Inserting a Chart
5.6.2
Changing the Formula Applied to a Chart Measure Field
5.6.3
Sorting by an Alternative Field
5.6.4
Changing the Series Color in a Bar or Line Chart
5.6.5
Changing the Width and Style of the Lines in a Line Chart
5.6.6
Setting the Treatment for Null Values
5.7
Inserting Maps
5.7.1
Region Maps
5.7.2
Setting Region Map Properties
5.7.2.1
Setting the Initial Zoom Level and Map Center
5.7.2.2
Customizing the Base Map Display
5.7.2.3
Setting the Color Distribution of Circle or Area Markers
5.7.2.4
Setting the Size Distribution of Circle Markers
5.7.3
Geo Maps
5.7.4
Setting Geo Map Properties
5.7.4.1
Setting the Initial Zoom Level and Map Center
5.7.4.2
Enabling Display of Zoom Buttons and Legend
5.7.4.3
Setting the Color Distribution of Circles
5.7.4.4
Setting the Size Distribution of Circle Markers
5.8
Inserting Lists
5.8.1
Inserting a List
5.8.2
Customizing Lists
5.8.2.1
Enable Multiple Selection or Single Selection
5.8.2.2
Specify Default Values for the List
5.8.2.3
Change List Orientation
5.8.2.4
Customize Font and Background Styles
5.8.2.5
Specify List Sort Order and Sort by Field
5.9
Inserting Sliders
5.9.1
To Insert a Slider:
5.9.2
Customizing Sliders
5.10
Inserting Data Fields
5.10.1
Insert Data Fields
5.10.2
Display Data Fields Side-by-Side
5.11
Inserting Text or Rich Text
5.11.1
Display Text Items Side by Side
5.12
Calculated Fields
5.12.1
Adding Calculated Fields
5.12.2
Adding Calculated Fields to App Components
5.12.3
Editing Calculated Fields
5.13
Filtering Data
5.13.1
Creating Filters
5.13.2
Applying Filters
5.13.3
Editing Filters
5.14
Creating Variables
5.15
Customizing Background Images
5.15.1
Sizing the Background Image
5.16
Adding Sidebars
5.16.1
Inserting a Sidebar
5.16.2
Adjusting the Label Field Width
5.16.3
Customizing the Fields in the Sidebar
5.16.3.1
Group By a Data Field
5.16.3.2
Apply a Formula
5.16.3.3
Customize Data Formatting
5.16.3.4
Customize Labels, Fonts, and Background
6
Customizing Region Maps
6.1
What To Do When Your Data Does Not Match the Region Identifiers
6.2
Customizing Map Files to Map to Your Data
6.2.1
Create a Custom geoJSON File
6.2.2
Update the Map config file
6.3
Using the CASE Statement to Map Your Data to the Map Region Identifiers
6.3.1
Creating the Calculated Field
7
Previewing, Sharing, and Publishing Apps
7.1
Previewing Apps
7.1.1
Preview on Your Desktop
7.1.2
Preview on a Mobile Device
7.2
Sharing Apps
7.3
Embedding Apps
7.4
Publishing Apps to the Apps Library
8
Component Property Features
8.1
Working with Tables
8.1.1
Customizing Alternating Row Colors
8.1.2
Setting Table Options
8.1.2.1
Set the Number of Rows to Display
8.1.2.2
Filter Data Displayed in the Table
8.1.2.3
Show or Hide the Total Row
8.1.3
Customizing Column Headers
8.1.4
Customizing Table Data Display
8.1.4.1
Applying Conditional Formats to a Table Column
8.1.4.2
Managing Formats
8.1.4.3
Setting Table Data Formatting Options
8.1.4.4
Formatting Numeric Data Columns
8.1.4.5
Formatting Date Type Data Columns
8.1.4.6
Custom Data Formatting
8.1.4.7
Sorting
8.1.4.8
Removing a Sort Order
8.1.4.9
About Grouping
8.1.4.10
Apply Group Left
8.1.4.11
Applying Subtotals
8.1.5
Customizing Table Totals
8.1.5.1
Formatting Total Cell Data
8.1.5.2
Applying a Formula
8.1.6
Inserting Links to Table Column Data
8.2
Working with Pivot Tables
8.2.1
Customizing the Pivot Table
8.2.1.1
Applying Filters
8.2.1.2
Customizing the Display of Totals
8.2.2
Customizing Pivot Table Headers
8.2.3
Customizing Pivot Table Data
8.3
Adding Filters to Tiles, Charts, Tables, and Pivot Tables
8.4
Adding a Search Filter to Navigation and Accordion Lists
8.5
Adding Links
8.6
Features of Metric Fields
8.6.1
Apply Data Formatting
8.6.2
Apply Custom Data Formatting
8.6.3
Update the Formula
8.6.3.1
Predefined Formulas Available from the Menu
8.6.3.2
Applying Custom Formulas
8.6.4
Add Stoplight Formatting
8.7
Setting Borders
8.8
Setting Margins
8.9
Using the Color Picker
8.10
Custom Number and Date Formats
8.10.1
Supported Number Format Mask Definitions
8.10.2
Supported Date Format Mask Definitions
9
Configuring App Settings
9.1
Updating or Refreshing the Data Source
9.1.1
Add Multiple Subject Areas to a Data Source
9.1.2
Refresh Excel Data
9.1.3
Update or Switch a BI Publisher Data Model
9.2
Accessing App Settings
9.3
Configuring Parameters
9.3.1
Configure Parameters for a BI Subject Area Data Source
9.3.2
Configure Parameters for a BI Publisher Data Model Data Source
9.4
Using BI Repository Variables in Parameters
9.4.1
What Are BI Repository Variables?
9.4.2
Syntax for Referencing the Variable
9.4.3
Example
9.5
Setting App Caching Properties
9.5.1
Enable Data Caching
9.6
Adding Translations
9.6.1
What Is App Translation?
9.6.2
Downloading a Translation File
9.6.3
Translating the XLIFF File
9.6.4
Uploading the Translated File
10
Adding Custom Plugins
10.1
What Are BI Mobile App Designer Custom Plugins?
10.2
Setting Up Your Development Environment
10.2.1
Download and Install the Prerequisites
10.2.2
Download the SDK with Sample Data
10.2.3
Files Included in the SDK
10.3
Coding the Custom Plugin
10.3.1
Plugin Structure
10.3.2
Property Support
10.3.2.1
Predefined Properties
10.3.3
Fields Support
10.3.3.1
Defining the Data Fields
10.3.4
Formatting Data
10.3.4.1
Method Summary
10.3.4.2
Method Parameters
10.3.4.3
Method Signature
10.3.4.4
Method Usage
10.3.4.5
Alternative Usage
10.3.4.6
Java Masks Reference
10.3.5
JavaScript APIs That Can Be Used in Custom Plugins
10.3.5.1
handleClickEvent Method
10.3.5.2
getPixelValue Method
10.4
Accessing Data at Run Time
10.4.1
Accessing Data Stored in rows Array
10.4.2
Accessing Data Through a JavaScript Object
10.4.3
Including Images at Run-time
10.5
Testing Your Plugin
10.6
Preparing Your Plugin for Upload
10.7
Uploading to the Plugin Gallery
10.7.1
Accessing the Plugin Gallery
10.7.2
Uploading Plugins
10.7.3
Managing Plugins
11
Launching Apps Through the URL
11.1
Getting the Basic URL
11.1.1
Copying the URL from the Preview Page
11.1.2
Constructing the URL
11.2
Passing Parameters Through the URL
11.2.1
Passing parameters when your data source is a BI Publisher data model
11.2.2
Passing parameters when your data source is a BI Subject Area
A
Reference for Administrators
A.1
About the Apps Library
A.1.1
What Is the Apps Library?
A.1.2
What Happens When a User Subscribes to an App?
A.1.3
About Local and Remote Apps Libraries
A.2
Setting Up the Apps Library Locations
A.2.1
Setting Up a Local Apps Library
A.2.1.1
Create the Apps Library Folder in the Catalog
A.2.1.2
Set Up the Configuration File
A.2.2
Enabling Remote Connection to an Apps Library on Another Instance
A.3
Sharing Access to the Apps Library with App Consumers
A.4
Securing Apps in the Apps Library
A.5
Required Permissions to Use Oracle BI Mobile App Designer and Run Apps
A.6
Moving Apps Between Environments
A.7
Adding Custom Maps
A.8
Activating Metadata Startup Cache to Improve Performance
A.8.1
Configuring Metadata Cache on Startup
A.8.2
Clearing the Subject Area Metadata Cache
A.9
Configuring Single Sign-On
A.9.1
Setup Procedure for Oracle Access Manager
A.10
Enabling Oracle BI EE 10g-Style Initialization Block Security
A.11
Protecting Against Out of Memory Errors Using Memory Guard
A.11.1
What are the Memory Guard Settings?
A.11.1.1
Restricting Maximum Data Sizes for App Processing
A.11.1.2
Configuring Free Memory Threshold
A.11.2
Setting Memory Guard Properties
Scripting on this page enhances content navigation, but does not change the content in any way.