Essbase - Spreadsheet Add-in

Essbase Overview


Spreadsheet Add-in integrates Essbase with Microsoft Excel.

Spreadsheet Add-in adds the Essbase menu to Excel, which provides enhanced commands such as :

  • Connect,
  • Pivot,
  • Drill-down,
  • and Calculate.

Users can access and analyze data on Essbase - Servers with mouse clicks and dragging operations. Spreadsheet Add-in enables multiple users to access and update data on an Essbase Server simultaneously.

Spreadsheet Queries

Within Spreadsheet Add-in, users can create and save queries using Query Designer (EQD) in Essbase - Spreadsheet Queries artifact files. Users with access to the query can access it later.

Member Select Definitions

Within Spreadsheet Add-in, users can define and save member retrievals with the member select feature in a Member Select Definitions files.

Excel Add-in

In Excel 2007, start button > excel options:

Essbase Add In Excel

Documentation / Reference

Discover More
Administration Services Architecture
Essbase - Administration Services Console

Administration Services Console is the common graphical user interface (GUI) of that enables administrators to manage the Essbase environment from one navigation tree, called . essbase studio The console...
Essbase Architecture Overview
Essbase - Architecture/Components

Figure below provides a high-level view of the information flow between the three tiers of the Essbase architecture : (on the left) (in the center) (on the right) The client tier includes...
Essbase Overview
Essbase - Clients

The client tier of the are : for Office, Fusion Edition, , Fusion Edition. an MDX query, or Report Writer. You can install them separately of the server installation....
Essbase Overview
Essbase - Database (cube)

An Essbase database is a data repository that contains a multidimensional data storage array. Essbase Database is also commonly referred to as cube (as in Essbase Studio console) Files that are related...
Outline For Optimized Query Times
Essbase - Designing an Outline to Optimize Query or Calculations Performance

The relative locations of dimensions in an outline can affect performance times : either or retrieval . Indeed, although they contain the same dimensions, the outline examples below : for Optimized...
Essbase Client
Essbase - How to install the Essbase Client Software ?

To install the following client (console) software: Just follow the same guideline that the normal installation but choose only the client tiers as shown in the next picture.
Essbase Overview
Essbase - Spreadsheet Queries artifact

Spreadsheet Queries is an artifact created with . Users can create and save queries using Query Designer (EQD). Users with access to the query can access it later. Query files created using Query Designer...
Essbase Overview
Essbase - Substitution variables

Substitution variables are global placeholders for regularly changing information. Because changes to a variable value are reflected everywhere the variable is used, manual changes are reduced. For...
Essbase Overview
Essbase - Visual Explorer

Oracle Essbase Visual Explorer provides a query and analysis interface for creating interactive summaries and reports the data in an Essbase Database. You can choose to visualize data in various graphical...
Essbase Overview
Member Select Definitions

is an created with . Users can define and save retrievals with the member select feature. Member specification files have a .sel extension.

Share this page:
Follow us:
Task Runner