Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• Part I Introducing Data Preparation in Oracle Analytics Cloud
  • 1 Get Started with Data Preparation in Oracle Analytics Cloud
    • Prepare Your Data
    • Store Your Data With Oracle Analytics Cloud
    • Typical Workflow to Prepare Data
    • Access Oracle Analytics Cloud
    • Top Tasks to Prepare Data
      • Top Tasks to Connect to Data
      • Top Tasks to Model Data
      • Top Tasks to Manage Data
• Part II Connect to Data
  • 2 Connect to On-premises Data Sources
    • About Connecting to On-premises Data Sources
    • Typical Workflow to Connecting to On-premises Data Sources
    • Before You Start with Data Gateway
      • Download Data Gateway
      • Download and Install Developer Client Tool for Oracle Analytics Cloud
    • Install Data Gateway
      • Install Data Gateway on Linux
      • Install Data Gateway on MacOS
      • Install Data Gateway on Windows
    • Configure and Register Data Gateway
    • Connect to an On-premises Database from Oracle Analytics Cloud
    • Maintain Data Gateway on Linux
    • Install the Legacy Remote Data Connector
      • Before You Start with Remote Data Connector
        • Download the Public Key for Your Cloud Service
      • Install the Legacy Remote Data Connector Version on Linux
      • Deploy the Legacy Remote Data Connector on Linux
• Part III Model Data
  • 3 Understand Data Modeling
    • About Modeling Data
    • Plan a Data Model
      • Understand Data Model Requirements
      • Components of Data Models
      • About Modeling Source Objects with Star Relationships
      • About Modeling Source Objects with Snowflake Relationships
      • About Modeling Denormalized Sources
      • About Modeling Normalized Sources
  • 4 Start to Build Your Data Model
    • Typical Workflow to Model Data
    • Use Data Modeler
      • Open Data Modeler
      • Create a Data Model
      • Use the Left Pane in Data Modeler
      • Use the Right Pane in Data Modeler
      • Use Action Menus
      • Lock a Data Model
      • Validate a Data Model
      • Refresh and Synchronize Source Objects and Data Model Objects
      • Publish Changes to Your Data Model
      • Clear Cached Data
      • Rename a Data Model
      • Connect a Model to a Different Database
      • Export a Data Model
      • Import a Data Model
      • Delete a Data Model
    • Review Source Tables and Data
      • View Source Objects
      • Preview Data in Source Objects
    • Create Source Views
      • About Source Views
      • Add Your Own Source Views
      • Define Filters for Source Views
    • Add Fact Tables and Dimension Tables to a Data Model
      • About Fact Tables and Dimension Tables
      • Create Fact and Dimension Tables from a Single Table or View
      • Create Fact Tables Individually
      • Create Dimension Tables Individually
      • Edit Fact Tables and Dimension Tables
      • Add More Columns to Fact and Dimension Tables
        • Add Columns from Another Source to a Dimension Table
    • Join Tables in a Data Model
      • About Joins
      • Join Fact and Dimension Tables
    • Create a Time Dimension
    • Add Measures and Attributes to a Data Model
      • Edit Measures and Attributes
      • Specify Aggregation for Measures in Fact Tables
      • Create Calculated Measures
        • About Creating Calculated Measures
      • Create Derived Attributes
      • Create Expressions in the Expression Editor
        • About the Expression Editor
        • Create an Expression
      • Copy Measures and Attributes
    • Copy Model Objects
  • 5 Define Hierarchies and Levels to Drill and Aggregate
    • Typical Workflow to Define Hierarchies and Levels
    • About Hierarchies and Levels
    • Edit Hierarchies and Levels
      • Set Dimension Table Properties for Hierarchies
    • Set Aggregation Levels for Measures
      • About Setting Aggregation Levels for Measures
  • 6 Secure Your Data Model
    • Typical Workflow to Secure Model Data
    • Create Variables to Use in Expressions
      • About Variables
      • Define Variables
    • Secure Access to Objects in the Model
      • About Permission Inheritance
    • Secure Access to Data
• Part IV Manage Your Service
  • 7 Manage What Users Can See and Do
    • Typical Workflow to Manage What Users See and Do
    • About Users and Roles
      • Add a User or a Role
      • Reset Another User’s Password
      • Change Your Own Password
    • About Application Roles
      • Predefined Application Roles
    • Configure What Users Can See and Do
      • Get Started with Application Roles
      • Add Members to Application Roles
      • Why Is the Administrator Application Role Important?
      • Assign Application Roles to Users
      • Assign Application Roles to Multiple Users Through Roles
      • Add Your Own Application Roles
      • Delete Application Roles
      • Add One Predefined Application Role to Another (Advanced)
      • Enable Users to Search Data Sets
  • 8 Take Snapshots and Restore
    • Typical Workflow to Take Snapshots and Restore
    • About Snapshots
      • Options When You Take a Snapshot
      • Options When You Restore a Snapshot
    • Take Snapshots and Restore Information
      • Take a Snapshot
      • Restore from a Snapshot
      • Track Who Restored What and When
      • Edit Snapshot Descriptions
      • Delete Snapshots
    • Download and Upload Snapshots
      • Download Snapshots
      • Upload Snapshots
    • Migrate Oracle Analytics Cloud Using Snapshots
      • About Oracle Analytics Cloud Migration
      • Typical Workflow to Migrate Oracle Analytics Cloud
      • Migrate File-based Data
  • 9 Perform Administration Tasks
    • Typical Workflow to Perform Administration Tasks
    • Understanding Administration Tools
      • About the Classic Administration Page
    • Manage Database Connections for Data Models
      • About Database Connections for Data Models
      • Connect to Data in an Oracle Cloud Database
      • Secure Database Connections with SSL
    • Set Up a Virus Scanner
    • Set Up Social Channels for Sharing Visualizations
    • Set Up a Public Container to Share Visualizations
    • Set Up an Email Server to Deliver Reports
    • Enable Content Delivery Through Agents
    • Send Email Reports and Track Deliveries
      • Send Email Reports Once, Weekly, or Daily
        • Email Security Alert
      • Track the Reports You Distribute By Email or Through Agents
      • Suspend and Resume Deliveries
      • Restore and Enable Delivery Schedules
    • Manage the Types of Devices that Deliver Content
    • Upload Data Models from Oracle BI Enterprise Edition
      • About Uploading Oracle BI Enterprise Edition Data Models to the Cloud
      • Get Your Data Model File Ready
      • Upload Data Models from a File (.rpd) Using Console
      • About Editing Data Models Uploaded from Oracle BI Enterprise Edition
      • Download and Install Developer Client Tool for Oracle Analytics Cloud
      • Connect to a Data Model in the Cloud
      • Edit a Data Model in the Cloud
      • Upload a Data Model to the Cloud
      • Troubleshoot Oracle Analytics Developer Client Tool
      • Connect to a Data Source using a Connection Defined Through Console
      • Working with Data Models
    • Delete Unused Data Sources
    • Manage Map Information for Analyses
      • Set Up Maps for Dashboards and Analyses
      • Edit Background Maps for Dashboards and Analyses
    • Whitelist Safe Domains
    • Manage How Content Is Indexed and Searched
      • Configure Search Indexing
      • Schedule Regular Content Crawls
      • Monitor Search Crawl Jobs
      • Enable Users to Search Data Sets
    • Monitor Users and Activity Logs
      • Monitor Users Who Are Signed In
      • Analyze SQL Queries and Logs
    • Execute Test SQL Queries
    • Apply Custom Logos and Dashboard Styles
      • About Custom Logo and Dashboard Styles
      • Change the Default Style for Analyses and Dashboards
      • Manage Themes
    • Localize Catalog Captions
      • Overview to Localize Captions
      • Export Captions from the Catalog
      • Localize Your Captions
      • Upload Localized Captions to the Catalog
    • Integrate with Oracle Planning and Budgeting Cloud
      • About Integration with Oracle Planning and Budgeting Cloud Service
      • Prerequisites for Integration with Oracle Planning and Budgeting Cloud
      • Build and Upload an Oracle Planning and Budgeting Cloud Data Model
    • Replicate Data
      • About Data Replication
        • Prerequsites for Data Replication
        • Information You Need For Data Replication
        • What Data Sources Can I Replicate?
        • What Target Databases Can I Replicate Data Into?
        • What Replication Tasks Can I Do?
        • What Privileges and Permissions Are Required?
        • About Data Replication from Oracle Fusion Applications Data Sources
      • Replicate Your Data
      • Replicate Your Data Regularly
      • Modify a Data Replication Flow
      • Monitor and Troubleshoot a Data Replication Flow
    • Migrate from Oracle BI Enterprise Edition 11g
    • Migrate from Oracle BI Enterprise Edition 12c
    • Update the Cloud Storage Password
      • Update the Cloud Storage Password for an Oracle Managed Service
      • Update the Cloud Storage Password for a Customer Managed Service
    • Track Usage
      • About Tracking Usage
        • About the Usage Tracking Database
        • About Usage Tracking Parameters
        • About Analyzing Usage Data
      • Understand the Usage Tracking Tables
      • Typical Workflow for Tracking Usage
      • Specify the Usage Tracking Database
      • Set Usage Tracking Parameters
      • Analyze Usage Tracking Data
    • Enable Custom Java Script For Actions
    • Deploying Write-back
      • About Write-back for Administrators
      • Enable Write-back in Analyses and Dashboards
    • Configure Advanced Options
      • About Advanced Configuration
        • Performance and Compatibility Options
        • Analysis, Dashboard, and Pixel-Perfect Report Options
        • Usage Tracking Options
        • Prompt Options
        • Format Options
        • View Options
        • Connection Options
        • Security Options
      • Set Advanced Options for the Service
  • 10 Manage Publishing Options
    • About Administering Pixel-Perfect Publishing
      • Roles Required to Perform Pixel-Perfect Publishing Tasks
      • Navigate to the Administration Pages for Pixel-Perfect Reporting
    • Configure System Maintenance Properties
      • Set Server Caching Specifications
      • Set Retry Properties for Database Failover
      • Set Report Viewer Properties
      • Clear Report Objects from the Server Cache
      • Clear the Subject Area Metadata Cache
      • Enable Diagnostics
        • Enable Diagnostics for Scheduler Jobs
        • Enable Diagnostics for Online Reports
      • Purge Job Diagnostic Logs
      • Purge Job History
      • Upload and Manage Configuration-Specific Files
    • Configure the Scheduler
      • Understand the Scheduler
        • Architecture
        • About Clustering
        • How Failover Works
        • About Prioritizing Jobs
      • About the Scheduler Configuration
      • Configure Processors and Processor Threads
      • Scheduler Diagnostics
    • Set Up Data Sources
      • About Private Data Source Connections
      • Grant Access to Data Sources Using the Security Region
      • About Proxy Authentication
      • Choose JDBC or JNDI Connection Type
      • About Backup Databases
      • About Pre Process Functions and Post Process Functions
      • Set Up a JDBC Connection to the Data Source
        • Create a Secure JDBC Connection to Oracle Autonomous Data Warehouse
      • Set Up a Database Connection Using a JNDI Connection Pool
      • Set Up a Connection to an OLAP Data Source
      • Set Up a Connection to a Web Service
        • Add a Simple Web Service
        • Add a Complex Web Service
      • Set Up a Connection to an HTTP XML Feed
      • Set Up a Connection to a Content Server
      • View or Update a Data Source
    • Set Up Delivery Destinations
      • Configure Delivery Options
      • Add a Printer
        • Set Up a Printer
      • Add a Fax Server
      • Add an Email Server
      • Add an HTTP Server
      • Add an FTP Server
        • Configure a Secure FTP Connection
          • SSH Options for SFTP
      • Add a Content Server
      • Add a Common UNIX Printing System (CUPS) Server
      • Add a Cloud Server
    • Define Runtime Configurations
      • Set Runtime Properties
      • PDF Output Properties
      • PDF Digital Signature Properties
      • PDF Accessibility Properties
      • PDF/A Output Properties
      • PDF/X Output Properties
      • DOCX Output Properties
      • RTF Output Properties
      • PPTX Output Properties
      • HTML Output Properties
      • FO Processing Properties
      • RTF Template Properties
      • XPT Template Properties
      • PDF Template Properties
      • Excel Template Properties
      • CSV Output Properties
      • Excel 2007 Output Properties
      • EText Output Properties
      • All Outputs Properties
      • Memory Guard Properties
      • Data Model Properties
      • Define Font Mappings
        • Make Fonts Available for Publishing
        • Set Font Mapping at the Site Level or Report Level
        • Create a Font Map
        • Predefined Fonts
      • Define Currency Formats
        • Understand Currency Formats
    • Apply a Digital Signature in PDF Documents
      • About Digital Signature on a PDF Document
      • Prerequisites and Limitations
      • Obtain Digital Certificates
      • Create PFX Files
      • Apply a Digital Signature
        • Register Your Digital Signature and Assign Authorized Roles
        • Specify the Signature Display Field or Location
        • Specify a Template Field in a PDF Template for the Digital Signature
        • Specify the Location for the Digital Signature in the Report Properties
      • Run and Sign Reports with a Digital Signature
    • Audit Reports and Catalog Objects
      • About Audit of Reports and Catalog Objects
      • Enable Audit of Reports and Catalog Objects
      • Specify the Data Source for Audit
      • View Audit Data
    • Add Translations for the Catalog and Reports
      • Introduction
        • Limitations of Catalog Translation
      • Export and Import a Catalog Translation File
      • Template Translation
        • Generate the XLIFF File from the Layout Properties Page
        • Translate the XLIFF File
        • Upload the Translated XLIFF File to Oracle BI Publisher
      • Use a Localized Template
        • Design the Localized Template File
        • Upload the Localized Template to Oracle BI Publisher
• Part V Reference
• A Frequently Asked Questions
  • Top FAQs to Model Data
  • Top FAQs to Manage Oracle Analytics Cloud
• B Troubleshoot
  • Troubleshoot General Issues
  • Troubleshoot Data Modeling Issues
  • Troubleshoot Administration Issues
• C Expression Editor Reference
  • Data Model Objects
  • SQL Operators
  • Conditional Expressions
  • 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
  • Variables