2465678 - The calculations options are disabled in Analysis for Office

The calculations options in Analysis for Office are disabled like shown in the examples below:

Example #1:

Example #2:

SAP BusinessObjects Analysis, edition for Microsoft Office

Analysis Office is not able to handle calculations on measures which do not have unique names. See also SAP note 2145620.

This is the reason why Analysis Office disables the calculations on those measures.

As mentioned in chapter "Calculating new measures" in User Guide of Analysis Office:

(...) The measures used as basis for calculations must have a unique name in the data source. If several measures in a data source have the same name, these measures cannot be used for calculations. If one of these measures is selected, the Calculation option in the ribbon is disabled. Therefore, we recommend to use data sources containing measures with unique names. (...)

(...) Note that the advanced calculation editor is available only if all measures of the data source, visible or hidden in the current navigation state, have a unique name. (...)

Rename all duplicated Key Figure names in Query Designer (also hidden).

2145620 - Handling of calculations with non unique names

To add a new measure based on free-form calculation

Calculating new measures

calculation, calculations, formula, formulas, structure, structure member, disabled, greyed out, grey, gray, grayed out, unable, not possible, impossible, measure, measures, add, advanced, calculation , KBA , BI-RA-AO-XLA , Excel Addin , Problem