Snap commands

You can use these snap commands:

Select

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

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.

Find

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

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.

Unhide

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

Keep members in dimensions on the rows or columns, while you hide the other members.

For example, type keep 2014, 2015.

Zero

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.

Totals

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, Mar, Q1.

Type t -h to hide all totals.

Level

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

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

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.