Query Designer Keyboard Shortcuts
For accessibility, each of the keystroke combinations in Table 43 enables users to move from one element to another in the navigation panel, move from the navigation panel to the properties panel, or access items on shortcut menus.
For example, to save a query using the keyboard equivalent for the Save Query command, press Shift+F10 , and then from the shortcut menu that is displayed, press v.
Table 43. Query Designer Keyboard Shortcuts
Action | Keyboard Equivalent | Notes |
---|
To navigate the tree in the navigation panel | Up and down arrow keys; Home and End keys. | When starting Query Designer, focus is set to the first item in the navigation panel. |
To switch between the navigation panel and the properties panel | Ctrl+Tab | |
To navigate within the properties panel | Tab | For example, use Tab to access the members in the Selection Rules list box. |
To access a open shortcut menus from items in the tree in the navigation panel | Shift+F10, and access menu items in one of two ways: Use the up and down arrow keys to navigate within the shortcut menu. Press Enter to select a menu item. Enter the underlined letter on the menu item. The underlined letter designates the keyboard shortcut.
| For example, to open a query, enter Shift+F10+o. This action opens the Open Query dialog box. Depending on the element selected in the navigation panel or properties panel, this keystroke sequence accesses various menus. |
To move a member to another layout in the layout properties panel | Select the member in the navigation pane, then press Shift+F10 to access the shortcut menu. In the shortcut menu, press m, and press r. | For example, use the shortcut to move from an item in a page or row dimension to the column dimension. |
Table 44 lists common keyboard shortcuts for navigation panel elements.
Note: | Commands that are unavailable do not apply to the selected element. |
Table 44. Common Keyboard Shortcuts for Query Designer Navigation Panel Elements
Menu Item | Keyboard Equivalent | Notes |
---|
New | Shift+F10+n | Opens a second shortcut menu with these options: w Workbook s Worksheet q Query d Data Restriction r Sorting Rule |
Select Active Sheet | Shift+F10+s | |
Retrieve | Shift+F10+r | |
Apply Query | Shift+F10+a | |
Open Query | Shift+F10+o | |
Save Query | Shift+F10+v | |
Save Query As | Shift+F10+u | |
Close Query | Shift+F10+y | |
Connect | Shift+F10+c | |
Disconnect | Shift+F10+d | |
Table 45 lists commands for Dimension and Attribute Dimension elements in the navigation panel.
Table 45. Query Designer Keyboard Shortcuts for Dimension and Attribute Dimension Elements
Menu Item | Keyboard Equivalent | Notes |
---|
Move to | Shift+F10+m | Opens a second shortcut menu with these options: p Page r Row c Column a Available Dimensions |
Table 46 lists commands for the Data Filtering element or data filters in the navigation panel.
Table 46. Query Designer Keyboard Shortcuts for Data Filtering Elements and Data Filters
Menu item | Keyboard Equivalent |
---|
Move Data Restriction Up | Shift+F10+m |
Move Data Restriction Down | Shift+F10+r |
Delete Data Restriction | Shift+F10+d |
Delete All Data Restrictions | Shift+F10+d |
Table 47 lists commands for the Data Sorting element or sorting rules (navigation panel).
Table 47. Keyboard Shortcuts for Data Sorting Elements and Sorting Rules
Menu Item | Keyboard Equivalent |
---|
Move Sorting Rule Up | Shift+F10+m |
Move Sorting Rule Down | Shift+F10+l |
Delete Sorting Rule | Shift+F10+d |
Delete All Sorting Rules | Shift+F10+d |
Table 48 lists commands for Members in the member select panel (properties panel).
Table 48. Query Designer Keyboard Shortcuts for Members
Menu Item | Keyboard Equivalent | Notes |
---|
Add to Selection Rules | Shift+F10+r | |
Member Information | Shift+F10+i | |
Find | Shift+F10+f | |
View by | Shift+F10+v | Opens a second shortcut menu with these options: n Name g Generation l Level d Dynamic Time Series |
Suppress Shared Members | Shift+F10+s | |
Aliases | Shift+F10+a | Opens a second shortcut menu with these options: Use the arrow keys to navigate within the shortcut menu, and then press Enter to select an option. |
Expand to Children | Shift+F10+e | |
Expand to Descendants | Shift+F10+x | |
Table 49 lists commands for Selection Rules in the member select panel (properties panel).
Table 49. Query Designer Keyboard Shortcuts for Selection Rules
Shortcut Menu Item | Keyboard Equivalent | Notes |
---|
New Member Filter | Shift+F10+n | |
Preview | Shift+F10+p | |
Select | Shift+F10+s | Opens a second shortcut menu with these options: m Member c Children h Children and Member d Descendants b Descendants and Member |
View Qualified Name | Shift+F10+q | |
Delete Selection Rule | Shift+F10+l | |
Delete All Rules | Shift+F10+a | |
Table 50 lists commands for Data Restrictions in the data filter panel (properties panel).
Table 50. Query Designer Keyboard Shortcuts for Data Restrictions
Shortcut Menu Item | Keyboard Equivalent |
---|
New Data Restriction | Shift+F10+w |
Delete Data Restriction | Shift+F10+l |
Delete All Data Restrictions | Shift+F10+a |