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_BW 750


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 , BW-BEX-OT-BICS-PROV , BICS Provider/RSBOLAP , BI-LUM-DER , Lumira Designer , Problem

About this page

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

Search for additional results

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