BEx Report: No applicable data found

SAP BW
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

SAP & VBA: How to start

SAP BW
Visual Basic for Application can be very helpful when is used for automation in Microsoft Office (especially in Excel). But it is not well known that VBA, together with Excel, can be used in SAP systems (those accessible from SAP Logon, for example SAP ERP, SAP BW). (more…)
Read More