No Applicable Data in Queries
Recently i reported no applicable data issue in BeX Reports we were facing on discussions here .
The issue was irrespective of below possible scenarios that could actually transpire
1) Insufficient data foe query selections
3)Data unavailability for reporting due to roll up or BWA issues
4)Query filters etc…
When we deep dived we established that the issue was actually happening due to inconsistent multiprovider buffer .
So we decided to switch off the buffer and tested it widley across some queries.
With buffer switched off/no buffer the queries worked fine and we were able to get data in report output.
For switching off buffer go to table RRKMULTIPROVHINT and flag the column “Do Not Buffer” with “X” meaning no buffer to be used for multiproviders.
For permanently fixing inconsistent multiprovider buffer issue see/apply SAP Note 1970017