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
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 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 pageThis 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.