OLAP Spreadsheet Add-in User's Guide for Excel

Components of the Client-Server Environment

Client-server computing refers to the architecture in which individual PC workstations are connected to a powerful server by means of a local area network (LAN). The PC workstation acts as a client by requesting data from the server. The server processes the request and returns the desired result to the client.

Hyperion Essbase is built as a client-server system. System performance and multiuser capabilities are greatly enhanced in the Hyperion Essbase client-server environment.

The Server

Hyperion Essbase OLAP Server is a multidimensional database that supports analysis of an unlimited number of data dimensions and an unlimited number of members within these dimensions. Developed using a true client-server architecture, all data, the database outline, the calculations, and the data security controls reside on the Hyperion Essbase server.

The Hyperion Essbase server operates on Windows 95, Windows 98, Windows NT, and UNIX operating systems.

Hyperion Essbase Spreadsheet Add-in

Hyperion Essbase Spreadsheet Add-in is a software program that merges seamlessly with Microsoft Excel and Lotus 1-2-3. After Hyperion Essbase is installed, a special menu is added to Excel. The menu provides enhanced commands such as Connect, Pivot, Drill-down, and Calculate. Users can access and analyze data on the Hyperion Essbase server by using simple mouse clicks and drag-and-drop operations. Hyperion Essbase Spreadsheet Add-in enables multiple users to access and update data on the Hyperion Essbase server simultaneously.

The Network

Hyperion Essbase runs on PC-based LANs that support the Named Pipes or TCP/IP protocol.
Note:Supported network environments and technical requirements are discussed in detail in the Hyperion Essbase Installation Guide, which is included with the Hyperion Essbase OLAP Server package.


[ Top of Page | Previous Page | Next Page ]