Title and Copyright Information
Accessibility and Support
1 Access Oracle Essbase
- Access Tools and Tasks from the Console
- Essbase, REST, and Smart View Client URLs
- Set Up Your Client
2 Top Tasks for Oracle Essbase
- Download the Sample Dynamic Application Workbook and Examine Its Structure
- Create an Application in the Essbase Web Interface and Provision a User to Access and Query the Cube
- Analyze an Application in Smart View
- Modify an Essbase Outline
- Analyze Forecast Data in Smart View
- Create an Application and Cube in Cube Designer
- Analyze Data and Perform an Incremental Update in Cube Designer
  - Analyze Data in the Sample Basic Cube
  - Perform an Incremental Update on the Sample Basic Cube
- Transform Tabular Data into a Cube
- Export and Modify Metadata and Data
3 Manage Essbase Files and Artifacts
- Explore the Files Catalog
- Explore the Gallery Templates
- Access Files and Artifacts
- Explore the Application Directories
- Work with Files and Artifacts
- Specify Files in a Catalog Path
4 Understand Your Access Permissions in Essbase
- User Role
- Power User Role
- Service Administrator Role
- About Filters
  - Create Filters
  - Create Efficient Dynamic Filters
5 Design and Create Cubes Using Application Workbooks
- About Application Workbooks
- Download a Sample Application Workbook
- Create a Cube from an Application Workbook
- Export a Cube to an Application Workbook
- Connect to a Cube in Smart View
6 Design and Manage Cubes from Tabular Data
- Transform Tabular Data to Cubes
  - Use Intrinsic Headers to Transform Tabular Data to Cubes
  - Use Forced Designation Headers to Transform Tabular Data Into Cubes
- Create and Update a Cube from Tabular Data
- Export a Cube to Tabular Data
7 Manage Application and Cube Artifacts and Settings
- Set Advanced 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 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
9 Calculate Cubes
- Access to Calculations
- Create Calculation Scripts
- Execute Calculations
- Use Substitution Variables
- Set Two-Pass Calculation Properties
- Trace Calculations
- Calculate Selected Tuples
10 Run and Manage Jobs Using the Web Interface
- View Job Status and Details
- Execute Jobs
11 Create and Manage Cube Outlines Using the Web Interface
- View and Edit Outline Properties for a Newly Created Cube
- Create a Sample Cube to Explore Outline Properties
  - Set Outline Properties in your Sample Cube
- 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
- Select the Member Properties to Display in the Outline
- Compare Outlines
- Copy and Paste Members Within and Between Outlines
12 Model Data in Private Scenarios
- Understand Scenarios
- Enable Scenario Modeling
- Scenario Workflow
- Work with Scenarios
13 Hybrid Mode for Fast Analytic Processing
- Benefits of Hybrid Mode
- Comparison of Hybrid Mode, Block Storage, and Aggregate Storage
- Get Started with Hybrid Mode
- Optimize the Cube for Hybrid Mode
- Limitations and Exceptions to Hybrid Mode
- Solve Order in Hybrid Mode
14 Work with Cubes in Cube Designer
- About Cube Designer
- Manage Files in Cube Designer
- Download Sample Application Workbooks
- Build a Private Inventory of Application Workbooks
- Work with Application Workbooks in Cube Designer
- Load Data in Cube Designer
  - Load Block Storage Data in Cube Designer
  - Load Aggregate Storage Data in Cube Designer
- Calculate Cubes in Cube Designer
- Create a Federated Partition in Cube Designer
- Work with Jobs in Cube Designer
- View Dimension Hierarchies in Cube Designer
- Perform Cube Administration Tasks in Cube Designer
15 Optimize Cubes Using Cube Designer
- Create Optimized Hybrid Mode Cubes
- Create Optimized Aggregate Storage Cubes
  - Optimize Baseline Metrics on an Aggregate Storage Cube
  - Optimize the Solve Order on an Aggregate Storage Cube
16 Audit Data, Security, Artifact Changes, and LCM Events
- Track Data Changes
- Audit Security, Artifact Changes, and LCM Events
17 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
- Understand @XREF/@XWRITE
- Create a Location Alias
18 Integrate Essbase with Autonomous Database Using Federated Partitions
- Prerequisites for Federated Partitions
- Federated Partitions Workflow
- Provision Autonomous Data Warehouse for Federated Partitions
- Deploy Essbase from Marketplace for Federated Partitions
- Create a Schema for Federated Partitions
- Set Up Fact Table and Identify Pivot Dimension
  - Create the Fact Table
  - Identify the Pivot Dimension
- Create a Connection for Federated Partitions
- Create a Federated Partition
- Federated Partition Data Load
- Calculate and Query Federated Partition Cubes
- Federated Partition Cube Maintenance and Troubleshooting
- Remove a Federated Partition
- Restrictions for Federated Partitions
19 Configure Oracle Essbase
- Set Application-Level Configuration Properties
- Set Provider Services Configuration Properties
- Enable Antivirus Scanning in Essbase
20 Essbase Command-Line Interface (CLI)
- Download and Use the Command-Line Interface
- CLI Command Reference
21 Manage Essbase Using the MaxL Client
- Prerequisites to Set Up the MaxL Client
- Download and Use the MaxL Client
22 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
23 Report on Data
- Create Report Scripts
- Execute Report Scripts
24 Access External Data with Drill Through Reports
- Introduction to Essbase Drill Through
- Access to Drill Through Reports
- Design 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
25 Use Logs to Monitor Performance
- Download Application Logs
- About Performance Analyzer
  - Enable Performance Analyzer and Choose Settings
  - Understand and Work With Performance Analyzer Data
A Application Workbooks Reference
- Understand the Essbase.Cube Worksheet
- Understand the Cube.Settings Worksheet
- Understand the Cube.Generations Worksheet
- Understand the Cube.FederatedPartition Worksheet
- Understand the Cube.TypedMeasures Worksheet
- Understand Dimension Worksheets
- Understand Data Worksheets
- Understand Calculation Worksheets
- Understand MDX Worksheets
B Set up Cube Designer
- Workflow to Set up Cube Designer
- Download and Run the Smart View Installer
- Connect to Essbase
- Install the Smart View Cube Designer Extension
- Update the Smart View Cube Designer Extension
- Delete Smart View Connection URLs
C 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