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

ActionKeyboard EquivalentNotes

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 ItemKeyboard EquivalentNotes

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 ItemKeyboard EquivalentNotes

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 itemKeyboard 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 ItemKeyboard 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 ItemKeyboard EquivalentNotes

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:

  • None

  • Default

  • Long names

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 ItemKeyboard EquivalentNotes

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 ItemKeyboard Equivalent

New Data Restriction

Shift+F10+w

Delete Data Restriction

Shift+F10+l

Delete All Data Restrictions

Shift+F10+a