You use the Cubeview tab to preview database values and perform, within the displayed grid, a limited set of Spreadsheet Add-in operations.
Note: | The grid does not reflect true retrieval times from other client applications. |
On the grid, you can perform the following mouse actions (assuming that the left button is the primary button):
Double-click a member cell—The member is expanded one level.
Double-click a data cell—The Linked Reporting Objects dialog box opens.
Double-right-click a member cell—The member is collapsed one level.
Drag the right mouse on a member cell—The member is pivoted.
Using the toolbar buttons, you can perform various actions. The tooltips for the buttons and the actions related to the buttons are as follows:
Retrieve—Retrieves data into the grid.
Conditional Retrieve—Opens the Conditional Retrieve dialog box, in which you enter a string that contains Essbase report specification commands.
Zoom In—On a member cell, expands the member one level, and, on a data cell, opens the Linked Reporting Objects dialog box.
Zoom Out—On a member cell, collapses the member one level.
Pivot—On a member cell, pivots the member from a row group to a column group or vice versa.
Linked Objects—On a data cell, opens the Linked Reporting Objects dialog box, where you can attach or edit an external file, a cell note, or a URL for the cell.
Keep Only—Retains only the selected member or member range in the grid.
Remove Only—Removes only the selected member or member range from the grid.
Undo—By default, reverses the most recent operation performed on the grid. (You can set the number of operations to undo by clicking the Preferences button.)
Update—Refreshes the grid with the most recent data.
Chart—Displays a chart view of the grid data. (Click Sheet1 to return to the grid view.)
Member Selection—On a member cell, opens the Member Selection dialog box, in which you find and select members to include in the grid.
Preferences—Opens a dialog box in which you can set grid preferences (number of operations to undo, grid class to use, and format of different types of member cells or data cells).
View as HTML—Creates a sheet that displays the grid in HTML format.
Print—Opens the Print dialog box.
Email—Opens the Email Grid Output dialog box, where you can specify email addresses and a subject for emailing the grid output.