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 NetWeaver 7.5
Product
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 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.