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

An Advanced Essbase Tutorial

The tutorial you completed in "A Basic Essbase Tutorial" teaches basic data retrieval and navigation concepts for Essbase Spreadsheet Add-in. This chapter builds on your basic skills and expands your knowledge of Essbase and 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 sample Lotus 1-2-3 files that were installed as part of the default Essbase installation. These files are stored in the \Essbase\client\sample directory. You also reconnect to the Sample Basic database.