SAP Knowledge Base Article - Public

3663638 - Results of calculations with mixed units are not displayed, but shows as asterisk '*' in SAP Analysis for Microsoft Office

Symptom

Results of calculations with mixed units (for example, quantity and currency) are not displayed in the crosstab, but an asterisk  '*' is shown in the respective data cells.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Open a query in AO where the results row contains a sum of mixed units.
  2. Observe * in the cell.

Cause

This is a Product design. The setting "DisplayMixedValues" to specify whether the results of calculations with mixed units should be displayed in the table. The default value is False. This means that the results are not displayed, but the asterisk. 

Resolution

Change the parameter "DisplayMixedValues" value to True, the results of the calculations and the asterisk is displayed in the respective data cells. 
About how to change AO setting, please refer to the KBA 2083067.

See Also

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE/df90d3701aba42b9a4351caa387bd672/72499c195f0a410180b7e779e6963548.html?locale=en-US&version=LATEST

Keywords

Measure, aggregated values, workbook, mixed values , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8