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

Table of Contents

Purpose

Audience
Document Structure
Sample Databases and Files
Online Help
Conventions

Introducing Release 6

Migrating to Release 6
What's New in Release 6

Introducing Hyperion Essbase

Typical Users of Hyperion Essbase
Components of the Client-Server Environment
The Server
Hyperion Essbase Spreadsheet Add-in
The Network
Hyperion Essbase Application Products
Hyperion Essbase Spreadsheet Toolkit
Hyperion Essbase Partitioning Option
Hyperion Essbase Structured Query Language Interface
Hyperion Essbase Application Programming Interface
Hyperion Essbase Currency Conversion
Hyperion Integration Server
Hyperion Objects
Hyperion Web Gateway
The Multidimensional Database
Definition of Multidimensional
Database Outlines
Dimensions
Members
Attributes
Formulas
Aliases
Consolidations

A Basic Hyperion EssbaseTutorial

Getting Acquainted with Hyperion Essbase Spreadsheet Add-in
Adding Hyperion Essbase Spreadsheet Add-in
Starting Hyperion Essbase Spreadsheet Add-in
Accessing Online Help
Enabling Mouse Actions
Preparing to Begin the Tutorial
Setting Hyperion Essbase Options
Following Guidelines During the Tutorial
Reviewing the Sample Basic Database
Retrieving Data
Connecting to a Database
Changing a Password
Retrieving Data from a Database
Canceling a Data Retrieval Request
Restoring the Previous Database View
Drilling Down to More Detail
Drilling Up to Less Detail
Customizing Drill-Down and Drill-Up Behavior
Pivoting, Retaining, and Suppressing Data
Pivoting Rows and Columns
Retaining a Data Subset
Removing a Data Subset
Navigating Through the Worksheet Without Retrieving Data
Suppressing Missing Values, Zero Values, and Underscore Characters
Formatting the Worksheet
Formatting Text and Cells
Displaying Aliases for Member Names
Displaying Both Member Names and Aliases
Repeating Member Labels
Creating Queries Using Hyperion Essbase Query Designer
Creating and Changing Queries
Creating Queries
Deleting Queries
Viewing Messages and Confirmations
Accessing Help
Connecting to Multiple Databases from Hyperion Essbase Query Designer
Applying Worksheet Options to Hyperion Essbase Query Designer Results
Selecting Members
Saving and Disconnecting
Saving a Worksheet
Disconnecting from Hyperion Essbase
Logging Off
Moving on to Advanced Tasks

An Advanced Hyperion Essbase Tutorial

Preparing to Begin the Tutorial
Connecting to a Database
Setting Hyperion Essbase Options
Performing Advanced Retrieval Tasks
Filtering Data
Sorting Data
Retrieving Data into Asymmetric Reports
Working with Formatted Worksheets
Preserving Formulas When Retrieving Data
Retrieving a Range of Data
Retrieving Data by Using a Function
Retrieving Dynamic Calculation Members
Specifying the Latest Time Period for Dynamic Time Series
Using Free-Form Reporting to Retrieve Data
Using Linked Reporting Objects
Linking a File to a Data Cell
Linking a Cell Note to a Data Cell
Linking a URL to a Data Cell
Accessing and Editing Linked Reporting Objects
Connecting to Multiple Databases
Viewing Active Database Connections
Accessing Linked Partitions
Updating Data on the Server
Calculating a Database
Creating Multiple Worksheets from Data
Working with Currency Conversions
Retrieving Currency Conversion Data
Connecting to the Sample Currency Databases
Performing Ad Hoc Currency Reporting

Using Hyperion Integration Server Drill-Through

What Is Drill-Through?
What Is the Drill-Through Wizard?
Before You Start
Setting Hyperion Essbase Options
About the Samples Used in This Tutorial
Using Drill-Through
Accessing Drill-Through from the Spreadsheet
Selecting Drill-Through Reports to View or Customize
Selecting and Ordering Columns
Ordering Data
Filtering Data
Disconnecting from Hyperion Essbase

Appendix A. Using the DB2 Library

DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online

Index

Notices

Trademarks

Contacting IBM

Product Information