Essbase Overview
- Multidimensional Analysis
- Oracle’s Enterprise Performance Management System
- Oracle BI Foundation Suite
- Essbase
- Production Environment Components
Designing Applications And Databases
- Essbase Implementation Process
- Analyzing and Planning Implementations
- Creating Applications and Databases
- Creating Outlines
Designing Data Descriptor Dimensions
- Data Descriptor Dimensions Overview
- Designing Time Dimensions
- Designing Scenario Dimensions
- Designing Accounts Dimensions
Optimizing Data Descriptor Dimensions
- Creating Member Aliases
- Dimension Types
- Creating Period-to-Date Totals
- Dynamic Calc Members
- Enhancing Accounts Dimensions
Loading Data
- Data Load Overview
- Creating Data Load Rules Files
- Selecting and Rejecting Records
- Capturing New Members
Creating Basic Dimension Build Rules Files
- Rules Files Overview
- Creating Dimension Build Rules Files
- Configuring Dimension Maintenance Settings
Creating Advanced Dimension Build Rules Files
- Advanced Dimension Build Rules Files Overview
- Creating Shared Members
- Manipulating Fields
- Creating User-Defined Attributes
- Creating Attribute Dimensions with Rules Files
Getting Started With Smart View
- Navigating Smart View
- Connecting to Data Sources
- Creating Ad Hoc Grids
- Setting the Point of View
- Associating Data Sources with Worksheets
- Creating Free-Form Grids
Creating Reports With Smart View
- Updating Essbase Data
- Integrating Essbase Data with Microsoft Office
- Creating Shared Database Perspectives
- Creating Custom Reports
Data Storage And Calculation
- Calculation Overview
- Database Calculation Order
- Data Block Fundamentals
- Data Blocks and the Index System
- Interpreting Database Statistics
- Data Block Creation
- Database Calculation Process
Controlling The Calculation Process
- Focusing Calculations with FIX Statements
- Calculating Conditionally with IF Statements
Copying And Clearing Data
- Copying Data
- Clearing Data with CLEARDATA
- Clearing Data with CLEARBLOCK
Creating Calculation Scripts
- Calculation Script Organization
- Returning Correct Calculation Results
- Troubleshooting CALC DIM Processes
Referencing Members In Calculations
- Referencing Members Explicitly
- Referencing Members Dynamically
- Creating Calculation Variables
Creating Attribute Dimensions
- Attribute Dimensions Overview
- Adding Attribute Dimensions to Outlines
- Design Considerations
Analyzing Varying Attributes
- Varying Attributes Overview
- Creating Varying Attributes
- Viewing Varying Attribute Data
Analyzing Text And Dates
- Typed Measures Overview
- Enabling Typed Measures
- Creating Text Measures
- Creating Date Measures
- Viewing Typed Measures
- Calculations Based on Typed Measures
Partitioning Overview
Creating Database Partitions
- Designing partitions
- Creating partitions
- Evaluating partition designs
Creating Essbase Security Filters
- The Essbase Security Filter Layer
- Creating Security Filters
- Filter Behavior
- Resolving Security Conflicts
Essbase Security Overview
- Essbase Native Security
- Global Access Security Layer
- User and Group Security Layer
- Application Access Type Security
- The Essbase Security File
Securing The Essbase Environment In Shared Services
- Shared Services Security
- Converting Essbase Users to Shared Services Security
- Provisioning Users in Shared Services
- External Authentication and Single Sign-on
Optimizing Block Storage Caches
- Optimizing the Database
- Optimizing Caches
- Setting RAM Caches
- Cache Hit Ratios
Managing Fragmentation
- Measuring Database Fragmentation
- Preventing and Reducing Database Fragmentation
- Removing Security File Fragmentation
Backing Up, Restoring, And Recovering Essbase Databases
- About Backup, Restore, and Recovery
- Manual Backup and Restore
- Automated Backup and Restore
- Manual Recovery
- Automated Recovery
- Recovering from a Server Interruption
- Recovering Corrupted Essbase Databases
Task Automation
- Automating Tasks Using MaxL
- The MaxL Command Shell
- MaxL Statements and Syntax
