CELLSBREAK, ROWSBREAK, and TOLERANCE Subcommands (SET command)

These subcommands control the display of large pivot tables in the Viewer. These settings have no effect on printing large pivot tables or exporting output to external formats with command such as OUTPUT EXPORT or OMS. They also have no effect on tables rendered with the fast tables engine.

CELLSBREAK=n. Sets the maximum number of cells to display. The default is 10000. The value must an integer between 1000 and 100000. If ROWSBREAK=NONE, this setting is ignored.

ROWSBREAK=n|NONE. Sets the number of rows to display. The default is 100. The value must be an integer between 10 and 1000 or the keyword NONE, which turns off this feature and displays the entire table, regardless of size. When the feature is on and large tables are displayed in sections, navigation controls allow you to view different sections of the table.

TOLERANCE=n. Controls the maximum number of rows of the inner most row dimension of the table to split across displayed views of the table. For example, if there are six categories in each group of the inner most row dimension, specifying a value of six would prevent any group from splitting across displayed views. The value must be an integer and cannot be greater than the ROWSBREAK value. If ROWSBREAK=NONE, this setting is ignored.

Several factors can affect the actual number of rows displayed, including:

• If the CELLSBREAK value is reached before the ROWSBREAK value, then the table is split at that point. For example, if ROWSBREAK=1000 and CELLSBREAK=10000, a table with 20 columns will be displayed in blocks of 500 rows.
• The TOLERANCE setting can cause fewer or more rows than the ROWSBREAK value to be displayed.