Essbase Command Summary

Table 1 describes the commands available from the Essbase menu and toolbar.

Note:

Closing Excel using the Close icon on the upper-right of the Excel window causes the Essbase menu to disappear and deactivates Spreadsheet Add-in. If you then cancel the close, you cannot access Spreadsheet Add-in. You must close and reopen Excel in order to reactivate Spreadsheet Add-in and the Essbase menu.

Table 1. Essbase Commands

Toolbar Icon	Command	Description
	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 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.
	Keep Only	Retains only the selected member (the active cell) or member range in the worksheet. All unselected members are removed from the worksheet.
	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.
	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 containing 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 the spreadsheet contains spaces between rows and you drill down on a member, Essbase mirrors the spaces in the resulting report.
	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 containing 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.
	Pivot	Enables you to change the orientation of the data: 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 of the group of members associated with the active cell. You can press the secondary mouse button and drag the member you want to pivot to the destination cell, which 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.
	Navigate 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.
	Sample Data (Zoom In)	Enables sampling in Spreadsheet Add-in. Sampling enables you to zoom in on a "sample" of the 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.
	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.
	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.
	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.
	FlashBack	Restores the previous view.
	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.
	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.
	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.
	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.
	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.
	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. The lock and send processes use committed access modes. If the data cache is too small to hold the number of blocks specified in the 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.
	Unlock	Unlocks blocks that you locked.
	Send	Updates the active database on the server with data in the worksheet. The lock and send processes use committed access modes. If the data cache is too small to hold the number of blocks specified in the 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.
	Calculation	Enables you to calculate the active database or check on the status of an active database calculation. Opens the Essbase Calculation dialog box.
	Connect	Enables you to connect to an instance of Essbase Server. Opens the Essbase System Login dialog box.
	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.