SAP Knowledge Base Article - Public

3239692 - Query settings in BEx Query Designer or BW Modeling Tools are not evaluated in Analysis Office

Symptom

The query settings below in BEx Query Designer and BW Modeling Tools are not evaluated in Analysis for Office:

BEx Query Designer BW Modeling Tools

Hide Repeated Key Values

Suppress Repeated Key Values

Display Scaling Factors for Key Figures

Show Scaling for Measures

Environment

SAP Analysis for Microsoft Office

Cause

The tool is working as designed.

Resolution

The setting made in BEx Query Designer and BW Modeling Tools to hide/show repeated key values is not evaluated in Analysis Office. To define the display for repeated members, use the setting "Repeat Members" in the design panel as described in chapter "The Components tab".

The setting made in BEx Query Designer and BW Modeling Tools to display the scaling factors for key figures is not evaluated in Analysis Office. To define the display for scaling factors, use the setting "Show Scaling Factors" as described in chapter "To show or hide the scaling factors".

See Also

SAP Note 2299020 - Analysis Office does not evaluate "Suppress Repeated Key Values" from Query definition

Keywords

repeat members, scaling factors , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions