Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documents
  • Conventions
• Part I Introduction to Visualization and Reporting in Oracle Analytics Cloud
  • 1 Get Started with Visualizing Data and Building Reports
    • About Visualizations and Analyses
    • Access Oracle Analytics Cloud
      • Change Your Own Password
    • Find and Explore Your Content
      • Find Your Content
      • Search Options
      • Search Tips
      • Explore Your Content
    • About Watchlists
      • Create a Watchlist
      • Add a Visualization to a Watchlist
      • Delete a Visualization Card from a Watchlist
    • View Content on Mobile Devices
      • Access and Interact with Your Oracle Analytics Content On the Go
      • View and Collaborate on Analytical Charts Using Oracle Analytics Day by Day
      • Explore Data on Mobile Devices Using A Built-in Browser
• Part II Prepare Data
  • 2 Connect to Your Data Using Datasets
    • What Are Datasets?
    • About Opening Datasets
    • View Available Connections
    • Data Sources Available for Use in Datasets
    • About the Dataset Editor
    • Create a Dataset From a Connection
    • Add Multiple Connections to a Dataset
    • Add a File to a Dataset Created From a Connection
    • Add a Table to a Dataset Using a SQL Statement
    • 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?
    • Enhance Your Data Using Quality Tiles
    • About Removing or Restoring Dataset Columns
    • Remove or Restore a Dataset Table's Columns
    • Filter a Dataset Table
    • Use Role-Based Filters
      • About Role-Based Filters
      • Filter a Dataset Based on an Application Role
      • Example One - Apply a Simple Role-Based Filter in a Workbook
      • Example Two - Apply Multiple Role-Based Filters in a Workbook
    • 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 or Google Drive
      • Add Multiple Files to a Dataset
    • Create a Dataset from a Subject Area in Oracle Fusion Cloud Applications Suite
    • Create a Dataset from an Analysis in Oracle Fusion Cloud Applications Suite
    • Create a Dataset from a Local Subject Area
    • Create a Dataset from a Local Analysis
    • Create a Dataset from an Essbase Connection
    • Create a Dataset from a Data Source with REST Endpoints
    • Create a Dataset from OCI Object Storage
  • 3 Enrich and Transform Data
    • About Data Enrichment and Transformation in Oracle Analytics
    • Enrich and Transform Your Data
    • Accept Enrichment Recommendations
    • Transform Data
    • Change the Column Type of Measures and Attributes
    • Replace Missing or Null Values in a Dataset
    • 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
    • Configure Columns Properties in a Dataset
    • Hide or Delete a Column
    • Restore a Hidden or Deleted Column
    • Add Columns to a Dataset
    • Working With Calculations
    • Create Reusable Functions and Calculations in a Workbook
    • Create Group Calculations in a Workbook
    • Edit the Data Preparation Script
    • Enrich and Transform Reference
      • Transform 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
  • 4 Create Datasets Using Data Flows
    • About Data Flows
      • Database Support for Data Flows
      • Working in the Data Flow Editor
    • What Steps Can I Use to Organize and Integrate My Data?
      • Database Analytics Functions
      • Graph Analytics Functions
    • Create a Dataset Using a Data Flow
    • Generate or Update a Dataset Using a Data Flow
    • Reuse a Data Flow
    • Configure Incremental Processing in a Data Flow
      • Specify a New Data Indicator for a Data Source
      • Apply Incremental Processing in a Data Flow
    • Transform Data Using OCI Functions
    • Generate or Update a Dataset at a Specific Time
    • Change When a Data Flow Processes Data
    • Process Data Using a Sequence of Data Flows
    • Manage Your Data Flows
    • About Sharing Data Flows and Sequences
    • Share a Data Flow
    • Share a Sequence
  • 5 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 Data from the Workbook Editor
      • Reload an Individual Table in a Dataset
      • Reload Tables in a Dataset
      • Reload a Dataset's Files
      • Reload a Dataset's Data Incrementally
        • Overview to Loading Datasets Incrementally
        • Configure a Dataset to Load Incrementally
        • Load Dataset Data Incrementally
      • View a Dataset's Reload History
      • View and Download Log Files for a Dataset Reload Job
    • Work with Dataset Reload Schedules
      • Schedule a Dataset Reload
      • View a Dataset Reload Schedule's Details
      • Modify a Dataset Reload Schedule
      • Delete a Dataset Reload Schedule
    • Inspect a Dataset's Properties
    • Rename a Dataset and Change Its Description
    • Copy a Dataset's Object ID
    • Certify a Dataset
    • View a Dataset's Data Elements
    • Make Data Available for Oracle Analytics AI Assistant and Home Page Ask
      • About Indexing a Dataset for Oracle Analytics AI Assistant and Home Page Ask
      • About Recommended Index Settings
      • Index a Dataset
      • Index a Dataset on Demand
      • Schedule When to Index a Dataset
    • Make Analytics Content Easier to Search
      • About Making Analytics Content Easier to Search
      • Specify Synonyms for Dataset Columns
    • Add or Update a Dataset's Permissions
    • Download a Dataset's Source File
    • Duplicate a Dataset
    • Delete a Dataset
    • Enable Knowledge Enrichments in the Workbook Editor
• Part III Visualize Data
  • 6 Visualize and Analyze Data
    • Begin to Build a Workbook and Create Visualizations
    • Open a Workbook in Edit Mode
    • 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
          • Tips on Blending Data
        • Change Data Blending in a Visualization
    • Build a Visualization by Adding Data
      • Create the Best Visualization For Selected Data Elements
      • Add Data to a Visualization
      • Create a Visualization from Another Visualization
      • Modify a Visualization's Tooltips
      • Using Knowledge Enrichments in the Workbook Editor
    • Tips on Editing a Visualization
      • Duplicate a Visualization
      • Copy a Visualization from Another Workbook
    • Generate Visualizations with Oracle Analytics AI Assistant and Home Page Ask
      • Generate Visualizations with Oracle Analytics AI Assistant
      • Generate Visualizations from the Home Page with Questions
      • About Oracle Analytics AI Assistant
    • About Visualization Types
      • Bar Graphs
      • Filter and Other Visualization Types
      • Geospacial Graphs
      • Grid Graphs
      • Line Graphs
      • Network Graphs
      • Pie and Treemap Graphs
      • Scatter Graphs
    • Enhance Visualizations with Statistical Analytics
      • Before You Start with Statistical Analytics
      • What Statistical Analytics Can I Add to Visualizations?
      • Add Statistical Analytics to Visualizations
      • Add a Forecast to a Visualization
      • Add a Reference Line to a Visualization
      • Create a Cluster or Outlier in a Visualization
    • Add a Language Narrative Visualization
      • About the Language Narrative Visualization
      • Create a Language Narrative Visualization
    • Create a Legend Visualization
    • Use Spark Charts to Examine Trends
    • Sort Data in Visualizations
    • Undo and Redo Edits
    • Create a Custom Error Message for Visualizations with No Data
    • About Refreshing a Workbook's Data
    • Refresh a Workbook's Data
    • Pause Data Queries in a Workbook
    • Work with Canvas Properties
      • About Canvas Layout Properties
      • Update Canvas Properties
      • Align Visualizations Using Canvas Grid Guidelines
      • About Brushing Between Visualizations on a Canvas
      • About Synchronizing Visualizations in a Canvas
      • About Canvas Data Refresh Properties
    • Design Canvas Layouts for Different Screen Sizes
      • About Designing Canvas Layouts to Display on Devices with Different Screen Sizes
      • Design Canvas Layouts to View on Different Devices
    • 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
      • Display Multiple Visualizations Equally on a Canvas
    • Change Visualization Types
    • About Visualization Properties
    • Adjust Visualization Properties
      • Set Visualization Border Properties
      • Set Visualization Shadow Properties
      • Change Display Names in Tables and Pivots
      • Change the Size of Data Points in Visualizations
      • Change the Pattern and the Width of Lines in Graphs
    • Apply Color to Visualizations
      • About Color Assignments in Visualizations
      • Access Color Options
      • Change the Color Palette
      • Assign Colors to Columns
    • Highlight Important Data Events with Conditional Formatting
      • What Can I Do with Conditional Formatting?
      • Format Data with Existing Conditional Format Rules
      • Add Conditional Formatting to Data
      • 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
      • Example - Hightlight Values with Emojis
    • Format Numeric Values of Columns
    • Format Numeric Values of Visualizations
      • Set Scale Options for Numbers and Currency Values
    • 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
    • Sort, Drill, and Select Data in Visualizations
    • An Overview of Calculations
    • About the Warning for Data Issues in Visualizations
    • Create a Catalog Folder
    • Embed a Workbook and Visualizations in a Dashboard
      • Tips on Embedding Workbook Canvases in Dashboards
    • Save a Workbook to a Shared Catalog Folder
    • Assign Shared Catalog Folder and Workbook Permissions
      • Add or Update a Shared Workbook's Permissions
      • Add or Update Shared Catalog Folder Permissions
      • Workbook Permissions Rules
    • Configure How Workbooks Open By Default
      • Configure All of Your Workbooks to Open in Edit Mode by Default
      • Configure a Workbook to Open in Edit Mode
    • Set Workbook Thumbnails
    • Set Visualization Loading Overlay Opacity
    • Open a Custom Workbook Extension
  • 7 Filter Data
    • Use Workbook Filters
      • Add Workbook Filters
      • Include a Workbook Filter on all Workbook Canvases
      • Display or Hide Selected Values in the Workbook Filter Label
      • Specify How Workbook Filters Limit Other Filters
      • Manually Apply Workbook Filters
      • Convert Workbook Filters to Dashboard Filters
    • Use Dashboard Filters
      • Add Dashboard Filters
      • Modify the Dashboard Filters Visualization Properties
      • Change the Orientation of Dashboard Filters
      • Change the Dashboard Filter Style
      • Modify an Individual Dashboard Filter's Properties
      • Specify How Dashboard Filters Limit Other Filters
      • Filter a Dashboard Filter Visualization by Other Filters
      • Apply a Dashboard Filter to Visualizations on the Canvas
      • Filter and Animate Visualizations using a Slider Dashboard Filter
    • Use Visualization Filters
      • Add Visualization Filters
      • Use a Visualization as a Filter
    • Tasks for All Filter Types
      • Exclude Selected Filter Values
      • Include Null Filter Values
      • Disable a Filter
    • Filter Data Using an Expression Filter
    • Work with Filter Personalizations
      • About Filter Personalizations
      • Reset Filter Values
  • 8 Create and Use Parameters
    • What Are Parameters?
    • About System Parameters
    • About Parameter Properties
    • About Modifying and Deleting Parameters
    • Create a Parameter
    • Create a Parameter that Uses a Logical SQL Query for a Double Column
    • Create a Parameter with the SQL Expression Data Type
    • Syntax for Referencing Parameters
    • Bind Parameters to Filters
      • About Binding Parameters to Filters
      • Create and Bind a Parameter to a Workbook Filter
      • Create and Bind a Parameter to a Dashboard Filter
      • Create and Bind a Parameter to Exclude Filter Values
      • Create and Bind a Parameter to a Double Column Type Filter
      • Bind an Existing Parameter to a Filter
    • Use Parameters in Workbooks
      • Use a Parameter in the Filter Bar
      • Use a Parameter as a Dashboard Filter Control
      • Use a Parameter in a Visualization's Title
      • Use a Parameter as a Visualization's Axis Label
      • Use a Parameter in a Tile Visualization's Measure Label
      • Use a Parameter in an Expression Filter
      • Use a Parameter in a Workbook Calculation
      • Use an Analytics Link Data Action to Pass Parameter Values
      • Use a URL Navigation Data Action to Pass Parameter Values
      • Bind a Parameter to a Reference Line or Band
      • Bind a Parameter to a Request Variable
  • 9 Understand Your Data Using Insights
    • Use Auto Insights to Understand Your Data
      • What Are Auto Insights?
      • Use Auto Insights to Get Immediate Insights into Your Data
      • Visualization Types Generated by Auto Insights
      • Interact with Auto Insights to Focus on What You're Interested In
      • Administration and Limitations
    • Use Explain to Understand Your Data
      • What is Explain?
      • Quick Start with Explain
      • Use Explain to Get Immediate Descriptive Insights Into Your Data
      • Use Explain to Identify the Drivers of Your Selected Column
      • Use Explain to Identify the Most Significant Segments of Records In Your Dataset
      • Use Explain to Identify Anomalies Among Records In Your Dataset
  • 10 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
    • Switch to Use Another Map Layer
    • Apply Multiple Data Layers to a Single Map Visualization
    • Apply Reference Layers to Map Visualizations
    • 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
    • Configure Zoom in Map Visualizations
    • 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
    • Add an Outline to Points and Shapes on a Map
    • Add Data Labels to a Map
  • 11 Use Data Actions
    • Create Data Actions to Connect Canvases
    • Create Data Actions to Connect to External URLs from Visualization Canvases
    • About Creating HTTP API Data Actions
    • Create HTTP Data Actions
    • Use Data Actions to Connect to Oracle Analytics Publisher Reports
      • About Creating Data Actions to Connect to Oracle Business Intelligence Publisher Reports
      • Create Data Actions to Connect to Oracle Analytics Publisher Reports
      • Create Custom Column Names in Data Actions to Pass in Oracle Analytics Publisher Report URLs
    • Invoke Data Actions from Visualization Canvases
    • How Data Actions Affect Filters
    • Tips on Using Data Actions
    • Create Data Actions in Visualizations Embedded in External Containers
    • Execute Data Actions that Contain Embedded Content
  • 12 Use Other Functions to Visualize Data
    • Identify Content with Tooltips
    • Compose Expressions
    • Save Your Changes Automatically
    • Sort the Items in a Page
  • 13 Build a Presentation Flow
    • What Is a Presentation Flow?
    • What Are Auto and Manual Modes in Present?
    • Manual Mode and How Canvases Synch
    • Switch Between Auto and Manual Modes in Present
    • View Canvas Layout Breakpoints in Present
    • Open the Presentation Flow
    • Specify the Canvases Layout in Present
      • Rearrange the Canvases in Present
      • Duplicate a Canvas in Present
      • Remove a Duplicate Canvas in Present
      • Hide a Canvas in Present
      • Display a Hidden Canvas in Present
      • About Moving or Hiding Visualizations on a Canvas in Present
      • Change a Visualization's Placement on a Canvas in Present
      • Reset a Canvas in Present
    • Set the Workbook Properties in Present
      • Specify Workbook Canvas Navigation in Present
      • Show or Hide the Workbook Header Bar in Present
      • Modify the Workbook Header Title in Present
      • Modify the Workbook Header Color in Present
      • Add an Image to the Workbook Header in Present
      • Show or Hide the Zoom Control in Present
      • Specify Workbook Zoom Control Options in Present
      • Show or Hide the Workbook Toolbar in Present
      • Select Workbook Toolbar Options in Present
      • Show or Hide the Workbook Filter Bar in Present
      • Specify Workbook Filter Options in Present
      • Show or Hide Workbook Filters in Present
      • Specify the Workbook Visualization Actions in Present
      • Change the Workbook Canvases Visualization Alignment in Present
      • Turn On or Off All Workbook and Canvas Actions in Present
      • Specify Personalization Options in Present
    • Set Canvas Properties in Present
      • Specify Canvas Filter Actions in Present
      • Show or Hide Canvas Filters in Present
      • Select Canvas Visualization Toolbar Options in Present
      • Specify Canvas Visualization Menu Options in Present
      • Show or Hide Canvas Visualizations in Present
      • Specify Canvas Zoom Control Options in Present
      • Show or Hide Canvas Notes in Present
    • Preview a Presentation Flow
  • 14 Use Oracle Analytics Predictive Models and Oracle Machine Learning Models
    • What Machine Learning and Artificial Intelligence Services Does Oracle Analytics Support?
    • Create and Use Oracle Analytics Predictive Models
      • What Are Oracle Analytics Predictive Models?
      • How Do I Choose a Predictive Model Algorithm?
      • Train a Predictive Model Using AutoML in Oracle Autonomous Data Warehouse
      • Create and Train a Predictive Model
        • Data Flow Steps for Training Machine Learning Models
      • 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
    • Use Oracle Machine Learning Models in Oracle Analytics
      • 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
    • Use Oracle Cloud Infrastructure Vision Models in Oracle Analytics
      • Parameter Options for Object Detection, Image Classification, and Text Detection Analysis Models
      • Output Data Generated for Face Detection, Object Detection, Image Classification, and Text Detection Analysis Models
    • Use Oracle Cloud Infrastructure Data Science Models in Oracle Analytics
      • Apply an OCI Data Science Model to a Dataset
    • Use Oracle Cloud Infrastructure Document Understanding Models in Oracle Analytics
      • Overview to Document Classification and Key Value Extraction
      • Prepare Documents to Analyze with an OCI Document Understanding Model
      • Perform Document Classification and Key Value Extraction
        • Parameter Options for OCI Document Understanding Models
        • Output Data Generated for OCI Document Understanding Models
    • Use Oracle Cloud Infrastructure Language Models in Oracle Analytics
      • Apply an OCI Language Model to a Dataset
      • Obfuscate Sensitive Data in a Dataset
  • 15 Import, Export, and Share
    • Import a Workbook File
    • Share a Workbook
    • Share a Workbook URL with a Specific Canvas Selected
    • Export a Workbook or Folder as a File
    • Export a Visualization
      • Tips on Exporting Data in CSV Format
    • Export Formatted Data from a Visualization to Excel
    • Share a Visualization, Canvas, or Dashboard to Social Media
    • Delete Links Shared on Social Media
    • Email a File of a Visualization, Canvas, or Dashboard
    • Print a Visualization, Canvas, or Dashboard
    • Share Visualizations Using Workbook Email Schedules (Preview)
      • About Creating Workbook Email Schedules (Preview)
      • Create a Workbook Email Schedule (Preview)
      • Create a Bursting Workbook Email Schedule (Preview)
      • Manage Workbook Email Schedules and Jobs (Preview)
• Part IV Report Data
  • 16 Create Analyses
    • Typical Workflow to Create Analyses
    • Create Your First Analysis
    • Set Properties for Columns
      • Apply Formatting to Content
      • Format Columns
      • Make Your Analyses Dynamic
        • Add Interactivity to Analyses
        • Make Interactions Available
      • Set Default Formats for Your System
    • Export Content from Analyses and Dashboards
      • Export the Results of Analyses
      • Export Dashboards and Dashboard Pages
      • Tips for Exporting
    • Edit Formulas or Calculated Measures
      • Edit the Formula for a Column
      • Edit Calculated Measures
    • Set Properties for Analyses
    • Set Your Preferences
    • Advanced Techniques: Import Formatting from Another Analysis
      • About Applying Formatting from Columns
      • About Applying Formatting from Views
      • About Applying Formatting from Containers
      • Import Formatting from a Saved Analysis to a Target Analysis
    • Advanced Techniques: Format with HTML Tags
    • Advanced Techniques: Combine Columns to Display Data Differently
    • Advanced Techniques: Examine the Logical SQL Statements for Analyses
    • Advanced Techniques: Set Caching Options for Your Analysis
    • Advanced Techniques: Reference Stored Values in Variables
      • About Session Variables
        • System Session Variables
        • Non-System Session Variables
      • About Semantic Model (Repository) Variables
      • About Presentation Variables
      • About Request Variables
      • About Global Variables
      • Create Global Variables
      • Syntax for Referencing Variables
        • Session Variables
        • Presentation Variables
        • Semantic Model (Repository) Variables
    • Advanced Techniques: Issue Direct Database Requests
      • Privileges Required for Direct Database Requests
      • Create and Execute Direct Database Requests
  • 17 View Data in Different Ways
    • Typical Workflow to View Data in Different Ways
    • About Views
    • Add Views
    • Edit Views
    • Edit Various Types of Views
      • Edit Table and Pivot Table Views
      • Edit Performance Tile Views
      • Edit Treemap Views
      • Edit Heat Matrix Views
        • About Heat Matrix Views
      • Edit Trellis Views
        • About the Functions of Trellis Views
        • About Simple Trellis Versus Advanced Trellis
        • Design Considerations for Trellis Views
      • Edit Gauge Views
        • Set Thresholds
      • Edit Map Views
        • About Map Views
          • Map Components
        • About Formats and Layers in Map Views
          • About Formats in Map Views
            • About the Types of Formats that Apply to Map Layers
            • About the Visibility of Formats in Map Views
            • About the Application of Formats in Map Views
          • About Layers in Map Views
        • Edit Formats and Layers in Map Views
        • Apply Formats to Layers in Map Views
        • Move Around in Map Views
          • Pan in Map Views
          • Zoom in Map Views
          • Modify Thresholds for Formats on a Map View
          • Show or Hide Formats on a Map View
        • Set the Initial View Ports for Map Views
      • Edit Narrative Views
      • Edit Non-Data Views
        • About Column Selector Views
        • About View Selector Views
        • About Filters Views
        • About Selection Steps Views
        • About Static Text Views
        • About Title Views
    • Graph Data in Analyses
      • Edit Graph Views
      • Zoom and Scroll in Graphs
      • Format the Visual Appearance of Graphs
        • Format Graphs Based on Position
        • Format Graphs Based on Columns
        • Rules to Apply Conditional Formats in Graphs
        • Graph Exceptions for Conditional Formatting on Columns
      • Limit Data Displayed in Graphs and Gauges
        • Define Section Sliders in Graphs and Gauges
        • Use Section Sliders in Graphs and Gauges
    • Save Views
    • Rearrange Views
    • Refresh the Results in Views
    • Print Views
    • Change Print Options for Views
    • Preview How Views Are Displayed on Dashboards
    • Remove Views
    • Sort Values in Views
    • Clear Sorts in Views
    • Drill in Results
      • About Drilling
      • Drill in Tables and Other Views
      • Drill in Graphs
      • Drill in Map Views
    • Resize Rows and Columns in Views
      • Configure to Resize in Views
      • Resize in Views
    • Suppress Null Values in Views
    • Assemble Views for Display
    • Link Views in Master-Detail Relationships
      • Define Master Views
      • Define Detail Views
    • Modify the Layout of Data in Views
      • Add and Rearrange Columns in Views
        • Add Columns to Views
        • Remove Columns from Views
        • Rearrange Columns in Views
      • Set Properties for Sections of Data in Views
      • Add Totals to Tables and Pivot Tables
      • Display Running Sums and Relative Values in Pivot Tables
        • Display Running Sums for Measure Columns in Pivot Tables
        • Display Relative Values for Measure Columns in Pivot Tables
    • About Drop Targets in the Layout Pane
      • About the Types of Drop Targets
      • About the Excluded Drop Target
      • About the Guidelines for Drop Targets for Various Views
        • Drop Target Guidelines for Graphs and Funnel Graphs
        • Drop Target Guidelines for Heat Matrixes
          • Details of the Color By Area for Heat Matrixes
        • Drop Target Guidelines for Trellises
        • Drop Target Guidelines for Treemaps
    • Visualize Data in an Analysis
  • 18 Build Dashboards
    • Typical Workflow to Build Dashboards
    • Create Your First Dashboard
    • Edit Dashboards
    • Add and Delete Pages in Dashboards
      • Add Pages to Dashboards
      • Print Dashboards
      • Add Subpages to Dashboards
      • Add Content to Dashboard Pages
      • Understand How Dashboard Pages and Oracle Analytics Publisher Reports Interact
      • Configure the Style and Behavior of Dashboards and Pages
      • Change the Properties of Objects Added to Dashboard Pages
      • Delete Objects on Dashboard Pages
      • Delete Dashboard Pages
      • Delete Dashboard Subpages
    • Create and Manage Layouts for Dashboards and Dashboard Pages
      • About Custom Print and Export Layouts
      • Create Custom Layouts
      • Edit, Replace, or Remove Custom Layouts
      • Edit, Replace, or Remove Custom Layouts
      • Items Not Supported for Custom Print Layouts in BI Publisher
    • Print Dashboards
    • Organize Dashboard Pages in Briefing Books
      • Add Content to New or Existing Briefing Books
      • Edit the Content of Briefing Books
      • Download Briefing Books
      • Add a List of Briefing Books to a Dashboard Page
    • Save and Restore Dashboard State
      • Save Customizations of Dashboard Pages
      • Apply Saved Customizations
      • Edit Saved Customizations
      • Clear the Current Customization
    • Publish Dashboard Pages
    • Link to Dashboard Pages
      • About Bookmark Links
      • Create Bookmark Links to Dashboard Pages
  • 19 Filter and Select Data for Analyses
    • Typical Workflow to Filter and Select Data
    • About Filters and Selection Steps
      • About Prompted Filters
    • Create Filters for Columns
      • Create Inline and Named Filters
      • Specify Values for Filters
      • Embed an EVALUATE_PREDICATE Function in a Filter
      • Combine and Group Filters
      • Save Inline and Named Filters
    • Edit Filters for Columns
    • Reuse Filters
    • Use a Saved Analysis as a Filter
    • Advanced Techniques: How Dashboard Prompts and Analysis Prompts Interact
    • Refine Selections of Data
      • Create Selection Steps
      • Edit Selection Steps
      • Save Selection Steps for Reuse
      • Advanced Techniques: Create Condition Steps
    • Manipulate Members with Groups and Calculated Items
      • About Groups and Calculated Items
      • Create Groups and Calculated Items
      • Edit Groups and Calculated Items
      • View Group Contents
      • Save Groups and Calculated Items
      • Reuse a Group or Calculated Item in an Analysis
      • Delete Groups and Calculated Items
  • 20 Prompt in Analyses and Dashboards
    • Typical Workflow to Create Prompts in Analyses and Dashboards
    • Create Prompts
      • Create Column Prompts
      • Create Variable Prompts
      • Override a Selection Step with a Prompt
      • Create Currency Prompts
    • Edit Prompts
    • Add Prompts to Dashboard Pages
    • Add Hidden Prompts to Dashboard Pages
  • 21 Make Analyses Interactive
    • Typical Workflow to Make Analyses Interactive
    • Create Named Actions for Reuse
    • Create Inline Actions
    • Add Actions to Analyses
    • Add Actions to Dashboard Pages
      • Add Actions to Dashboard Pages with Action Links
      • Add Actions to Dashboard Pages with Action Link Menus
    • Edit Named Actions
    • Edit and Delete Action Links in Analyses
    • Edit and Delete Action Links in Dashboard Pages
    • Save Inline Actions in Analyses to the Catalog
    • Save Inline Actions in Dashboards to the Catalog
  • 22 Managing Content
    • Typical Workflow to Manage Content
    • About Naming Restrictions for Catalog Objects
    • Rename Content
      • Rename Items
      • Rename Views
    • Search for and Replace Text in Catalog Objects
      • Search for and Replace a Simple Catalog Text String
      • About Search and Replace of Multiple Catalog Text Strings
        • JSON File Format to Search for and Replace Text Strings
      • Example JSON File for Searching for and Replacing Text Strings
      • Search for and Replace Multiple Catalog Text Strings
    • Access Favorites Easily
      • Add Content to Your Favorites List
      • Remove Content from Your Favorites List
    • Access Properties
    • Assign Access Permissions
      • Add or Update Item Permissions
      • Add or Update Dashboard Section Permissions
    • Send Email Reports and Track Deliveries
      • Send Email Reports Once, Weekly, or Daily
      • Track the Reports You Distribute By Email or Through Agents
      • View and Edit Recipients for Deliveries
      • Suspend and Resume Deliveries
      • Change the Owner or Time Zone for Deliveries
      • Restore and Enable Delivery Schedules
      • Generate and Download a Deliveries Report (CSV)
      • Email Security Alert
    • Automate Business Processes with Agents
      • Create Agents to Deliver Content
      • Schedule an Agent to Deliver Content Directly from an Analysis
      • Disable and Enable the Schedule for an Agent
      • Subscribe to Agents
      • List Agents You Subscribe To or Own
      • Access and Manage Your Alerts
    • Configure Your Devices and Delivery Profile
      • About Devices and Delivery Profiles
      • Configure Your Devices
      • Configure Your Delivery Profiles
    • Assign Ownership of Items
    • Assume Ownership of Items
    • About Embedding External Images and Other External Resources in Your Content
    • Access Your Reporting Content in Smart View
    • Access Your Reporting Content in Microsoft Power BI
    • Perform Advanced Catalog Management
      • Download and Install Oracle Analytics Client Tools
      • Use the Catalog Manager Command Line Interface
      • CLI Example: Find and Replace Catalog Text
      • CLI Example: Unarchive a Catalog Archive
      • CLI Example: Generate a Catalog Report
• Part V Publish Data
  • 23 Introduction to Pixel-Perfect Publishing
    • Overview of Pixel-Perfect Reporting
    • Tasks for Report Consumers
    • Set Your Account Preferences
    • About the Catalog
      • Browse the Catalog
      • Search the Catalog
    • Download Desktop Tools
  • 24 View Pixel-Perfect Reports
    • View a Report
    • Configure Pixel-Perfect Reports Using Report Viewer
      • Specify Parameters
        • Search for a Parameter Value
      • Select a Layout
      • Select an Output Type
        • Output Types
      • Perform Actions
        • Actions
  • 25 Create Pixel-Perfect Report Jobs
    • Navigate to the Schedule Report Job Page
    • Set General Options
    • Set Output Options
      • Add Destination Types to Report Output
        • Report Output Destination Types
        • Content Server Destination Type Properties
      • Add Outputs
    • Define the Schedule for a Job
      • Define a Recurrence Pattern
      • Use Schedule Triggers
        • About Schedule Triggers
        • Enable a Schedule Trigger
    • Configure Notifications
    • Submit and Monitor a Job
    • Create a Job from an Existing Job
    • Create a Bursting Job
    • Advanced Topics
      • Increment Date Parameters
      • Define a Destination File Name Dynamically with a Date Expression
        • Examples
  • 26 View and Manage Pixel-Perfect Report Jobs
    • About the Manage Report Jobs Page
      • Access the Manage Report Jobs Page
    • View Jobs for a Specific Report
    • Search for Report Jobs
    • Set the Time Zone for Viewing Jobs
    • View Job Details
    • Pause Jobs
    • Resume Jobs
    • Delete Jobs
    • Edit Jobs
  • 27 View and Manage Pixel-Perfect Report History
    • View Report Job History and Saved Output
    • View Job History for a Specific Report
    • Search for Report Job History
    • View Details of a Job History
    • Download Data from a Report Job
    • Republish from History in Report Viewer
    • Republish a Report from History
    • Send an Output to a New Destination
    • Monitor Running Jobs
      • Process Stages of Jobs
    • Cancel a Running Job
    • Get Error and Warning Information for Reports
    • Delete a Job History
  • 28 Manage Pixel-Perfect Reports
    • Overview of Folders
    • Reporting Components Stored in the Catalog
    • Create a Folder or Subfolder
    • Perform Tasks on Catalog Objects
    • Download and Upload Catalog Objects
    • Understand the Impact of Taking Actions on Objects Referenced by Reports
    • Export and Import Catalog Translation Files
• Part VI Reference
  • 29 Frequently Asked Questions
    • FAQs to Explore and Report
    • FAQs to Publish Data
  • 30 Troubleshoot
    • What Diagnostic Tools Are Available?
    • Troubleshoot General Issues
    • Troubleshoot Issues with Workbooks, Analyses, and Dashboards
    • Troubleshoot Visualization Issues
  • 31 Design Tips
    • Find the SQL_ID for an Oracle Analytics Query
    • Use the IndexCol Function
    • Maintain Initialization Blocks
    • Use Usage Tracking with Initialization Blocks
    • Minimize Impact on Query Performance Due to Network Latency
    • Assign the Aggregation Rule for Report Totals
    • Select the Best Option to Render Dashboards
    • Improve the Time to Display Dashboard Pages with Prompts
    • Configure Timestamps
    • Use Filter Functions Instead of Time Series Functions
    • Tune Performance of Multidimensional Database Queries
    • Tune Performance of Relational Database Queries
    • Tune Performance with Excluded Columns
  • 32 Data Preparation Reference
    • Developer Options
      • Enable Developer Options
    • Create a Connection to Your Oracle Cloud Infrastructure Tenancy
    • Integrate Oracle Analytics with Oracle Cloud Infrastructure Functions
      • About Using OCI Functions in Oracle Analytics
      • About Configuring OCI Functions to use in Oracle Analytics
      • Policies Required to Integrate OCI Functions with Oracle Analytics
      • Typical Workflow for Transforming Data Using OCI Functions
      • Register OCI Functions in Oracle Analytics
    • Integrate Oracle Analytics with Oracle Cloud Infrastructure Data Science
      • Prerequisites for Integrating OCI Data Science Models With Oracle Analytics
      • Policies Required to Integrate OCI Data Science with Oracle Analytics
      • Make an OCI Data Science Model Available in Oracle Analytics
    • Integrate Oracle Analytics with Oracle Cloud Infrastructure Document Understanding
      • Typical Workflow to Integrate Oracle Analytics with OCI Document Understanding
      • Policies Required to Integrate OCI Document Understanding with Oracle Analytics
      • Make a OCI Document Understanding Model Available in Oracle Analytics
    • Integrate Oracle Analytics with Oracle Cloud Infrastructure Language
      • Prerequisites for Integrating OCI Language Models With Oracle Analytics
      • Policies Required to Integrate OCI Language with Oracle Analytics
      • Make an OCI Language Model Available in Oracle Analytics
    • Integrate Oracle Analytics with Oracle Cloud Infrastructure Vision
      • Overview to Integrating Oracle Analytics with Vision
      • Policies Required to Integrate OCI Vision with Oracle Analytics
      • Typical Workflow to Integrate Oracle Analytics with Vision
      • Prepare Images for Analysis With an Vision Model
      • Make a Vision Model Available in Oracle Analytics
  • 33 Expression Editor Reference
    • Semantic Model Objects
    • SQL Operators
    • Conditional Expressions
      • Best Practices For Using CASE statements in Analyses and Visualizations
    • Functions
      • Aggregate Functions
        • Tips on Using Aggregate Functions
      • Analytics Functions
      • Conversion Functions
      • Date and Time Functions
        • Tips on Using Date Functions
      • Date Extraction Functions
        • Tips on Using Date Dimensions in Subject Areas
      • Display Functions
      • Evaluate Functions
      • Mathematical Functions
      • Running Aggregate Functions
      • Spatial Functions
      • String Functions
        • Tips on Using String Functions
      • System Functions
      • Time Series Functions
    • Constants
    • Types
    • Variables
  • 34 Certification Information
    • Certification - Supported Browsers