2802280 - Unable to create multiple Design Rules at once for several input-ready cells

When trying to create multiple Design Rules at once for several input-ready cells (e.g. by entering a formula in several input-ready cells), no Design Rule is created and displayed in the Design Panel of Analysis Office.

It works only when trying to create multiple Design Rules at once for a small number of input-ready cells.

Analysis for Microsoft Office

This is the intended and default behavior. For performance reasons, Analysis Office does not create more than 100 Design Rules at once for input-ready cells.

The limit of 100 cells can be changed via Analysis Office setting "NrOfSingleCellsInContext".

Refer to SAP Note 2083067 in order to know how to change the settings in Analysis Office.

Note that increasing this limit might have negative impact on the performance when creating a huge number of Design Rules at once.

SAP Note 2083067 - How to maintain settings for Analysis Office 2.x

Chapter "GridConfiguration" in Adminitrator Guide of Analysis Office in http://help.sap.com/boao.

design rules, rule, formula, formulas, few, members, context, unable, input ready, configuration, input-ready, planning , KBA , BI-RA-AO-XLA , Excel Addin , Problem