OLAP Spreadsheet Add-in User's Guide for Excel

Document Structure

The main sections of this guide are structured as tutorials that take you step-by-step through basic and advanced tasks in Hyperion Essbase Spreadsheet Add-in. This document contains the following information:

• Introducing Release 6"Introducing Release 6" on page 17 provides information on migrating from previous versions of Hyperion Essbase to Release 6 and lists all new features and enhancements.
• Introducing Hyperion Essbase"Chapter 2. Introducing Hyperion Essbase" introduces you to basic concepts of retrieving and manipulating data through the spreadsheet interface.
• A Basic Hyperion EssbaseTutorial"Chapter 3. A Basic Hyperion Essbase Tutorial" provides a step-by-step tutorial of basic data navigation, ad hoc retrieval, and reporting techniques.
• An Advanced Hyperion Essbase Tutorial"Chapter 4. An Advanced Hyperion Essbase Tutorial" describes advanced reporting and retrieval techniques for users that need special reports or formatted data views.
• Using Hyperion Integration Server Drill-Through"Chapter 5. Using Hyperion Integration Server Drill-Through" provides a brief overview of the Hyperion Integration Server Drill-Through product.
• The Indexcontains a list of terms and their page numbers. Select or look up an index entry to view the page to which the entry refers.

Note:

The Hyperion Essbase Spreadsheet Add-in online help provides a comprehensive section on Hyperion Essbase Spreadsheet Toolkit. This section enables you to customize and automate your use of Hyperion Essbase by using Excel macros and Visual Basic for Applications (VBA) functions. For more information on the Hyperion Essbase Spreadsheet Add-in online help, see Chapter 2, "Accessing Online Help."

The Spreadsheet Add-in User's Guide for Excel is provided in the \essbase\docs\client directory in .pdf format for online viewing and printing in Adobe^(R) Acrobat Reader^(R) (Release 4 or higher). The .pdffile is named Essexcel.pdf. You can download Adobe Acrobat Reader from the Hyperion Essbase CD-ROM or from http://www.adobe.com. On the Hyperion Essbase CD-ROM, the Acrobat Reader executable file is located in the Adobe directory under the appropriate platform and language-version subdirectories. To install Adobe Acrobat Reader, launch the executable file, follow the prompts, and provide the information requested.

Sample Databases and Files

This book provides tutorial steps that are based on sample databases and files that are provided with the Hyperion Essbase server software. You use the Sample Basic database for most tasks in A Basic Hyperion EssbaseTutorial"Chapter 3. A Basic Hyperion Essbase Tutorial" and An Advanced Hyperion Essbase Tutorial"Chapter 4. An Advanced Hyperion Essbase Tutorial". You use a sample Hyperion Essbase Currency Conversion application for the section on currency conversion. See An Advanced Hyperion Essbase Tutorial"Chapter 4. An Advanced Hyperion Essbase Tutorial" For information on the Sample Basic database, see A Basic Hyperion EssbaseTutorial"Chapter 3. A Basic Hyperion Essbase Tutorial"

In addition to these sample applications and databases, you also use several sample Excel files in the advanced tutorial in An Advanced Hyperion Essbase Tutorial"Chapter 4. An Advanced Hyperion Essbase Tutorial". The individual at your organization who installs the server is responsible for making these applications, databases, and files available to you. Contact the Hyperion Essbase system administrator for more information.