Course Content
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
- Outline Calculations
- Designing Accounts Dimensions
- Testing Outline Calculations
Optimizing Data Descriptor Dimensions
- Creating Member Aliases
- Dimension Types
- Creating Period-to-Date Totals
- Dynamic Calc Members
- Enhancing Accounts Dimensions
- Optimizing Data Storage
Developing Dimension Designs
- Business View Dimensions Overview
- Attributes in Database Design
- Combining Business Views
- Developing Label Outlines
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
- Top-Down Calculation
- Focusing Calculations with FIX Statements
- Calculating Conditionally with IF Statements
- Performance Considerations
Referencing Members in Calculations
- Referencing Members Explicitly
- Referencing Members Dynamically
- Creating Calculation Variables
Developing and Testing Complex Calculation Scripts
- Implementing a Script Development Process
- Upper-Level Data Loads
- Intelligent Calculation
Normalizing Data
- Allocating Data
- Planning Data Normalization
- Normalizing Rates and Drivers
- Copying and Clearing Data
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