OLAP Spreadsheet Add-in User's Guide for Excel

Purpose

This guide provides all the information that you need to use Hyperion Essbase Spreadsheet Add-in for Microsoft Excel. It explains the features and options and discusses the concepts, processes, procedures, formats, tasks, and examples that you need to use the software.

Hyperion Essbase is an online analytical processing (OLAP) solution that satisfies the complex calculation requirements of financial, accounting, and marketing professionals. Hyperion Essbase operates in a client-server computing environment on a local area network (LAN) . In this environment, multiple users can use their desktop computers to retrieve and analyze centralized data.

You can create reports from the data residing on Hyperion Essbase OLAP Server in several ways:

• Generate database reports through a spreadsheet interface, called Hyperion Essbase Spreadsheet Add-in, as explained in this guide.
• Use Hyperion Essbase Application Manager Report Writer to create a report script and run a report. For more information, see the Hyperion Essbase Database Administrator's Guide.
• Use Hyperion Essbase Application Programming Interface (API) to create and run database reports. For more information, see the Hyperion Essbase online API Reference.
• Use reporting tools, such as Hyperion Reporting for Hyperion Essbase.