Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Resources
  • Conventions
• 1 Get Started with Oracle Analytics Desktop
  • About Oracle Analytics Desktop
  • Get Started with Sample Workbook
• 2 Connect to Data Sources
  • About Data Sources
  • Manage Connections to Data Sources
    • Create a Connection to a Data Source
    • Edit a Data Source Connection
    • Delete a Data Source Connection
    • Database Connection Options
    • Share a Data Source Connection
    • Database Connection Limits
  • Create a Connection for an Oracle Database
  • Connect to Oracle Applications
    • Create an Oracle Applications Connection
    • Edit an Oracle Applications Connection
    • Delete an Oracle Applications Connection
  • Create a Connection to Oracle Essbase
  • Connect to Google BigQuery
  • Connect to Dropbox
  • Connect to Google Drive or Google Analytics
  • Create JDBC Connections
  • Create Generic ODBC Connections
  • Connect to Oracle Autonomous Data Warehouse
  • Connect to Oracle Autonomous Transaction Processing
  • Connect to Oracle Talent Acquisition Cloud
  • Connect to Snowflake Data Warehouse
  • Connect to NetSuite
• 3 Connect to Your Data Using Datasets
  • About Opening Datasets
  • What Are Datasets?
  • Typical Workflow to Create a Dataset from a Connection
  • Typical Workflow to Create a Dataset from a File
  • View Available Connections
  • Data Sources Available for Use in Datasets Containing Multiple Tables
  • About the Dataset Editor
  • Create a Dataset From a Connection
  • Add Multiple Connections to a Dataset
  • Use a SQL Statement to Create a Dataset Table
  • Understand Dataset Table Joins
  • Add Joins Between Dataset Tables
  • Disable Auto Joins in Datasets
  • Modify or Fix Joins in a Dataset
  • Add Joins When Table Columns Don't Match
  • Delete Joins from a Dataset
  • Include a Dataset Table in Data Source Queries
  • What is Preserve Grain?
  • Specify Which Table Determines Grain
  • Rearrange the Order of a Dataset's Tables
  • What are Quality Insights?
  • Explore Your Data Using Quality Insights
  • About Removing or Restoring Dataset Columns
  • Remove or Restore a Dataset Table's Columns
  • Apply a Filter to a Dataset Table
  • Specify Whether a Dataset Table Is Cached or Live
  • View a Dataset Table's Original Formatting
  • Create Datasets from Files
    • About Files for Datasets
    • Create a Dataset from a File Uploaded From Your Computer
    • Create a Dataset From a File Uploaded from Dropbox, Google Analytics, or Google Drive
  • Create a Dataset from an Oracle Application's Subject Area
  • Create a Dataset from an Oracle Application's Analysis
  • Create a Dataset from an Essbase Connection
• 4 Enrich and Transform Data
  • About Data Enrichment and Transformation in Oracle Analytics
  • Enrich and Transform Your Data
  • Accept Enrichment Recommendations
  • Transform Data Using Column Menu Options
  • Transform Data Using Replace
    • Example Replace Transforms Using Regular Expressions
  • Convert Text Columns to Date or Time Columns
  • Adjust the Display Format of a Date or Number Column
  • Create a Bin Column When You Prepare Data
  • Edit Column Properties
  • Hide or Delete a Column
  • Restore a Hidden or Deleted Column
  • Edit the Data Preparation Script
  • Add Columns to a Dataset
  • Enrich and Transform Reference
    • Transform Recommendation Reference
    • Data Profiles and Semantic Recommendations
      • Semantic Type Categories
      • Semantic Type Recommendations
      • Recognized Pattern-Based Semantic Types
      • Reference-Based Semantic Types
      • Recommended Enrichments
      • Required Thresholds
      • Custom Knowledge Recommendations
    • General Custom Format Strings
• 5 Curate Your Data Using Data Flows
  • About Data Flows
    • Working in the Data Flow Editor
  • Prepare Data by Running Data Flows
  • Create a Data Flow
  • Run a Data Flow
  • Run a Saved Data Flow
  • Reuse a Data Flow
  • Configure Incremental Processing in a Data Flow
  • Modify Parameter Prompts When You Run a Data Flow
  • Customize the Names and Descriptions of Data Flow Steps
  • Create a Sequence of Data Flows
  • Manage Your Data Flows
  • Data Flow Steps Reference
    • Add Columns in a Data Flow
    • Add Data in a Data Flow
    • Add Aggregates to a Data Flow
    • Add a Sentiment Analysis to a Data Flow
    • Create a Bin Column in a Data Flow
    • Create Multiple Pipelines in a Data Flow Using a Branch
    • Create and Customize an Essbase Cube in a Data Flow
      • Cut, Paste, and Skip Rules
      • Designation Change Rules for Generation Columns
    • Add Cumulative Values to a Data Flow
    • Add Database Analytics to a Data Flow
      • Database Analytics Functions
    • Filter Your Data in a Data Flow
    • Add Graph Analytics to a Data Flow
      • Graph Analytics Functions
    • Create a Group in a Data Flow
    • Add a Join in a Data Flow
    • Merge Columns in a Data Flow
    • Rename Columns in a Data Flow
    • Save Output Data from a Data Flow
    • Save Model
    • Select Columns to Include in a Data Flow
    • Split Columns in a Data Flow
    • Add a Time Series Forecast to a Data Flow
    • Train a Binary Classifier Model in a Data Flow
    • Train a Clustering Model in a Data Flow
    • Train a Multi-Classifier Model in a Data Flow
    • Train a Numeric Prediction Model in a Data Flow
    • Transform Data in a Data Flow
    • Merge Rows in a Data Flow
• 6 Manage Datasets
  • Dataset Type Icons
  • View a List of Datasets and Information About Them
  • Reload a Dataset's Data
    • About Reloading a Dataset's Data
    • Reload an Individual Table in a Dataset
    • Reload a Dataset's File
  • Inspect a Dataset's Properties
  • Rename a Dataset and Change Its Description
  • Copy a Dataset's Object ID
  • View a Dataset's Data Elements
  • Download a Dataset
  • Duplicate a Dataset
  • Delete a Dataset
• 7 Visualize and Analyze Data
  • Begin to Build a Workbook and Create Visualizations
  • Work with a Workbook's Datasets
    • Add Datasets to a Workbook
    • Replace a Dataset in a Workbook
    • Remove a Dataset from a Workbook
    • Modify a Workbook's Datasets
    • Blend Datasets
      • Understand Blending
      • About Mismatched Values in Blended Data
      • Blend Datasets
      • Change Data Blending in a Visualization
  • Build a Visualization by Adding Data from the Data Panel
    • Different Methods to Add Data
    • Automatically Create the Best Visualization
    • Use the Grammar Panel to Add Data to the Visualization
    • Use the Assignment Panel to Add Data to the Visualization
    • Modify a Visualization's Tooltips
  • Enhance Data in Visualizations with Advanced Analytics Functions
    • About Advanced Analytics Functions
    • Add Advanced Analytics Functions to Visualizations
    • Add Reference Lines to Visualizations
  • Use Spark Charts to Examine Trends
  • Create Calculated Data Elements in a Workbook
  • Sort Data in Visualizations
  • Undo and Redo Edits
  • About Refreshing a Workbook's Data
  • Refresh a Workbook's Data
  • Pause Data Queries in a Workbook
  • Work with Canvas Properties
    • Update Canvas Properties
    • About Canvas Data Refresh Properties
    • About Canvas Layout Properties
    • About Synchronizing Visualizations in a Canvas
  • Copy and Paste a Visualization or Canvas
  • Copy and Paste a Visualization's Data
  • Work with Multiple Visualizations on a Canvas
    • Update Common Properties for Multiple Visualizations on a Canvas
    • Copy and Paste Multiple Visualizations on a Canvas
    • Delete Multiple Visualizations on a Canvas
  • Change Visualization Types
  • Adjust Visualization Properties
    • Visualize Properties
  • Highlight Important Data Events with Conditional Formatting
    • What Can I Do With Conditional Formatting?
    • Apply Conditional Formatting to a Visualization
    • Example - Compare a Measure to a Set of Thresholds
    • Example - Compare a Measure to a Target or Goal
    • Example - Compare a Measure to a Complex Expression Value
    • Example - Compare a Measure to a Percentage of a Value
  • Apply Color to Visualizations
    • About Color Assignments in Visualizations
    • Access Color Options
    • Change the Color Palette
    • Assign Colors to Columns
  • Format Numeric Values of Columns
  • Set Currency Symbols for Visualizations
  • Add Notes to Visualizations
    • Add Notes to a Visualization
    • Connect a Note to Data Points in a Visualization
    • Show or Hide a Note's Data Point Connectors
    • Delete a Note's Data Connectors
    • Show or Hide a Visualization's Notes
  • Format Numeric Values of Visualizations
  • Apply Map Backgrounds and Map Layers to Enhance Visualizations
    • About Map Backgrounds
    • Enhance Visualizations with Map Backgrounds
    • Use Different Map Backgrounds in a Workbook
    • Interpret Data Values with Color and Size in Map Visualizations
    • Add Custom Map Layers
    • Update Custom Map Layers
    • Apply Multiple Data Layers to a Single Map Visualization
    • Use an Image as a Map Background and Draw Map Layer Shapes on the Image
      • Upload an Image as a Map Background
      • Draw Custom Map Layer Shapes on an Uploaded Image
      • Associate a Dataset with Map Layer Shapes Drawn on an Uploaded Image
    • Assign a Map Layer to a Data Column
    • Auto Focus on Data for a Map Visualization
    • Review Location Matches for a Map Visualization
    • Create Heatmap Layers on a Map Visualization
    • Create Cluster Layers on a Map Visualization
    • Represent Point Data With Custom Icons on a Map
    • Select Points or Area on a Map
    • Represent Line Data Using Size and Color on a Map
    • Make Map Layers and Backgrounds Available to Users
    • Use a Map Background as the Default
    • Add Map Backgrounds
      • Add Google Map Backgrounds
      • Add Baidu Map Backgrounds
      • Add Web Map Service (WMS) Backgrounds
      • Add Tiled Web Map (XYZ) Backgrounds
      • Web Map Background Troubleshooting Tips
  • Sort, Drill, and Select Data in Visualizations
  • Replace a Dataset in a Workbook
  • Remove a Dataset from a Workbook
  • Analyze Data with Explain
    • What is Explain?
    • What Are Insights?
    • Use Explain to Discover Data Insights
  • About Warnings for Data Issues in Visualizations
• 8 Create and Apply Filters
  • About Filters and Filter Types
  • How Datasets Interact with Filters
  • How the Number of Datasets Affects Filters
  • About Automatically Applied Filters
  • Create Filters on a Workbook
  • Create Filters on a Visualization
  • Create On-Canvas Filters
  • Change the Scope of Filters Between the Main Filter Bar and Visualizations
  • Use a Visualization as a Filter
  • Move Filter Panels
  • Apply Different Filter Types
    • Apply Range Filters
    • Apply Top Bottom N Filters
    • Apply List Filters
    • Apply Date Range Filters
    • Apply Relative Time Filters
    • Apply Expression Filters
• 9 Use Other Functions to Visualize Data
  • Build Stories
    • Capture Insights
    • Create a Story
    • View a Story in Present Mode
  • Identify Content with Tooltips
  • Manage Custom Plug-ins
  • Compose Expressions
  • Use Data Actions to Connect to Canvases, External URLs, and Use in Publisher Reports
    • Create Data Actions to Connect Visualization Canvases
    • Create Data Actions to Connect to External URLs from Visualization Canvases
    • Create Data Actions to Connect to REST APIs from Visualization Canvases
    • Use Data Actions to Connect to Oracle Business Intelligence Publisher Reports
      • About Creating Data Actions to Connect to Oracle Business Intelligence Publisher Reports
      • Create Data Actions to Connect to Oracle Business Intelligence Publisher Reports
      • Create Custom Column Names in Data Actions to Pass in Oracle Business Intelligence Publisher Report URLs
    • Invoke Data Actions from Visualization Canvases
  • Visualize Data from the Home Page
  • Find Data, Workbooks, and Visualizations
    • How Is Data Indexed?
    • Search for Content
    • Advanced Search Commands for Finding Content
    • Search Tips
  • Save Your Changes Automatically
  • Sort the Items in a Page
• 10 Create Custom Data Action Plug-ins
  • About Data Action Plug-ins and the Data Actions Framework
    • Data Action Categories
    • Data Action Context
    • Data Action Code Design
    • Data Action Model Classes
    • Data Action Service Classes
    • Data Action Code Interactions
    • Example Data Action plugin.xml File
    • Data Action Plug-in Files and Folders
  • Choose the Best Data Action Class to Extend
    • AbstractDataAction Class
    • DataActionKOModel Class
    • CanvasDataAction Class
    • EventDataAction Class
    • AbstractHTTPDataAction Class
    • URLNavigationDataAction Class
    • HTTPAPIDataAction Class
  • Generate Data Action Plug-ins from a Template
  • Generated Folders and Files
  • Extend a Data Action Base Class
  • Choose Which Data Action Inherited Methods to Override
  • Test, Package, and Install Your Data Action
  • Use an Upgrade Handler for Knockout Model Changes
  • Upgrade Data Action Plug-ins
  • Data Action Plug-in File Reference
    • Data Action plugin.xml File Example
    • Data Action plugin.xml File Properties Section - tns:obiplugin
    • Data Action plugin.xml File Resources Section - tns:resources
    • Data Action plugin.xml File Extensions Section - tns:extension
• 11 Use Oracle Analytics Predictive Models and Oracle Machine Learning Models
  • Create and Use Oracle Analytics Predictive Models
    • What Are Oracle Analytics Predictive Models?
    • How Do I Choose a Predictive Model Algorithm?
    • Create and Train a Predictive Model
    • Inspect a Predictive Model
      • View a Predictive Model's Details
      • Assess a Predictive Model's Quality
      • What Are a Predictive Model's Related Datasets?
      • Find a Predictive Model's Related Datasets
    • Add a Predictive Model to a Workbook
    • Evaluate Machine Learning Models Using Lift and Gain Charts
      • Overview to Using Lift and Gain Charts
      • Generate Predictive Data for Lift and Gain Charts
      • Evaluate a Machine Learning Model Using a Lift and Gain Chart
  • Register and Use Oracle Machine Learning Models
    • How Can I Use Oracle Machine Learning Models in Oracle Analytics?
    • Register Oracle Machine Learning Models in Oracle Analytics
    • Inspect Registered Oracle Machine Learning Models
      • View a Registered Model's Details
      • What Are a Registered Model's Views?
      • View a Registered Model's Views List
    • Visualize a Registered Oracle Machine Learning Model's View
  • Apply a Predictive or Registered Oracle Machine Learning Model to a Dataset
• 12 Import, Export, and Share
  • Import a Workbook File
  • Export a Workbook or Folder as a File
  • Export a Visualization or Story
  • Export a Visualization's Data to a CSV File
  • Email Workbooks and Folders
  • Email a File of a Visualization, Canvas, or Story
  • Print a Visualization, Canvas, or Story
• A Frequently Asked Questions
  • Oracle Analytics Desktop Installation FAQs
  • Oracle Analytics Desktop Workbook and Data Source FAQs
  • Oracle Analytics Desktop Printing and Exporting FAQs
• B Troubleshoot Visualization Issues
• C Accessibility Features and Tips
  • Start Oracle Analytics Desktop with Accessibility Features Enabled
  • Keyboard Shortcuts for Visualizations
  • Keyboard Shortcuts for Data Flow
• D Data Sources and Data Types Reference
  • Supported Data Sources
  • Oracle Applications Connector
  • Certification - Supported Data Types
    • Supported Base Data Types
    • Supported Data Types by Database
• E Data Preparation Reference
  • Transform Recommendation Reference
  • Column Menu Options for Quick Data Transformations
  • Developer Reference
    • Enable Developer Options
• F Expression Editor Reference
  • SQL Operators
  • Conditional Expressions
    • Best Practices For Using CASE statements in Analyses and Visualizations
  • Functions
    • Aggregate Functions
    • Analytics Functions
    • Calendar Functions
    • Conversion Functions
    • Display Functions
    • Evaluate Functions
    • Mathematical Functions
    • Running Aggregate Functions
    • String Functions
    • System Functions
    • Time Series Functions
  • Constants
  • Types
• G Oracle Analytics Desktop SDK Reference
  • Oracle Analytics Desktop SDK
    • Scripts
    • Other Resources
  • Create the Visualization Plug-in Development Environment
  • Create a Skeleton Visualization Plug-in
  • Create a Skeleton Skin or Unclassified Plug-in
  • Develop a Visualization Plug-in
  • Run in SDK Mode and Test the Plug-in
  • Validate the Visualization Plug-in
  • Build, Package, and Deploy the Visualization Plug-in
  • Delete Plug-ins from the Development Environment