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 branches depending on the bitness of the operating system and the platform in use:

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

• [HKEY_LOCAL_MACHINE\Software\Foresight\Foresight Analytics Platform\9.0\Pivot] - branch 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] - branch for settings of x86 Foresight Analytics Platform on working in the x64 operating system. For all users.

NOTE. The Pivot subsection must be created.

Create one of the DWORD parameters in the Pivot subsection:

• SelectionLimit. It sets constraint by the number of created Cartesian product with selected dimension elements, including the fixed ones.

• MatrixLimit. it sets constraint by the matrix size - number of non-empty cells.

NOTE. Limit is applied without considering of filtering.

On exceeding the set 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 branches depending on the bitness of the operating system and the platform in use:

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

• HKEY_LOCAL_MACHINE\Software\Foresight\Foresight Analytics Platform\9.0\KeExpress] - branch 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] -branch for settings of x86 Foresight Analytics Platform on working in the x64 operating system. For all users.

NOTE. If the KeExpress subsection is absent, create it.

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

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