BEx Report: No applicable data found

When SAP BW on HANA is used, the ‘No applicable data found’ error in BEx can be seen quite often (even when data are inside the reporting object and should be visible). This error can occur when data into data store object in BW are loaded from SAP HANA data model through composite provider. The setup can be: Hana View - Composite Provider - Advanced DSO - BEx report. When model like in above example is used, SIDs for loaded data are not created and that’s the reason for no applicable data found error in BEx report. Fortunately it can be easily solved by using BW RSRV transaction, with test Foreign key relationship of reporting-relevant DataStore object and SID table characteristics test. In the test the data source must be chosen (ADSO)…
Read More