How to work with limits

LAUNCH

When opening a SmartInsight, if it contains a single matrix that exceeds one of the blocking limits in a row or column, only the headers will be displayed but not the matrix values, and the user will display the following warning: 'Cannot retrieve values of a matrix violating blocking limits'.

When opening a SmartInsight, if it contains a single matrix that exceeds one of the warning limits in a row or column, but none of the blocking limits, a window pop up showing this message: "This matrix violates one or more limits, are you sure you want to refresh it?". The user can choose to

  • continue and then update the matrix by selecting the 'Continue' button
  • cancel and display only the matrix headers and not the values, by selecting the 'Cancel' button

UPDATE

When the user tries to update a matrix that exceeds one of the blocking limits in a row or column, the operation is blocked and the following warning will pop up: 'This matrix cannot be refreshed because of a limit violation'.

When the user tries to update a matrix that exceeds one of the warning limits in a row or column, but not the blocking limits, a window pops up showing the following message: ‘This matrix violates one or more limits, are you sure you want to refresh it?’. The user can choose to

  • continue and then update the matrix by selecting the 'Continue' button
  • cancel the operation and return to the previous situation by selecting the 'Cancel' button

MATRIX OPERATIONS

The proper handling, in coexistence with the limits, of the following operations is guaranteed:

  • copy and paste single dimension at end of matrix
  • drill down
  • Drill Down To Children
  • Drill Down To Lowest
  • Drill Down To Descendants
  • Drill Down To Siblings
  • auto-complete at end of matrix
  • addition, from the dimension panel, of new elements of an already existing dimension in the matrix
  • addition, by dimension panel, of elements of a dimension not existing in the matrix
  • "Move to first empty row / column" within the matrix
  • "Move to first empty row/column" from filter panel
  • addition of empty rows/columns

When the user performs one of these operations, if warning limits are exceeded, the warning 'This matrix violates one or more warning limits' will be displayed, but the operation will still be performed.

When the user performs one of these operations, the warning 'The action cannot be performed due to a limit violation' will be displayed and the operation will be blocked.

The correct handling, in coexistence with the limits, of the following operations is not guaranteed:

  • copy and paste several elements of the same dimension simultaneously inside and outside the matrix
  • cut and paste several elements of the same dimension simultaneously inside and outside the matrix
  • drag and drop multiple elements of the same dimension simultaneously inside and outside the matrix
  • cut and paste single dimension at end of matrix
  • single dimension drag and drop at end of matrix
  • copy and paste an entire set of dimensions at the end of the matrix
  • cut and paste an entire set of dimensions at the end of the matrix
  • drag and drop an entire set of dimensions at the end of the matrix
  • replacement of a dimension with more elements than previously in the matrix