92.1 Keyboard Shortcuts¶
The shortcuts of Datashop and Modeller in one place. The topic linked in each section explains the commands.
Datashop – Main Window¶
| Keys | Action |
|---|---|
| Ctrl+F | Search |
| Ctrl+N | New object of the folder's default type |
| Ctrl+C / Ctrl+V | Copy / paste objects |
| Del | Delete |
| F2 | Rename |
| Shift+F12 | Show location of a search result |
| Ctrl+Q | SQL Explorer |
| Ctrl+Shift+J | Job Monitor |
| F1 | Help |
| Alt+F4 | Close Datashop |
See 4.2 The Main Window.
Datashop – Workbooks¶
| Keys | Action |
|---|---|
| F5 | Refresh |
| Ctrl+F5 | Clear cache and refresh |
| F6 | Cancel a running query |
| Alt+D | Switch design mode on or off |
| Ctrl+S | Save |
| Ctrl+Z | Undo |
| Ctrl+C / Ctrl+X / Ctrl+V | Copy / cut / paste |
| Ctrl+P | |
| Ctrl+E | Export the selected table to Excel |
| Ctrl+W | Open the selected visual in a new window |
| Ctrl+D | View dataset |
| Ctrl+Shift+S | View statistics |
| Ctrl+Shift+H | HTML source (Datashop Expert) |
| Ctrl+Alt+C | Calculator |
| Ctrl+click | On a chart: use as filter. In a formula: open the metric. |
| Shift+double-click | Drill to a level you choose |
See 5.3 The Ribbon and 6.1 Exploring Data in a Workbook.
Datashop – Design Mode¶
| Keys | Action |
|---|---|
| Ctrl+Shift+T | Insert a table |
| Ctrl+Arrow / Ctrl+Shift+Arrow | Move the selected visual 1 / 5 pixels |
| Alt+Arrow / Alt+Shift+Arrow | Resize by 1 / 5 pixels |
| Ctrl+B / Ctrl+I / Ctrl+U | Bold / italic / underline |
| Hold Ctrl when choosing a quick transformation | Add it as a new column |
See 7.4 Inserting and Arranging Visuals.
Datashop – Filter Editor¶
| Keys | Action |
|---|---|
| Ctrl+U | New filter value |
| Ctrl+M | New metric condition |
| Ctrl+D | Add to favorites |
See 9.2 Building Filters.
Datashop – FlexTable Editor¶
| Keys | Action |
|---|---|
| Ctrl+S | Save |
| Ctrl+Z / Ctrl+Shift+Z | Undo / redo |
| Ctrl+Shift+V | Paste without formatting |
| Ctrl+F / Ctrl+H | Find / replace |
| F3 / Shift+F3 | Find next / previous |
| Ctrl+O | Import from file |
| Space or Enter | Toggle a yes/no cell |
See 16.3 The FlexTable Editor.
SQL Explorer¶
| Keys | Action |
|---|---|
| Ctrl+E | Run the SQL (or the selected part) |
| Ctrl+P / Ctrl+N | Previous / next query |
| Ctrl+Shift+S | Show or hide the SQL editor |
| Ctrl+F | Find in the SQL |
See 19.1 SQL Explorer.
Multi-Language Text Fields¶
| Keys | Action |
|---|---|
| Alt+↓ | Choose the language |
| Ctrl+↑ / Ctrl+↓ | Previous / next language |
| Ctrl+Space | Suggest a translation |
See 19.4 Translations.
Modeller¶
| Keys | Action |
|---|---|
| Ctrl+S | Save |
| Ctrl+N / Ctrl+O / Ctrl+F4 | New project / open / close |
| Ctrl+I | Install/Restore |
| Ctrl+Alt+B | Backup |
| Ctrl+D / Ctrl+U / Ctrl+H / Ctrl+T | New dimension / unit / hierarchy / transformation |
| Ctrl+Alt+D | New dynamic view |
| Ctrl+F / Ctrl+G / Ctrl+B | Search / go to table / browse table |
| F2 | Rename |
| F6 / F7 / F8 | Show Object Tree / Properties / Messages |
| Ctrl+Q | SQL Explorer |
| Ctrl+Alt+O / Ctrl+Alt+C / Ctrl+Alt+F | Data source options / connection / Search data in the Source tables pane (Search DB before build 20370) |
| Ctrl+Alt+← / Ctrl+Alt+→ | Previous / next object |
| Ctrl+Tab, Ctrl+1…9 | Next tab, go to tab 1–9 |
| Ctrl+Del | Remove the selected field from a fact |