2784775 - How to use 'NrOfSingleCellsInContext' setting in Analysis

When selecting more than a 100 cells in the crosstab for an analysis (e.g. filtering) there is no execute option in the context menu

Select more than a 100 cell and click on the context menu

There is a technical setting that defines the maximum number of crosstab cells that can be selected to execute analysis option.

If more cells are selected in a crosstab, the analysis options are disabled. The default value is 100. The setting got introduced due to performance issues.

Change the default value by going to File > Analysis > Customize Analysis > Technical Configuration and look for setting 'NrOfSingleCellsInContext'.

Corresponding article on SAP Help Portal

NrOfSingleCellsInContext, filtering, context menu, crosstab , KBA , BI-RA-AO-XLA , Excel Addin , How To

SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8 ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5