OLAP Spreadsheet Add-in User's Guide for 1-2-3

An Advanced Hyperion Essbase Tutorial

The tutorial you completed in A Basic Hyperion EssbaseTutorial teaches basic data retrieval and navigation concepts for Hyperion Essbase Spreadsheet Add-in. This chapter builds on your basic skills and expands your knowledge of Hyperion Essbase and Hyperion Essbase Spreadsheet Add-in.

This chapter provides the following sections on advanced tasks:

• Preparing to Begin the Tutorial
• Performing Advanced Retrieval Tasks
• Using Linked Reporting Objects
• Connecting to Multiple Databases
• Accessing Linked Partitions
• Updating Data on the Server
• Calculating a Database
• Creating Multiple Worksheets from Data
• Working with Currency Conversions

In this advanced tutorial, you use several sampleMicrosoft ExcelLotus 1-2-3 files that were installed as part of the default Hyperion Essbase installation. These files are stored in the \essbase\client\sample directory. You also reconnect to the Sample Basic database.