Spreadsheet Add-in User's Guide for Excel

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 sampleMicrosoft Excel 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.