Snap commands are simple commands that you can use to perform tasks quickly.
Click a view, then click to open the shortcut bar.
Next, click and type a snap command.
You can type snap commands in full, or use abbreviations, for example. swap or sw. Snap commands aren't case-sensitive and you don't need to use exact spelling - beljium selects Belgium.
You can undo snap commands by clicking .
You can use these snap commands:
- Select members, sets, and levels in dimensions.
- Type the names that you want to select in the snap command field that is separated by a , (comma), or and. Select is the default snap command, so you do not need to type select.
- For example, type germ,mark to select the Germany and Marketing members.
- Select doesn't apply to members on the bench
- Swap rows, columns, dimensions in the context area. For example, to swap the versions and time dimensions, type sw versions,time. Typing swap on its own swaps the rows and columns.
- You can find members on rows, columns, or both.
- Find europe finds the first result. To move through the results, type find. To go back, type, find previous.
- Find is a powerful snap command, for example, typing find r (color red or color blue) and size large finds members on the rows, with an attribute value for color that is red or blue, and an attribute value for size that is large.
- Hide named members in dimensions on the rows or columns.
- To hide members that are named US and Feb-2004, type hide US, Feb-2004
- Show or unhide members.
- Type unhide r to unhide rows. To unhide all, type unhide, or unh.
- To unhide everything on the time hierarchy, type unh time
- Keep members in dimensions on the rows or columns, while you hide the other members.
- For example, type keep 2014, 2015
- Enable zero suppression.
- To enable zero suppression on just rows type zero rows, and for columns, type zero columns
- To clear all zero suppression, type zero off
- Show leading or trailing totals, or hide totals.
- For example, in a time dimension, you could have Q1, Jan, Feb, Mar, which has a leading total.
Typing Totals trailing columns would change the time dimension to: Jan, Feb,
Type t -h to hide all totals.
- Expand levels in a hierarchy to a specific depth. If you don’t specify a level, the leaf level is expanded.
- You can also expand numbered levels, and levels on rows, columns, or both. For example, type level rows 2 or level rows.
- Drill down on members.
- For example, to drill down on a member named Georgia, type Drill Georgia.
- Resetting the drill state clears drills. To reset the drill state for an Organization hierarchy, type Drill reset Org, or d r org
- To remove all of the drills, type drill reset
- Sort labels or values in ascending or descending order. You can choose to sort by hierarchy, or to break the hierarchy.
- You can sort a named hierarchy, and for labels, you can sort by rows and columns. You don't need
to specify label or value, unless there is an ambiguity.
- Sort lab asc rows
- Sorts labels in ascending order for rows, without breaking the hierarchy. You can also type this in natural language: sort label ascending rows.
- Sort lab des br both
- Sorts labels in descending order for both rows and columns, and breaks the hierarchy.
- Sort val des br Sales
- Sorts values in descending order, breaking the hierarchy, under the Sales member. You must specify a member to sort for values. In natural language, this is: sort value descending breaking Sales.
- sort -x
- Clears all sorting. To clear sorting on the months hierarchy, type sort clear months.
How the snap command searches
IBM® Planning Analytics Workspace searches for member names, captions, and aliases, named sets, and named levels (levels with default names are ignored). If IBM Planning Analytics Workspace finds more than one member, they are listed in order of relative strength of the matches. More weight is given to precise matches than tentative matches.