Hyperion - Essabase


Chapter 1. Essbase Commands and Options

Lessons
  • Essbase Menu and Toolbar
  • Setting Essbase Options

Chapter 2. Hooking Up to the Server

Lessons
  • Essbase Security and Default Retrievals
  • Connecting to More than One Database

Chapter 3. Getting Data into the Spreadsheet

Lessons
  • Two Ways to Retrieve Data
  • Templates
  • The Legal Spreadsheet
  • Range Retrievals
  • Essbase Blind to Objects
  • Flashback and Terminology

Chapter 4. Nifty Navigation

Lessons
  • General Points about Zooming
  • Zooming In
  • Zooming Out and Drag and Fill Using Menu Commands
  • Zooming and Drag and Fill Using the Mouse
  • Using the Alt Key to Zoom In Across the Sheet

Chapter 5. Member Selection and Increasing Navigation Speed

Lessons
  • Essbase Member Selection Functionality, Part 1
  • Essbase Member Selection Functionality, Part 2
  • Essbase Member Selection Functionality, Part 3
  • Navigate Without Data (NWD)

Chapter 6. Set Course for Driving through the Data, Essbase Options

Lessons
  • Zoom Options, Part 1
  • Zoom Options, Part 2
  • Indentation and Cells Options
  • Automatic Column Widths
  • Aliases Options
  • Global Options
  • Mouse Work
  • Flashback
  • Message Display Options
  • Applying Styles, Order of Precedence, Part 1
  • Applying Styles, Order of Precedence, Part 2

Chapter 7. Updating the Database

Lessons
  • Using Locking
  • Preserving Formulas

Chapter 7 Checkpoint: Challenge Exercise

Exercises and Demos
  • Using the Lock and Send Functionality
  • Excel Formulas and Essbase Retrieves

Chapter 8. Linked Object Browser

Lessons
  • Introducing the Linked Object Browser
  • Linked Objects Browser Exercise, Part 1
  • Linked Objects Browser Exercise, Part 2
Exercises and Demos
  • Linked Objects, part 1
  • Linked Objects, part 2

Chapter 9. Calculating Data

Lessons
  • Basic Essbase Calculation

Chapter 10. Generating Many Reports At One Time

Lessons
  • Generating Many Reports at One Time

Quick Contact