Essbase Command Summary

Table 1 describes the commands found on the Essbase menu in alphabetical order, the corresponding toolbar icon, and the keyboard shortcut for the command.

For example, to retrieve data using the keyboard shortcut for the Retrieve command, press and hold down the Alt, s, and r keys simultaneously.

See the Oracle Essbase Spreadsheet Add-in User's Guide to find out how to install and view the Essbase toolbar.

Table 1. Essbase Commands

Toolbar IconCommandDescriptionKeyboard Shortcut
 

Calculation

Enables you to calculate the active database or check on the status of an active database calculation.

Opens the Essbase Calculation dialog box.

Alt + s + c

 

Cascade

Enables you to replicate worksheets using member combinations.

Opens the Essbase Cascade Options dialog box.

Note:

You can create cascade reports based on attribute members.

Alt + s + d

Connect to an Essbase OLAP Server icon.

Connect

Enables you to connect to an instance of Essbase Server.

Opens the Essbase System Login dialog box.

Alt + s + n

 

Currency Report

Enables you to perform ad hoc currency conversions during data retrieval.

Opens the Essbase Currency Report dialog box.

If your organization implemented a Currency Conversion application, you can use the Currency Report command to perform currency retrievals and conversions dynamically.

Alt + s + y

 

Disconnect

Enables you to disconnect from the currently connected database.

Opens the Essbase Disconnect dialog box, which displays all databases to which you are currently connected.

Alt + s + t

Undo the last Retrieval, Zoom, or Pivot action icon.

FlashBack

Restores the previous view.

Alt + s + b

Retain data only for the selected members icon.

Keep Only

Retains only the selected member (the active cell) or member range in the worksheet.

All unselected members are removed from the worksheet.

Alt + s + k

Invoke the Linked Objects Browser icon.

Linked Objects

Enables you to create or access linked objects and displays the objects currently linked to the selected data cell.

Opens the Linked Objects Browser dialog box.

Note:

You cannot create linked objects for member combinations containing attributes.

Alt + s + j

 

Lock

Locks all data blocks in the current view (that is, all data blocks that appear in the current worksheet). You can lock only one view at a time.

The lock and send processes use committed access modes. If your data cache is too small to hold the number of blocks specified in your commit settings, blocks are written to disk before the transaction is committed as soon as the caches become full. This allows other blocks to come in and be worked on. Each lock (one lock per block) uses approximately 80 bytes of memory to track through a calculation, and these locks are held in memory until the transaction is completed. This memory usage can present problems for models with large number of blocks as the addressable memory space per process is limited and large models may eventually hit this limit.

Alt + s + l

Browse the database outline and select members icon.

Member Selection

Enables you to select members from the multidimensional database outline.

Opens the Essbase Member Selection dialog box.

Note:

Member selection supports selecting attributes so that you can display them in the spreadsheet report.

Alt + s + m

Navigate with or wthout data icon.

Navigate With or Without Data

Enables you to perform navigational operations such as Pivot, Zoom In, Zoom Out, Keep Only, and Remove Only without retrieving data. A check mark next to the command indicates that this feature is turned on. This command serves the same function as selecting Navigate Without Data in the Essbase Options dialog box.

Alt + s + g

Modify how Essbase displays data and interacts with  your session icon.

Options

Enables you to select options for the active worksheet and customize the behavior of Spreadsheet Add-in.

Opens the Essbase Options dialog box.

Note:

You cannot save spreadsheet settings to a protected worksheet.

Alt + s + p

 

Pivot

Enables you to change the orientation of your data. Use Pivot to:

  • Move a row group to a column group.

  • Move a column group to a row group.

  • Transpose the order of row groups.

  • Transpose the order of column groups.

When you select the Pivot command, Essbase changes the orientation (from row to column or from column to row) of the group of members associated with the active cell.

You can also press and hold the secondary mouse button and drag the member you want to pivot to the destination cell. In addition to changing member orientation, this enables you to switch the position of row or column members with one another.

Tip:

To enable secondary mouse button support, select Essbase, and then Options. On the Global page, select the Enable Secondary Button option.

Alt + s + v

Design a query through the Query Designer icon.

Query Designer

Enables you to easily create queries and reports using a powerful interface. You can define the page orientation of dimensions and members, perform member filtering, data filtering, and data sorting. You can save queries for later use.

Alt + s + q

Remove data only for the selected members icon.

Remove Only

Removes the selected member (the active cell) or member range in the worksheet. When you select Remove Only, all unselected members are retained in the worksheet.

Alt + s + o

Retrieve data based on the current view icon.

Retrieve

Retrieves data into the active worksheet. Retrieve places the data at the beginning of the active worksheet.

When you select Retrieve, the Essbase System Login dialog box is displayed if you are not connected to the server.

Tip:

If your mouse actions are enabled, you can retrieve data by double-clicking the primary mouse button in an empty cell in the worksheet. To enable double-clicking mouse button support, select Essbase, and then Options. On the Global page, select the Enable Double-Clicking option.

Alt + s + r

 

Retrieve & Lock

Locks the data blocks specified in the retrieval. Other users cannot update these blocks.

Note:

Spreadsheets containing Dynamic Time Series members are not supported with the Retrieve & Lock command.

Alt + s + e

 

Sample Data (Zoom In)

Enables sampling in Spreadsheet Add-in. Sampling allows you to zoom in on a "sample" of your data, making for more rapid queries. When sampling is enabled, the approximate sampling percentage indicated in the Essbase Options Dialog Box - Zoom page is applied to Zoom In operations.

Alt + s + a

 

Send

Updates the active database on the server with data in your worksheet.

The lock and send processes use committed access modes. If your data cache is too small to hold the number of blocks specified in your commit settings, blocks are written to disk before the transaction is committed as soon as the caches become full. This allows other blocks to come in and be worked on. Each lock (one lock per block) uses approximately 80 bytes of memory to track through a calculation, and these locks are held in memory until the transaction is completed. This memory usage can present problems for models with large number of blocks as the addressable memory space per process is limited and large models may eventually hit this limit.

Alt + s + s

 

Unlock

Unlocks blocks that you locked.

Alt + s + u

 

Visualize & Explore

Enables you to access Oracle Essbase Visual Explorer, where you can select members from an Essbase database and display them in a graphical format.

See the Visual Explorer online help that is accessed from the Help menu Visual Explorer.

Alt + s + x

Retrieve data for the children of the selected members icon.

Zoom In

Retrieves and expands data from Essbase Server according to the options specified in the Essbase Options dialog box (Zoom page).

If you mouse actions are enabled, you can zoom in on data by double-clicking the primary mouse button in the cell that contains the member you want to expand. To enable double-clicking mouse button support, select Essbase, and then Options. On the Global page, select the Enable Double-Clicking option.

You cannot zoom in on a Dynamic Time Series member.

If your spreadsheet has spaces between rows and you drill down on a member, Essbase mirrors the spaces in the resulting report.

Alt + s + i

Retrieve data for the parent of the selected member icon.

Zoom Out

Collapses the view according to the options specified in the Essbase Options dialog box (Zoom page).

If you mouse actions are enabled, you can zoom out by double-clicking the secondary mouse button in the cell that contains the member you want to collapse. To enable double-clicking mouse button support, select Essbase, and then Options. On the Global page, and select the Enable Double-Clicking option.

You cannot zoom in on a Dynamic Time Series member.

Alt + s + z