Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Resources
• Conventions

New Features for Oracle Data Visualization Users

• New Features for Oracle BI EE 12c (12.2.1)
• New Features for Oracle BI EE 12c (12.2.1.1)
• New Features for Oracle BI EE 12c (12.2.1.2)
• New Features for Oracle BI EE 12c (12.2.1.3)

1 Getting Started with Visual Analyzer

• About Oracle Data Visualization
• What is the Visual Analyzer Home Page?
• Searching for Projects and Visualizations
• Visualizing Data with BI Ask
• Search Tips

2 Exploring Your Content

• Typical Workflow for Exploring Content
• Choosing Data Sources
• Adding Data Elements to Visualizations
  • Adding Data Elements to Drop Targets
  • Adding Data Elements to Visualization Drop Targets
  • Adding Data Elements to a Blank Canvas
• Sorting Data in Visualizations
• Adjusting the Canvas Layout
• Changing Visualization Types
• Adjusting Visualization Properties
• Working With Color
  • Applying Color to Projects
  • Setting Visualization Colors
• Undoing and Redoing Edits
• Reversing Visualization Edits
• Refreshing Visualization Content
• Exploring Data Using Filters
  • About Filters and Filter Types
  • How Visualizations and Filters Interact
  • About Automatically Applied Filters
  • Creating Filters on a Project
  • Moving Filter Panels
  • Applying Range Filters
  • Applying List Filters
  • Applying Date Filters
  • Building Expression Filters
• Exploring Data in Other Ways
• Composing Expressions
• Creating Calculated Data Elements
• Building Stories
  • Capturing Insights
  • Shaping Stories
  • Sharing Stories
• Exploring Data Without Authoring
  • Investigating Data Using Interactions
  • Viewing Streamlined Content
• Exploring Data on Mobile Devices
  • What You See on a Tablet
  • What You See on a Mobile Phone

3 Adding Your Own Data

• Typical Workflow for Adding Data from Data Sources
• About Adding Your Own Data
• About Data Sources
• About Adding a Spreadsheet as a Data Source
• Connecting to Oracle Applications Data Sources
  • Creating Oracle Applications Connections
  • Composing Data Sources from Oracle Applications Connections
  • Editing Oracle Applications Connections
  • Deleting Oracle Applications Connections
• Connecting to Database Data Sources
  • Creating Database Connections
  • Creating Data Sources from Databases
  • Editing Database Connections
  • Deleting Database Connections
• Adding Data from Data Sources
  • Adding File Based Data
  • Adding Oracle Applications Data
  • Adding Database Data
• Modifying Uploaded Data Sources
• Blending Data That You Added
• Changing Data Blending
• Refreshing Data that You Added
• Updating Details of Data that You Added
• Controlling Sharing of Data You Added
• Removing Data that You Added
• Deleting Data Sources
• Managing Data Sources

A Expression Editor Reference

• SQL Operators
• Conditional Expressions
• Functions
  • Aggregate Functions
  • Analytics Functions
  • Calendar Functions
  • Conversion Functions
  • Display Functions
  • Evaluate Functions
  • Mathematical Functions
  • String Functions
  • System Functions
  • Time Series Functions
• Constants
• Types