SAP Knowledge Base Article - Preview

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

Symptom

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
  • BW JAVA
  • 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.


Read more...

Environment

SAP_BW 750

Product

SAP NetWeaver 7.5

Keywords

read mode, Q mode, M mode, Only Posted Values for Navigation, Master Data Table, F4, filter, selection , KBA , BI-RA-AO-XLA , Excel Addin , BI-LUM-DER , Lumira Designer , BI-RA-AD , Design Studio , BW-BEX-ET-WJR , BEx Web Java Runtime , BW-BEX-OT-F4 , MasterData read services , 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.