Table of Contents

• Title and Copyright Information
• Accessibility and Support
• 1 Access Oracle Essbase
  • New Features in the Essbase Web Interface
    • Quick Access to Open a Cube, Open an Outline, or Analyze Data
    • Bookmark an Active Browser Tab for Quick Access
    • Open Artifacts in a New Browser Tab or in an Editor
  • Essbase, REST, and Smart View Client URLs
  • Set Up Your Client
  • Set Up Your Ask Essbase
    • Overview of Ask Essbase
    • Configure Ask Essbase
  • Set Up AI Query for Essbase
• 2 Manage Essbase Applications
  • Create an Application and a Database using the Essbase web interface
  • Set Application-Level Configuration Properties
• 3 Manage Essbase Cubes
  • Create an Essbase Cube
  • Write and Edit Scripts
  • Create Calculation Scripts
  • Report on Data
    • Create Report Scripts
    • Execute Report Scripts
• 4 Understand Your Access Permissions in Essbase
  • User Role
    • Database Access Permission
    • Database Update Permission
    • Database Manager Permission
    • Application Manager Permission
  • Power User Role
  • Service Administrator Role
  • Filter Access to Data
    • Create a Filter using the Essbase web interface
    • Create Efficient Dynamic Filters
      • Dynamic Filter Syntax
      • Workflow to Create Dynamic Filters
      • Example of a Dynamic Filter
• 5 Manage Essbase Files and Artifacts
  • Explore the Essbase Files Catalog
  • Explore the Gallery Templates
    • Applications Templates
    • Technical Templates
    • System Performance Templates
  • Access Files and Artifacts
  • Explore the Application Directories
  • Work with Files and Artifacts
  • Specify Files in a Catalog Path
• 6 Create and Manage Cube Outlines Using the Web Interface
  • View and Edit Outline Properties for a Newly Created Cube
    • Work with General and Attribute-related Outline Properties
    • Understand and Create Alias Tables
    • Understand and Work with Dynamic Time Series Outline Properties
    • Understand and Create Textual Measures
  • Add Dimensions and Members to Outlines
    • Add Dimensions to Outlines Manually
    • Add Members to Outlines Manually
  • Name Generations and Levels
  • Restructure Cubes
  • Create Attribute Dimensions and Members
  • About Duplicate Member Names
  • Set Dimension and Member Properties
    • Open the Outline in Edit Mode
    • Set Member Properties while in Edit Mode
    • Set Properties in the Member Inspector
    • Set General Properties
    • Create Aliases
    • Create Member Formulas
    • Set Attribute Associations
    • Create User-Defined Attributes
  • Select the Member Properties to Display in the Outline
  • Compare Outlines
  • Copy and Paste Members Within and Between Outlines
• 7 Manage Application and Cube Artifacts and Settings
  • Set Calculation-Related Cube Properties
  • Unlock Objects
  • Remove Data Locks
  • Set Buffer Sizes to Optimize Reports
  • Understand Transaction Semantics in Essbase
  • Manage an Application Using EAS Lite in the Essbase Web Interface
• 8 Run and Manage Jobs Using the Web Interface
  • View Job Status and Details
  • Execute Jobs
    • Build Aggregations
    • Clear Aggregations
    • Export to Table Format
    • Run Calculation
    • Build Dimension
    • Clear Data
    • Export Data
    • Export Excel
    • Export LCM
    • Import LCM
    • Load Data
    • Run MDX
    • Vectorize Outline
• 9 Work with Connections and Datasources
  • Create an Application-Level Connection and Datasource
  • Create a Global Connection and Datasource
  • Create a Connection and Datasource for a File
  • Create a Connection and Datasource to Access Another Cube
  • Create a Connection and Datasource to Access Oracle Database
  • Create a Connection and Datasource for Autonomous Data Warehouse
  • Create Connections and Datasources for Generic JDBC Drivers
  • More Connection Examples for Generic JDBC Drivers
  • Implement Parameters for Datasources
    • Set a Default Parameter in a Datasource
    • Use Substitution Variables in a Datasource
  • Build Dimensions and Load Data
  • Create a GenAI Connection
• 10 Analyze Data in the Web Interface
  • Perform Ad Hoc Analysis in the Web Interface
  • Work with Layouts
    • Access to Layouts
  • Analyze and Manage Data with MDX
    • Analyze Data with MDX Reports
      • Access to MDX Reports
      • Examples of MDX Reports
    • Insert and Export Data with MDX
    • Run MDX Scripts
      • Write, Upload, and Run an MDX Script
      • Write an MDX Script in the Script Editor and Run It
      • Create an MDX Script in Cube Designer and Run it
      • Guidelines for MDX Scripts
      • Examples of MDX Scripts
  • Access External Data with Drill Through Reports
    • Introduction to Essbase Drill Through
      • Drill Through Terminology
      • Workflow for Drill Through Report Design
      • How Drill Through Works
      • Drill Through Report Definition
      • Drill Through Use Case Example
    • Access to Drill Through Reports
    • Design Drill Through Reports
      • General Considerations for Designing Drill Through Reports
      • Define Column Mappings for Drill Through Reports
      • Define Drillable Regions for Drill Through Reports
      • Implement Parameters for Drill Through Reports
    • Test Drill Through Reports
    • Drill Through to a URL
    • Drill Through from Multiple Cells
    • Debug Drill Through using Essbase Server Platform Log
• 11 Calculate Cubes
  • Access to Calculations
  • Create Calculation Scripts
  • Execute Calculations
  • Use Substitution Variables
  • Set Two-Pass Calculation Properties
  • Trace Calculations
  • Calculate Selected Tuples
    • Use Case for Tuple Calculation
    • Understand Tuple-Based Calculation
    • Select Tuples for Point of View Calculation
    • Examples of Tuple Selection to Reduce Calculation Scope
      • No Tuple Selection
      • Selection of Named Sparse Dimensions
      • Selection of Contextual Sparse Dimensions
• 12 Model Data in Private Scenarios
  • Understand Scenarios
    • View and Work with Scenario Data
      • View and Work With Scenario Data From the Essbase Web Interface
      • View and Work With Scenario Data From a Smart View Private Connection
    • About Scenario Calculations
    • About Data Loads to Scenario-enabled Cubes
    • About Data Exports from Scenario-enabled Cubes
    • About Transparent and Replicated Partitions in Scenario-enabled Cubes
    • About @XREF/@XWRITE in Scenario-enabled Cubes
    • About Audit Trail in Scenario-enabled Cubes
    • About Scenario Limitations
  • Enable Scenario Modeling
    • Create a Scenario-Enabled Cube
    • Create a Scenario-Enabled Sample Cube
    • Enable an Existing Cube for Scenario Management
    • Create Additional Sandbox Members
  • Scenario Workflow
    • Enable Email Notifications for Scenario Status Changes
    • Create a Scenario
    • Model Data
    • Submit a Scenario for Approval
    • Approve or Reject Scenario Changes
    • Apply Data Changes
    • Copy a Scenario
    • Delete the Scenario
    • Understand Scenario User Roles and Workflow
  • Work with Scenarios
    • View Base Member Data
    • Compare Scenario Values to Base Values
    • Set Scenario Cells to #Missing
    • Revert Scenario Values Back to Base Values
    • Understand When to Aggregate Sandbox Dimensions
      • Example: Calculate Scenarios with Dynamic Upper Level Members
      • Example: Calculate Scenarios with Stored Upper Level Members
• 13 Audit Data, Security, Artifact Changes, and LCM Events
  • Track Data Changes
    • Turn on Data Audit Trail and View the Data Audit Trail
    • Link a Reporting Object to a Cell
    • Export Logs to a Sheet
    • Refresh the Audit Log
    • View and Manage Audit Trail Data in the Essbase Web Interface
  • Audit Security, Artifact Changes, and LCM Events
    • Workflow to Enable Security Auditing for Essbase Server
    • About the Auditing Policy File
    • Security Auditing Events
• 14 Link Cubes Using Partitions or @XREF/@XWRITE
  • Define a Reusable Connection for Partitions or Location Aliases
  • Understand Transparent and Replicated Partitions
  • Create a Transparent Partition
  • Create a Replicated Partition
  • Refresh a Replicated Partition
  • Export and Import Transparent and Replicated Partitions
  • Understand @XREF/@XWRITE
  • Create a Location Alias
• 15 Federated Cubes: Integrate Essbase with Autonomous AI Database
  • Prerequisites for Federated Cubes
  • Federated Cube Deployment Workflow
  • Provision Autonomous AI Lakehouse for Federated Cubes
  • Deploy Essbase from Marketplace for Federated Cubes
  • Create a Schema for Federated Cubes
  • Identify the Pivot Dimension and Set up the Fact Table
    • Identify the Pivot Dimension
    • Create the Fact Table
  • Create a Connection for Federated Cubes
  • Set up Credentials for Federated Cubes
  • Create a Federated Partition
  • Data Load Options for Federated Cubes
  • Calculate and Query Federated Cubes
  • Federated Cube Maintenance and Troubleshooting
    • Model and Test Federated Cubes
    • Metadata Precautions for Federated Cubes
    • Cancel Long Running SQL on Federated Cubes
    • What to Do if the Database Connection Details Changed
    • Back up and Restore a Federated Cube
  • Remove a Federated Partition
  • Differences between Aggregate Storage, Block Storage, and Federated Cubes
  • Restrictions for Federated Cubes
• 16 Configure Oracle Essbase
  • Set Provider Services Configuration Properties
• 17 Download Utilities and Perform Tasks in the Console
  • Access Tools and Tasks from the Console
  • Enable Antivirus Scanning in Essbase
• 18 Use Logs and View Notifications
  • Download Application Logs
  • About Performance Analyzer
    • Enable Performance Analyzer and Choose Settings
    • Understand and Work With Performance Analyzer Data
  • View and Manage Notifications in the Essbase Web Interface
• A Centralized Smart View URL, and Read-Only Clusters
  • Access Multiple Essbase Servers Using a Centralized Smart View URL
  • Configure and Manage Active-Active (Read-Only) Essbase Clusters
  • Access Multiple Essbase Servers in EPM Shared Services