ESSBASE Online Training

essbase online training


  • Production Environment Components

Designing Applications and Databases

  • Block Storage Implementation Process
  • and Aggregate storage Implementation Process
  • Analyzing and Planning Implementations
  • Creating Applications and Databases
  • Creating Outline Structures
  • Modifying Member Properties

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

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

Loading Data

  • Data Load Overview
  • Creating Data Load Rules Files
  • Selecting and Rejecting Records
  • Capturing New Members

Getting Started with Smart View

  • Smart View Overview
  • Configuring Data Sources
  • Creating Ad Hoc Reports
  • Setting the Point of View

Creating Reports with Smart View

  • Manipulating Multidimensional Data
  • Updating Essbase Data
  • Integrating Essbase Data with Microsoft Office
  • Customizing the User Experience

Data Storage and Calculation

  • Calculation Overview
  • Database Calculation Order
  • Data Block Fundamentals
  • Data Blocks and the Index System
  • Database Statistics
  • Data Block Creation
  • Database Calculation Process

Creating Calculation Scripts

  • Calculation Script Organization
  • Returning Correct Calculation Results
  • Controlling the Calculation Process
  • Focusing Calculations with FIX Statements
  • Calculating Conditionally with IF Statements
  • Comparing FIX and IF Calculation Processes

Referencing Members in Calculations

  • Referencing Members Explicitly
  • Referencing Members Dynamically
  • Creating Calculation Variables


Report Scripts

Maxl Scripts

Hyperion essbase Infra