2574021 - All values from master data are retrieved when opening the LOV for a merged variable in Analysis Office

The option "Merge Variables" is being used in Analysis Office workbook.

When opening the value help (aka "F4 Help") in a merged variable, Analysis Office is showing all values from master data.

SAP Analysis for Microsoft Office

This is not a bug in Analysis Office tool but the intended behavior, also explained in SAP note 1565809.

When merging the variable, it is not possible to decide which infoprovider the variable is based on. In this case, F4 mode will always be M mode.

1565809 - Settings for BW query F4 help

read mode, lov, list of values, access mode, infoprovider, masterdata, value help, f4 , KBA , BI-RA-AO-XLA , Excel Addin , Problem