SAP Knowledge Base Article - Public

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


SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

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'.

See Also


NrOfSingleCellsInContext, filtering, context menu , 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