How to Limit Excessively Large Selection of Dimension Elements?

To prevent the system from overload on selecting a large number of elements, Foresight Analytics Platform allows for limiting the maximum number of selected elements.

Selection limit is set in one of the registry keys depending on the bitness of the operating system and the platform in use:

• [HKEY_CURRENT_USER\Software\Foresight\Foresight Analytics Platform\9.0\Pivot] - key for the current user settings, regardless of system bitness.

• [HKEY_LOCAL_MACHINE\Software\Foresight\Foresight Analytics Platform\9.0\Pivot] - key for settings if bitness of Foresight Analytics Platform matches with operating system bitness. For all users.

• [HKEY_LOCAL_MACHINE\Software\Wow6432Node\Foresight\Foresight Analytics Platform\9.0\Pivot] - key for settings of x86 Foresight Analytics Platform on working in the x64 operating system. For all users.

NOTE. The Pivot key must be created.

Create one of the DWORD parameters in the Pivot key:

• SelectionLimit. It sets limit on the number of created Cartesian products with selected dimension elements, including the fixed ones.

• MatrixLimit. It sets limit on the matrix size - number of non-empty cells.

NOTE. Limit is applied without considering of filtering.

On exceeding the specified limit, a message is displayed instead of the table.

Limiting of Elements Selection of Observation Objects Dimension

Selection can be limited for the number of elements of observation objects dimension.

Selection limit is set in one of the registry keys depending on the bitness of the operating system and the platform in use:

• [HKEY_CURRENT_USER\Software\Foresight\Foresight Analytics Platform\9.0\KeExpress] - key for the current user settings regardless of system bitness.

• HKEY_LOCAL_MACHINE\Software\Foresight\Foresight Analytics Platform\9.0\KeExpress] - key for settings if bitness of Foresight Analytics Platform matches with that of operating system. For all users.

• [HKEY_LOCAL_MACHINE\Software\Wow6432Node\Foresight\Foresight Analytics Platform\9.0\KeExpress] -key for settings of x86 Foresight Analytics Platform on working in the x64 operating system. For all users.

NOTE. If the KeExpress key is missing, create it.

Create the parameter of the DWORD type with the ObjectivesSelectionLimit name in the KeExpress key.

NOTE. By default, if the parameter is not set, selection of observation objects dimension is limited to 2000 elements.

See also:

Questions and Answers | Setting Up Dimensions and Element Selection