Table of Contents

• Title and Copyright Information
• Abstract
• Preface
  • Audience
  • Related Documentation
  • Conventions
• 1 Get Started with Oracle NetSuite Analytics Warehouse
  • About Oracle NetSuite Analytics Warehouse
  • Region Availability
  • Language Support
  • About the Autonomous AI Lakehouse Tools
  • Enable Single Sign-On
  • Disable Single Sign-On
  • Preview Features
    • Make Preview Features Available
  • Generally Available Features
    • Enable Generally Available Features
  • Third Party Data Connectors
  • Configure Advanced Options
    • About Advanced Configuration
    • Set Advanced Options
  • Create Additional NetSuite Connections
  • Typical Workflow to Get Started with Oracle NetSuite Analytics Warehouse
• 2 Configure Oracle NetSuite Analytics Warehouse Data
  • Typical Workflow to Configure Data
  • About Transaction Entities
  • About Data Pipelines for Functional Areas
    • Allowed Actions for Data Pipelines
  • About Data Refresh Performance
  • About Pipeline Parameters
  • Set Up the Pipeline Parameters
  • About Reporting Configurations
    • About the Reporting Configuration for NetSuite Analytics Warehouse
    • Set Up the Reporting Configurations
  • Create a Data Pipeline for a Functional Area
  • Edit a Data Pipeline for a Functional Area
  • Activate a Data Pipeline for a Functional Area
  • Activate Value-added Datasets
  • Deactivate a Data Pipeline for a Functional Area
  • Delete a Data Pipeline for a Functional Area
  • Refresh a Data Pipeline for a Functional Area
  • Reload Data for a Data Pipeline
  • Reset the Data Warehouse
  • Reset the Cache
  • View Request History
    • About Request Types and Statuses
  • View the Audit Log
  • View the Data Pipeline Status
  • About Augmenting Your Data
    • Augment Your Data
  • Create a Dimension Alias
  • Connect to an Autonomous AI Lakehouse
    • Configure Autonomous AI Lakehouse Credentials
      • About Autonomous Data Warehouse Wallet and Administrator Credentials
      • Reset the ADMIN User Password
      • Download the Autonomous AI Lakehouse Wallet
      • Rotate the Wallet for the Oracle Autonomous AI Lakehouse
        • About Wallet Rotation for the Oracle Autonomous AI Lakehouse
      • Get the Database Actions URL
      • Reset the OAX_USER Password
    • Connect to an Autonomous AI Lakehouse with Database Actions (SQL Developer Web)
      • Query Tables for NetSuite Analytics Warehouse from Autonomous AI Lakehouse as OAX_USER
      • Query the Autonomous AI Lakehouse System Tables as ADMIN
    • Connect to an Autonomous AI Lakehouse with Oracle Analytics Cloud
      • Configure the Connection for OAX_USER in Oracle Analytics Cloud
      • Create an Oracle Analytics Cloud Dataset
    • Connect to an Autonomous AI Lakehouse with SQL Developer Desktop Client
      • Configure the Connection to Autonomous AI Lakehouse for ADMIN with SQL Developer Desktop Client
      • Configure the Connection to Autonomous AI Lakehouse for OAX_USER with SQL Developer Desktop Client
  • Disable and Enable the Data Pipeline
  • Manage Data Connections
    • Connect With On-premises Sources
      • Set up the Remote Agent to Load Data into NetSuite Analytics Warehouse (Preview)
        • Perform Remote Agent Connection Prerequisites
        • Configure TLS for Remote Agent Configuration (Optional)
        • Run the Remote Agent Docker on Windows
        • Configure the Remote Agent Using the Command Line Interface Tool on Windows
        • Run the Remote Agent Docker on Linux
        • Configure the Remote Agent Using the Command Line Interface Tool on Linux
        • Create the Remote Agent Connection
      • Load Data from On-premises E-Business Suite into NetSuite Analytics Warehouse (Preview)
      • Load Data from On-premises JD Edwards into NetSuite Analytics Warehouse (Preview)
      • Load Data from On-premises PeopleSoft into NetSuite Analytics Warehouse (Preview)
      • Load Data from On-premises MySQL Database into NetSuite Analytics Warehouse (Preview)
      • Load Data from SQL Server into Oracle NetSuite Analytics Warehouse (Preview)
      • Load Data from Oracle Database Using JDBC into NetSuite Analytics Warehouse (Preview)
    • Connect with Cloud File Storage Sources
      • About OpenCSV Standards
      • About Date and Timestamp Formatting for CSV File-based Extractors
      • File Layout Modes
      • Load Data from Amazon Simple Storage Service into Oracle NetSuite Analytics Warehouse (Preview)
      • Load Data from Oracle Object Storage Service into NetSuite Analytics Warehouse
      • Load Data from an SFTP Source into NetSuite Analytics Warehouse (Preview)
      • Load Data from Azure Storage into Oracle NetSuite Analytics Warehouse (Preview)
    • Connect With Cloud Sources
      • Create Additional NetSuite Connections
      • Load Data from Azure SQL into Oracle NetSuite Analytics Warehouse (Preview)
      • Connect with Your Oracle Eloqua Data Source (Preview)
        • Load Data from Your Oracle Eloqua Data Source (Preview)
      • Load Data from Oracle Enterprise Data Management Cloud into NetSuite Analytics Warehouse (Preview)
      • Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM) (Preview)
        • About NetSuite Analytics Warehouse EPM Integrator
        • Prerequisites for NetSuite Analytics Warehouse EPM Integrator Configuration
        • Enable NetSuite Analytics Warehouse EPM Integrator
        • Create a Oracle NetSuite Analytics Warehouse EPM Integrator Connection
        • Update a NetSuite Analytics Warehouse EPM Integrator Connection
        • Define EPM Data Extracts in the Oracle NetSuite Analytics Warehouse EPM Integrator
        • Recommendations and Tips for Using EPM Integrator
        • Frequently Asked Questions for Loading Data from Oracle Enterprise Performance Management
      • Load Data from Oracle Enterprise Performance Management into NetSuite Analytics Warehouse (Preview)
      • Load Data from EPM Export Data Instance into NetSuite Analytics Warehouse (Preview)
      • Load Data from Oracle Autonomous Database into Oracle NetSuite Analytics Warehouse (Preview)
      • Load Data from Fusion Supply Chain Planning into Oracle NetSuite Analytics Warehouse (Preview)
      • Load Data from Google Analytics into Oracle NetSuite Analytics Warehouse
      • Load Data from MongoDB into NetSuite Analytics Warehouse (Preview)
      • Load Data from MySQL Cloud Database into NetSuite Analytics Warehouse (Preview)
      • Load Data from Salesforce into NetSuite Analytics Warehouse
      • Load Data from Shopify into NetSuite Analytics Warehouse
      • Load Data from QuickBooks Online into Oracle NetSuite Analytics Warehouse (Preview)
      • Load Data from Snowflake into Oracle NetSuite Analytics Warehouse (Preview)
      • Load Data from Taleo into NetSuite Analytics Warehouse (Preview)
  • Schedule Data Maintenance
  • Schedule Frequent Data Refreshes for Functional Areas
    • About Scheduling Frequent Data Refreshes
      • Frequent Data Refresh Scenarios
      • Performance Considerations for Frequent Data Refresh
    • Schedule Frequent Refreshes of Data with Redesigned Refresh Mechanism (Preview)
      • About Scheduling Frequent Data Refreshes Using a New Refresh Mechanism (Preview)
        • Frequent Data Refresh Delta Tables and Lambda View Details (Preview)
        • Frequent Data Refresh Module and Table Statuses (Preview)
        • Frequent Data Refresh Upgrade Considerations (Preview)
      • Upgrade to Frequent Data Refresh V2 (Preview)
      • Configure Frequent Data Refresh V2 (Preview)
      • Enable Frequent Data Refresh Modules for Fusion Accounting Hub (Preview)
    • Schedule Frequent Refreshes of Data with Original Refresh Mechanism
      • Configure Frequent Data Refresh with Original Refresh Mechanism
  • Schedule Reload of Data
  • Schedule Frequent Refreshes of Warehouse Tables (Preview)
  • Override Data Pipeline Schedules for Functional Areas (Preview)
  • Prioritize Datasets for Incremental Refresh (Preview)
  • Reset and Reload the Data Source
  • Extend Data with Data Applications
    • About Extending Data with Data Applications
    • Use Data Applications to Extend Data
      • Extend Data with Netsuite Account Analysis
        • Prerequisites for Setting up Netsuite Account Analysis
        • Enable Netsuite Account Analysis
        • Set up Netsuite Account Analysis
        • Use Case: Customize the Netsuite Account Analysis Insights Subject Area
      • Extend Data with Custom Data Applications
    • Edit a Data Application
    • Delete a Data Application
    • Perform an Ad hoc Refresh of a Data Application
    • Reload Data for a Data Application
    • Undeploy a Data Application
  • Predict Outcomes Early
    • Predict Customer Churn
    • Predict Stockout for Inventory Items
  • View the Warehouse Refresh Statistics
    • Example Table Details
• 3 Manage Users, Groups, Application Roles, and Data Access
  • About Managing Users, Groups, Application Roles, and Data Access
    • About Users
    • About Groups
      • System Groups
      • Other Groups
    • About Application Roles
      • Duty Roles
    • Licensed Roles
      • System Roles
    • About Data Access Through Security Assignments
  • Manage Users
    • About Password Policy for Users Created in Oracle NetSuite Analytics Warehouse
    • Create Users
    • License the Users to Access Oracle NetSuite Analytics Warehouse
    • Add Security Assignments to a User
    • Remove Security Assignments Granted to a User
    • Copy Data Security Assignments
  • Manage Groups
    • Add Application Roles to a Group
    • Copy Application Roles to a Group
    • Remove Application Roles from 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
    • Download Security Configuration
  • 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
    • Download and Upload Data Security Exclusion Rules
  • Configure Permissions for Metadata and Front-End Objects
  • View Activity History
  • Create an Application Role While Mapping
• 4 Customize Oracle NetSuite Analytics Warehouse
  • About Semantic Model Customization
  • Recommendations and Tips to Extend the Semantic Model
  • Extend the Semantic Model Using the Sandbox Framework
    • Apply System Extensions
    • Manage Your Sandbox
      • Create a Sandbox
      • Manage a Logical Star
        • Create a Logical Star
          • Manage Facts
          • Manage Dimensions
          • Manage Extensions
        • Edit a Logical Star
        • Manage Hierarchies
        • Replace the Referenced Database Object
      • Manage Subject Areas
        • Create Subject Area
        • Modify Subject Area
      • Delete a Sandbox
      • Manage Variables
        • Create Variable
        • Modify Variable
    • Prepare Your Sandbox
      • Validate Sandbox and View Validation Report
      • Synchronize Customization Sandbox with Main Sandbox
      • Resolve Sandbox Errors
      • Apply Changes
    • Prepare Your Model
      • Validate Model
    • Integrate Your Sandbox
      • Merge Customization Sandbox to Main Sandbox and Publish
      • Merge Customization Sandbox to Main Sandbox
      • Publish Model
    • Generate and Download the Sandbox Report
  • Extend the Semantic Model Using the Branch Framework
    • Migrate to the Sandbox Framework for Semantic Model Extensions
      • Perform the Pre-Migration Tasks
      • Validate the Main Branch
      • Deploy Validated Branch to Production
      • Schedule the Migration
      • Perform the Post Migration Verifications
      • Revert to the Branch Framework for Semantic Model Extensions
  • Add Security Configurations
    • Configure Object Permissions
  • View Activity History of Semantic Model Extensions
  • Move Your Customizations to Another Environment
    • Republish Your Customizations
  • Map the Custom Attributes
    • Map Custom Attributes
  • Manage Frequently Refreshed Data in the Workbooks
    • Automatic Availability of Frequently Refreshed Data in the Semantic Model
    • Manual Addition of Frequently Refreshed Data in the Semantic Model
    • Examples of Enabling and Using Frequently Refreshed Data in the Semantic Model
  • Generate and Download a Security Report
• 5 Manage Oracle NetSuite Analytics Warehouse
  • About Application Updates
    • Update Your Application
    • View Release Update Activity
    • Reset Content
  • Bundle Your Application Artifacts
    • About Bundles
      • What’s Available In Bundles
    • Create a Bundle
      • Create a Content Bundle
      • Create a Data Config Bundle
      • Create a Semantic Model Bundle
      • Create a Security Bundle
      • Create an Environment Bundle
      • Create a Composite Bundle
      • Create an Application Bundle
    • Edit a Bundle
    • Publish a Bundle
    • Deploy a Bundle
    • Export a Bundle
    • Import a Bundle
    • Delete a Bundle
    • View the Activity History of Bundles
    • Share Bundles
      • About the Bundle Repository
      • Publish a Bundle to the Repository
      • Import a Shared Bundle
      • Deploy a Shared Bundle
  • Configure a Virus Scanner
  • Back Up and Restore
    • Strategies for Backing up and Restoring Oracle Cloud Infrastructure Identity and Access Management
    • Strategies for Backing up and Restoring Oracle Analytics Cloud
    • Strategies for Backing Up and Restoring Oracle Autonomous AI Lakehouse
    • Automated Backup for Oracle Autonomous AI Lakehouse
    • Custom Backup for Oracle Autonomous AI Lakehouse
• 6 Use AI capabilities in Oracle NetSuite Analytics Warehouse
  • Access AI Concierge (Preview)
    • Perform the Prerequisites for Using AI Concierge
    • AI Concierge for Administrators
    • Live Information Queries
    • Sample Queries
    • Tips for Optimal Usage of AI Concierge
    • Extend Entities with DA Script
    • DA Script Code Assistant
    • DA Script Tutor
    • AI Concierge for Semantic Model Extensions
    • AI Concierge for Consumers
• 7 Integrate Third-Party Data
  • About Data Pipeline Options to Extract and Load
  • About Data Mashup and Transformation Options
  • Outline the Scope and Prepare the Warehouse for the Data
  • Load Data into the Warehouse
  • Mash Up NetSuite Data with Third-Party Data
• A Resolve Common Errors in Semantic Model Extensions
• B Top FAQs for Frequent Data Refresh
  • FAQs for Scheduling Frequent Data Refresh V2
  • FAQs for Managing Frequent Data Refresh V2
• C Troubleshoot Subscription Update Failure