SAP Knowledge Base Article - Public

2784775 - How to use 'NrOfSingleCellsInContext' setting in Analysis

Symptom

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

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

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

Cause

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.

Resolution

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

See Also

https://help.sap.com/viewer/df90d3701aba42b9a4351caa387bd672/2.7.8.0/en-US/32861526cd1d4315a18a08643726b28e.html?q=NrOfSingleCellsInContext

Keywords

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

Product

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