Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documentation
  • Conventions
• 1 Get Started with Oracle Fusion Analytics Warehouse
  • About Oracle Fusion Analytics Warehouse
    • Region Availability
    • About Oracle Fusion Analytics Warehouse Releases
    • About Oracle Fusion Analytics Warehouse Service Level Objective
    • About Oracle Fusion Analytics Warehouse Components
      • Oracle Fusion Analytics Warehouse Console
    • Comparison of Capabilities between Analytics Cloud Associated with Fusion Analytics Warehouse and Standalone Analytics Cloud
    • Usage Guidelines for Autonomous Data Warehouse Associated with Fusion Analytics Warehouse
    • Preview Features
      • Features Available for Preview
    • Generally Available Features
      • Features Generally Available
  • Prerequisites for Oracle Fusion Analytics Warehouse
  • Typical Workflow to Administer Oracle Fusion Analytics Warehouse
  • Activate Your Oracle Fusion Analytics Warehouse Subscription
    • About Activating Your Oracle Fusion Analytics Warehouse Subscription
    • Activate the Universal Credits Subscription
    • Activate the Oracle Fusion Analytics Warehouse Subscription
  • Before You Begin with Oracle Fusion Analytics Warehouse
  • Sign In to the Oracle Cloud Infrastructure Console
  • Access Your Service
  • Add Users with Administrator Permissions
  • Add an Oracle Cloud Infrastructure Identity and Access Management Policy
  • Create a User in Oracle Fusion Cloud Applications to Extract Data
• 2 Set Up Oracle Fusion Analytics Warehouse
  • Typical Workflow to Set Up Oracle Fusion Analytics Warehouse
  • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On
    • About Setting Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On
    • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On in Scenario #1
      • Set Up Provisioning with Single Sign-On
        • Copy and Store the Oracle Identity Cloud Service URL
        • Set Up Synchronization of Oracle Fusion Cloud Applications with Oracle Identity Cloud Service
        • Federate the Oracle Identity Cloud Service Instance to Your Oracle Cloud Infrastructure Tenancy
        • Sign in to Oracle Cloud Infrastructure using the Federated Oracle Identity Cloud Service Instance
    • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On in Scenario #2
    • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On in Scenario #3
    • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On in Scenario #4
      • Copy and Store Details of the Identity Domain
      • Federate the Identity Domain to Your Oracle Cloud Infrastructure Tenancy
      • Sign in to Oracle Cloud Infrastructure using the Federated Identity Domain
      • Synchronize Users from Your Oracle Fusion Cloud Applications Instance with the Identity Domain
    • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On in Scenario #5
      • Configure Single Sign-on Between Oracle Identity Cloud Service and Identity Domain
        • Add an SAML Application
        • Copy Details from the Identity Domain Metadata File
        • Configure the SAML Application
    • Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On in Scenario #6
      • Configure Single Sign-on Between Two Identity Domains
        • Add an SAML Application
        • Copy Details from the Identity Domain Metadata File
        • Configure the SAML Application
  • Create an Oracle Fusion Analytics Warehouse Instance
    • About Creating an Instance
    • Create an Oracle Fusion Analytics Warehouse Subscription Instance
      • Enter Details for an Oracle Fusion Analytics Warehouse Subscription Instance
      • Verify Your Instance and Sign In
    • Create an Integrated Oracle Fusion Analytics Warehouse Instance
  • Deploy Oracle Fusion Analytics Warehouse with a Private Endpoint
    • About Private Endpoints
    • Prerequisites for a Private Endpoint
    • Create an Oracle Fusion Analytics Warehouse Private Instance
  • Make Preview Features Available
  • Enable Generally Available Features
  • View Work Requests
  • Update the Data Source Connection Details
  • Update Your Subscriptions
  • Update the Administrator Password for Oracle Autonomous Data Warehouse
  • Reset the Password for OAX_USER and Custom Schemas
  • Terminate Instances
  • Move the Oracle Fusion Analytics Warehouse Instance to Another Compartment
  • Update the Notification Email
  • Scale Up Oracle Autonomous Data Warehouse Storage
  • Scale Up Oracle Analytics Cloud Capacity
  • Configure Advanced Options
    • About Advanced Configuration
      • Performance and Compatibility Options
      • Preview Options
    • Set Advanced Options
• 3 Configure Oracle Fusion Analytics Warehouse Data
  • Typical Workflow to Configure Data
  • About Data Pipelines for Functional Areas
    • Allowed Actions for Data Pipelines
  • About Data Refresh Performance
  • About Pipeline Parameters
  • Set Up the Pipeline Parameters
  • Create a Data Pipeline for a Functional Area
  • Edit a Data Pipeline for a Functional Area
  • Activate a Data Pipeline for a Functional Area
  • About Global Parameters
  • Set Up the Global Report Parameters
  • About Reporting Configurations
    • About the Reporting Configuration for Enterprise Resource Planning
    • About the Reporting Configuration for Human Capital Management
  • Set Up the Reporting Configurations for Enterprise Resource Planning
  • Set Up the Reporting Configurations for Human Capital Management
  • Deactivate a Data Pipeline for a Functional Area
  • Delete a Data Pipeline for a Functional Area
  • Refresh a Data Pipeline for a Functional Area
  • Reset a Data Pipeline for a Functional Area
  • Reset the Data Warehouse
  • Reset the Cache
  • View Load Request History
    • About Request Types and Statuses
  • View the Audit Log
  • View Records Rejected in Extraction
  • Prioritize Datasets for Incremental Refresh (Preview)
  • About Augmenting Your Data
    • Augment Your Data
      • Create Dimension Augmentation Type
      • Create Fact Augmentation Type
      • Extend an Entity
  • Create a Dimension Alias
  • About Managing Data Connections
    • Create a Data Connection Type
    • Edit a Data Connection Type
    • Delete a Data Connection Type
    • Create a Data Connection
    • Test a Data Connection
    • Update a Data Connection
    • Delete a Data Connection
    • Load Data from a Remote Agent into Fusion Analytics Warehouse (Preview)
    • Load Data from On-premises E-Business Suite into Fusion Analytics Warehouse (Preview)
    • Connect with Your Oracle Eloqua Data Source
      • Load Data from Your Oracle Eloqua Data Source
    • Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview)
    • Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview)
    • Load Data from Google Analytics into Fusion Analytics Warehouse (Preview)
    • Load Data from Salesforce into Fusion Analytics Warehouse (Preview)
    • Load the Bureau of Labor Statistics Data into Fusion Analytics Warehouse (Preview)
    • Load Data from Shopify into Fusion Analytics Warehouse (Preview)
    • Load Data from a Secure FTP Source into Fusion Analytics Warehouse (Preview)
    • Load Data from Oracle Autonomous Database into Oracle Fusion Analytics Warehouse (Preview)
    • Load Data from Oracle Object Storage into Fusion Analytics Warehouse (Preview)
    • Load Data from On-premises JD Edwards into Fusion Analytics Warehouse (Preview)
    • Load Data from Amazon Simple Storage Service into Oracle Fusion Analytics Warehouse (Preview)
    • Load Data from Snowflake into Oracle Fusion Analytics Warehouse (Preview)
    • Load Data from Taleo into Fusion Analytics Warehouse (Preview)
  • Disable Data Pipeline
  • Schedule Frequent Refreshes of Functional Area Data
  • Schedule Periodic Full Reload of Functional Area Data
  • Extend Data with Custom Data Configurations
    • About Extending Data with Custom Data Configurations
      • About Extending Data with the Descriptive Flex Fields Attribute Mapper
    • Select Descriptive Flex Fields and Map Attributes
    • Activate the Descriptive Flex Fields
    • Deactivate the Descriptive Flex Fields
• 4 Validate Oracle Fusion Analytics Warehouse Data
  • About Validating Your Data
    • Prerequisites for Data Validation
  • Create a User to Validate the Extracted Data
  • Create a Custom BI Abstract Role
  • Validate Your Data
• 5 Manage Users, Groups, Application Roles, and Data Access
  • About Managing Users, Groups, Application Roles, and Data Access
    • About Users
    • About Groups
      • System Groups
      • Job-Specific Groups
        • Common Job-Specific Groups
      • Other Groups
    • About Application Roles
      • Duty Roles
        • Common Duty Roles
      • Data Roles
      • System Roles
    • About Data Access through Security Assignments
  • Typical Workflow to Manage Users, Groups, Application Roles, and Data Access
  • Manage Users
    • Create Users
      • Synchronize Users from Your Oracle Fusion Cloud Applications Instance
      • Create Users in Oracle Identity Cloud Service
      • Create Users in Oracle Fusion Analytics Warehouse
    • License the Users to Access Oracle Fusion Analytics Warehouse
    • Update the User Details
    • Remove a User’s Access to Oracle Fusion Analytics Warehouse
    • Automatically Assign Licensed Groups to Users
    • Assign Groups to Users
    • Remove Groups Assigned to a User
    • Add Security Assignments to a User
    • Remove Security Assignments Granted to a User
    • Copy Data Security Assignments
    • View the Excluded Data Security Assignments
  • Manage Groups
    • Create a Group
    • Remove a Group
    • Add Application Roles to a Group
    • Copy Application Roles to a Group
    • Remove Application Roles from a Group
    • Create an Application Role While Mapping
    • Assign Users to a Group
    • Upload and Download User Group Mappings
    • Remove Users from a Group
    • Copy User Mappings to a Group
  • Manage Application Roles
    • Create an Application Role
    • Delete an Application Role
    • Assign Groups to Application Roles
    • Remove a Group Mapped to an Application Role
  • Manage Data Access through Security Assignments
    • Create a Security Assignment
    • Delete a Security Assignment
    • Remove Users from a Security Assignment
    • Manage Users for a Security Assignment
    • Set Exclusion Rules for Security Assignments
    • Update Security Assignments Automatically
  • Configure Permissions for Metadata and Front-End Objects
  • View Activity History
  • Manage Uploads and Downloads
    • About Uploading and Downloading Your Data
    • Upload and Download Data Security Assignments
      • Security Object Tables
    • Upload and Download Financial Categories
    • Upload and Download Financial Category Assignments
    • Upload and Download User Group Mappings
    • Download and Upload Area of Responsibility Data
    • Download and Upload Data Security Exclusion Rules
    • Download and Upload Custom Job Roles Mappings
  • Set Up Custom Security
• 6 Customize Oracle Fusion Analytics Warehouse
  • About Semantic Model Customization
  • About Best Practices and Tips to Extend the Semantic Model
  • Create a Branch
  • Edit a Branch
  • Add a Step to a Branch
    • Add a Dimension
    • Add a Fact Table
    • Add a Hierarchy
    • Add Session Variables
    • Extend a Dimension
    • Add Derived Columns
    • Create a Subject Area
    • Modify a Subject Area
  • Edit or Delete a Branch Step
  • Reapply a Branch Step
  • Disable and Enable the Disabled Steps
  • Copy Steps from One Branch to Another
  • View Details of Failed Branch Steps
  • Merge the Customization Branches with the Main Branch
  • Reorder Steps of Customization Branches
  • Delete a Main Branch Step
  • Tag the Main Branch's Steps
  • Add Security Configurations
    • Configure Data Security
    • Configure Object Permissions
  • View Activity History of Semantic Model Extensions
  • Publish the Model
  • Load Customization Data to the Autonomous Data Warehouse
  • Promote Your Customizations to the Production Environment
  • View Promotion History
  • Republish Your Customizations
• 7 Manage Oracle Fusion Analytics Warehouse
  • Manage Application Updates
    • About Application Updates
    • Update Your Application
  • Bundle Your Application Artifacts
    • About Bundles
    • Create a Bundle
    • Edit a Bundle
    • Publish a Bundle
    • Export a Bundle
    • Import a Bundle
    • Deploy a Bundle
    • Delete a Bundle
    • View Activity History of Bundles
  • Configure a Virus Scanner
  • About Backup and Restore
  • About Disaster Recovery
• 8 Frequently Asked Questions
  • Top FAQs for Activation
  • Top FAQs for Instance Creation
  • Top FAQs for Data Configuration
  • Top FAQs for Security Setup
  • Top FAQs for Customization and Data Augmentation
  • Top FAQs for Managing Oracle Fusion Analytics Warehouse
• 9 Troubleshooting