Keyboard Shortcuts for Access and Navigation
The tables in this section describe keyboard equivalents that assist with accessing Oracle Essbase Studio Console elements and navigating through the interface.
- Table 7-1 Accessing Main Areas (or View Tabs) of the Essbase Studio Interface
- Table 7-2 Accessing Elements in the Metadata Navigator and Data Source Navigator
- Table 7-3 Right-Click Commands Common to Most Elements in the Metadata Navigator
- Table 7-4 Accessing Editors, Wizards, and Dialog Boxes to Create New Elements
- Table 7-5 Accessing Dialog Boxes from the Menu Bar
- Table 7-6 Working with Editors in the Work Area
- Table 7-7 Accessing Help Menu Items
Table 7-1 Accessing Main Areas (or View Tabs) of the Essbase Studio Interface
| Keys | Action |
|---|---|
| F10
Note: Press Esc to remove focus from the menu bar. |
Access to the Essbase Studio menu bar |
| Ctrl+5
or Alt+V, then N or Press and hold down Ctrl, press F7, use up and down arrow keys to select Metadata Navigator, and then press Enter |
Focus on Metadata Navigator |
| Press Ctrl+3
or Press Alt+V, then A or Press and hold down Ctrl, press F7, use up and down arrow keys to select Data Sources, and then press Enter |
Focus on Data Source Navigator |
| Ctrl+2
or Alt+V, then C or Press and hold down Ctrl, F7, use up and down arrow keys to select Console Messages, and then press Enter |
Focus on Console Messages tab |
| Shift+F10 | Display the context menu appropriate to the focus of the cursor |
| Esc | Close, without saving, an open dialog box or wizard |
Shift-Tab until focus in on the actual tab title.
|
Close a view tab |
Table 7-2 Accessing Elements in the Metadata Navigator and Data Source Navigator
| Keys | Action |
|---|---|
| Ctrl+5 or Ctrl+3, then use up and down arrow keys | Navigate through tree structure |
| Right arrow key | Open a folder |
| Use the up and down arrow keys to navigate to the Root folder, Shift+F10, then E | Expand all folders in the Metadata Navigator |
| Left arrow key | Close a folder |
| Use the up and down arrow keys to navigate to the Root folder, Shift+F10, then C | Collapse all folders in the Metadata Navigator |
| Use the up and down arrow keys to navigate to a folder, Shift+F10, then H | Refresh the contents of a folder |
| Use the up and down arrow keys to navigate to the Root folder, Shift+F10, then H | Refresh all folders in the Metadata Navigator |
| Shift+F10 | Context menu for tree items |
| Use arrow keys to navigate to element location in tree, press Enter | Launch the wizard, editor, or properties dialog box for the selected metadata element |
| Alt+E, then S | Open the Search tab in the Metadata Navigator |
| Alt+E, then F | Open the Find dialog box |
| Ctrl+3, use arrow keys to navigate to the element, Shift+F10, then E | Launch the editor or Properties dialog box for the selected source element in the Data Source Navigator (applies to data source connection names, Oracle Essbase connection names, and minischemas) |
| Ctrl+3, use arrow keys to navigate to the element, Shift+F10, then O | Launch the Properties dialog box for the selected source element (applies to source table names, column names, and minischemas) |
| Ctrl+5, use arrow keys to navigate to the metadata element, Shift+F10, then V | Launch sample data for the selected metadata element in the Metadata Navigator |
| Ctrl+3, use arrow keys to navigate to the column element , Shift+F10, then V | Launch sample data for the selected source column element in the Data Source Navigator |
| Ctrl+5, use arrow keys to navigate to the element, Shift+F10, then L | Launch the lineage editor in the context of the selected metadata element in the Metadata Navigator |
| Ctrl+5, use arrow keys to navigate in the Metadata Navigator, select an Essbase model, then press Enter | Launch the graphical view of the Essbase model in the work area |
| Ctrl+5, use arrow keys to navigate in the Metadata Navigator, select an Essbase model, Shift+F10, then B | Launch the Essbase Model Properties dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then L | Launch the Text List dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the
tree, Alt+F, followed by N, then A
Note: The Alias Set Manager is no longer part of Essbase Studio. This command now launches the Alias Sets dialog box. |
Launch the Alias Sets dialog box |
| Ctrl+5, use arrow keys to navigate in the Metadata Navigator, select
an Essbase model, then:
Shift+F10, then W or Alt+F, then W |
Launch the Cube Deployment Wizard |
| Ctrl+5, use arrow keys to navigate in the Metadata Navigator, select an Essbase model, Shift+F10, then Y | Launch the deployment history in the work area |
| Ctrl+3, use arrow keys to navigate to a data source connection, Shift+F10, then U | Launch the Incremental Update dialog box |
| Ctrl+3, use arrow keys to navigate to a data source connection, Shift+F10, then I | Launch the Introspection Wizard |
| Ctrl+3, use arrow keys to navigate to a Microsoft SQL Server data source connection, press Shift+F10, then Y | Microsoft SQL Server users only- Toggle the Show Friendly Names option |
Table 7-3 Right-Click Commands Common to Most Elements in the Metadata Navigator
| Keys | Action |
|---|---|
| Shift+F10, then E | Edit an element |
| Shift+F10, then C | Copy an element |
| Shift+F10, then P | Paste an element |
| Shift+F10, then N | Rename an element |
| Shift+F10, then D | Delete an element |
| Shift+F10, then H | Refresh cube schema or Oracle Oracle Essbase model |
Table 7-4 Accessing Editors, Wizards, and Dialog Boxes to Create New Elements
| Keys | Action |
|---|---|
| Alt+F, followed by N, then O
or Alt+F, followed by N, then Enter (the default selection is for Connection Wizard) |
Launch Connection Wizard |
| Alt+F, followed by N, then I | Launch Minischema Wizard |
| Alt+F, followed by N, then U | Launch the User-Defined Table dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then F | Launch the Folder Properties dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then D | Launch the Dimension Element dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then T | Launch the Derived Text Measure dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then L | Launch the Text List dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then A | Launch the Alias Set dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then H | Launch the hierarchy editor |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then M | Launch the measure hierarchy editor |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then C | Launch the Calendar Hierarchy dialog box |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then S | Launch Cube Schema Wizard |
| Ctrl+5, use arrow keys to navigate to appropriate location in the tree, Alt+F, followed by N, then R | Launch the drill-through report editor |
| Ctrl+5, use arrow keys to navigate in the tree to select a date column, Shift+F10, then T | Launch the Create Date Elements dialog box |
Table 7-5 Accessing Dialog Boxes from the Menu Bar
| Keys | Action |
|---|---|
| Alt+F, then O | Launch the Export dialog box |
| Alt+F, then I | Launch the Import dialog box |
| Alt+E, then F | Open the Find dialog box |
| Alt+E, then S | Open the Search tab in the Metadata Navigator |
| Alt+E, then R | Open the Properties dialog box for the select metadata or source element |
| Alt+E, then E | Launch the Preferences dialog box |
| Alt+T, then R | Launch the Essbase Studio Login dialog box to reconnect to Essbase Studio Server |
| Alt+T, then H | Launch the Rehost Essbase Connections dialog box |
| Alt+T, then U | Launch the Update Cube Linkage dialog box |
| Alt+T, then E | Launch the EIS Catalog Migration dialog box |
Table 7-6 Working with Editors in the Work Area
| Keys | Action |
|---|---|
| With focus on editor title tab text, press and hold Ctrl, then F6, use up and down arrow keys to choose editor from the context menu. You must hold the Ctrl key down for the entire operation. | Move from editor to editor |
| Alt+- | Invoke context menu for editor |
| Right or left arrow keys | Within drill-through report editor, move from tab to tab |
| Ctrl+F4
or Alt+F, then C or Ctrl+W |
Close an editor |
| Alt+F, then L
or Ctrl+Shift+W |
Close multiple editors |
Table 7-7 Accessing Help Menu Items
| Keys | Action |
|---|---|
| Alt+H, then W | Launch the Welcome page in the work area |
| Alt+H, then H
or Within dialog boxes, editors, wizards, and main console panes, press F1 To close the online help, press Alt+F4 |
Launch the Essbase Studio online help |
| Alt+H, then T | Launch the Oracle Technical Support Web site |
| Alt+H, then E | Launch the EPMOracle Enterprise Performance Management System Documentation Library on the Oracle Technology Network Web site |
| Alt+H, then A | Launch the Essbase Studio About box |