SAP Knowledge Base Article - Preview

2729038 - F4 help Q-mode "Only Posted Values for Navigation" does not work in BICS


After upgraded to SAP BW 7.50, you have defined F4 read mode Q (Only Posted Values for Navigation) for filter.
However when you execute the query in runtime, read mode M (Values in Master Data Table) is used when you filter the characteristic/dimension.

This symptom has been observed in client tools using BICS layer:

  • Analysis for Office
  • Design Studio
  • Lumira
  • ...

In RSRT, read mode Q is used as expected.

Note: This KBA is only related to the filter behaviour after query execution. F4 mode used in variable/prompt screen is not being discussed in this topic.



SAP NetWeaver 7.5


SAP NetWeaver 7.5


read mode, Q mode, M mode, Only Posted Values for Navigation, Master Data Table, F4, filter, selection , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WJR , BEx Web Java Runtime , BI-RA-AD , Design Studio End Of Maint Note 2622437 , BW-BEX-OT-F4 , MasterData read services , BI-LUM-DER , Lumira Designer , BW-BEX-OT-BICS-PROV , BICS Provider/RSBOLAP , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.