Pivot View data truncation

The current version of the Pivot View has a memory use profile that prohibits large datasets and large cell counts. To avoid out-of-memory errors, which can be fatal, the Pivot View automatically truncates the number of rows and/or columns shown when necessary. When this happens, Omniscope displays a warning in red below the pivot table such as:

Warning: data has been truncated to show only the first 70 columns and 71 rows. Click for details.

The truncation of the X and/or Y values happens irrespective of sorts, so do not assume the smallest values are truncated first.

Note: successive versions of Omniscope have higher limits and more graceful management of pivot table scaling issues.

Managing data truncation

To avoid this behaviour:

• Change the X and/or Y fields in the View Toolbar.
• Choose Category fields with fewer unique values
• Reduce the amount of data (records) showing, either at source or by filtering.
• Install more RAM memory in your PC and/or change to 64-bit operating system.

Disabling data truncation

If you are a power user, you may wish to experiment with disabling this safety check because the imposed limit is somewhat conservative. Please save your work before proceeding.

To disable truncation for the duration of your Omniscope session, click the red warning label and choosing Show all values.

To disable truncation permanently, un-tick Settings > [Application wide] Advanced > Miscellaneous > Truncate rows/columns in Pivot view to avoid out-of-memory errors.

You may need to re-open your saved file.