Any idea on ... Essbase Client ?

Essbase Client
The following Essbase clients access the server:

Essbase Spreadsheet Add-in, which provides you with seamless data access to the server.
Essbase Application Manager, which you can use to design, develop, and maintain Essbase Applications.
ESSCMD, a command-line interface, which you can use to perform operations interactively or through a batch or script file.
A custom application built with the Essbase Application Programming Interface (API). The API Reference in your docs directory provides a complete listing of Essbase API functions, platforms, and supported compilers.


Essbase clients retrieve and analyze data from the server using Lotus 1-2-3, Microsoft Excel, or a custom application interface.

Tell me about the Essbase Products & Family?

About the Essbase Product Family

The Essbase product family includes the following feature sets:

Essbase Administration Services:
Essbase Administration Services is the new framework for managing and maintaining Essbase. Essbase Administration Services consists of a client console and a middle tier server that communicate directly with Essbase OLAP Servers. Both of these components can run on any platform supported by Essbase.

Essbase Application Manager :
The Application Manager is a graphical environment for developing and maintaining Essbase applications on a single OLAP Server. Tasks include building outlines and dimensions, performing data loads and calculations, and defining security access.


Essbase OLAP Server:
A multidimensional database for storing data with an unlimited number of dimensions such as time, accounts, region, channel, or product. The Essbase server manages analytical data models, data storage, calculations, and data security.

Essbase Spreadsheet Add-in :
The Spreadsheet Add-in desktop software enables analysis of the data stored in the Essbase server. Essbase Spreadsheet Add-in is seamlessly integrated with Microsoft Excel or Lotus 1-2-3 spreadsheets.

Essbase application tools :
This suite of tools is used for extending Essbase applications. These tools include Essbase currency conversion, Essbase SQL Interface, Essbase Spreadsheet Toolkit, and Essbase Application Programming Interface.

Essbase Partitioning :
This suite of features makes it easy to design and administer databases that span Essbase applications or servers. You can copy a slice of a large database to work with locally, or you can link from your database directly to other databases.

Can you please give me a brief introduction to Hyperion Essbase - Calculation Command Overview ?

Calculation scripts are used to define calculations that differ from those defined in the Database Outline. Calculation scripts, as described in the Database Administrator's Guide, can calculate either all or part of a database, rather than the whole-database calculation required by the outline.

Calculation commands are defined within a calculation script to instruct Analytic Services in the exact calculation rules to be used. The Calculation Script Editor is used to create a script. Within the Editor, a dialog box is available that allows you to paste functions while you develop formulas. For more information, see the Database Administrator's Guide.
When a database is created, an internal default calculation script is set to "calculate all", which means that it will calculate all dimensions based on the database outline's hierarchical relationships and formulas.

You can over-ride this default script at any time by using a custom script. You can over-ride the default script either on a temporary or permanent basis, without actually altering the default script. In the custom calc script, you can refer to calculation rules defined in the database outline or you can specify entirely new formulas, calculation formats, and calculation orders.
A calculation script contains a series of calculation commands. The order of the commands defines the execution order of the calculation.

About Me

P John, M.Sc(C.C), CCNA, RHCE , Consultant- Product Support, Hyperion Essbase.

Followers