HANA Composite Provider – new column with constant value

HANA Composite Provider – new column with constant value

SAP BW, SAP HANA
Till BW 7.5 SP7, there is no obvious way to add new column with constant value in a BW on HANA composite provider. Let’s take the example: as a source for composite provider, you are using HANA view where one of Key Figures is Amount. The value is in EUR currency and because the currency field is not in HANA view, you would like to add it on the composite provider to see currency on the report later. How to do that? One option: create calculated column in view, set the constant EUR value for that column. It’s easy, but then you are storing one additional column which is not needed in view. Second option: create new currency column and assign constant value on composite provider. The way of achieving…
Read More

SAP HANA Transport for ABAP

SAP BW, SAP HANA
Keeping a consistent way of objects transportation is one of the challenges while using SAP BW on HANA. All classic BW objects, as well as HANA optimized BW objects (ADSOs, Composite Providers) are transported in BW transportation system. To keep integrity and consistent transportation queue,  SAP Hana Views can be transported in BW as well. This can be obtained in SCTS_HTA BW transaction. Having opened SCTS_HTA, SAP HANA package must be chosen. On the next screen, all views from chosen package are listed. Yellow triangle in Status column gives information that this particular view has been changed since the latest transport. To add selected HANA views to transport request, select views (first column) and click F8 / Clock Icon (Synchronize SAP HANA repository to ABAP). The selected views will be…
Read More

Set the start transaction in SAP Easy Access

SAP BW
If you are using SAP system (BW, ERP) through SAP Easy Access on a daily basis, setting the start transaction can of great help. Having logged in to SAP, instead of the welcome page, you will see the transaction, used by you most frequently. No doubt, that in BW RSA1 is the most frequently used t-code. To set it up as the starting transaction, after logging in to Sap Easy Access, right click on empty space anywhere in your menu tree and choose Set start transaction.Type in the transaction code (in this example RSA1) and it's ready! Well done.Since now after logging in instead of seeing the standard welcome page,  you will be welcomed by the RSA1 screen. Just remember that this setting must be set up separately in each SAP…
Read More

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