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