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
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
Loading
Data
- Data Load Overview
- Creating Data Load Rules Files
- Selecting and Rejecting Records
- Capturing New Members
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
Creating
Calculation Scripts
- Calculation Script Organization
- Returning Correct Calculation Results
- Troubleshooting CALC DIM Processes
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
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
Creating Database Partitions
- Designing partitions
- Creating partitions
- Evaluating partition designs
Essbase
Security Overview
- Essbase Native Security
- Global Access Security Layer
- User and Group Security Layer
- Application Access Type Security
- The Essbase Security File
Creating
Essbase Security Filters
- The Essbase Security Filter Layer
- Creating Security Filters
- Filter Behavior
- Resolving Security Conflicts
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
Aggregate
Storage Overview
- Aggregate storage key characteristics and design considerations
- Understanding the aggregate storage production cycle
- Creating aggregate storage outline hierarchies
Loading
Data
- Understanding the aggregate storage data loading process
- Using data load buffers
- Loading data incrementally
Aggregating
Data
- Understanding the data aggregation process
- Optimizing aggregations
Managing
Aggregate Storage Databases
- Managing table spaces
- Exporting aggregate storage data
- Optimizing data compression
- Managing storage caches
- Optimizing outline paging
- Understanding disk space management options
- Backing up aggregate storage applications
- Viewing database statistics
Creating
Basic MDX Queries
- MDX Overview
- MDX Queries
- MDX Query Structure
- MDX Comments
- Selecting Multiple Members
