How to use HANA Exit in SAP Analytics Report [ Selection Screen Default value ]
Purpose / Issue –
SAP Analytics reports default value for Fiscal Year and Posting Period as Current Fiscal Year and Posting Period on the selection screen.
- SAP HANA Composite view [ Bring all the fields and KPI ]
- BW query [ On top of Composite Provider]
- HANA Exit variable
- SAP Badi to populate HANA Exit value
Step 1 –
- Build HANA Composite view with all relevant details as per your business requirement.
Step 2 –
Build the BEx Query with required selection [ selection Fiscal Year / Period ] using CDS SQL name as Transients Provider.
BW Query Created on top of Composite Provider
Step 3 –
Create respective selection variable for Fiscal Year and Posting Period in BEx with “Processed By” = HANA Exit.
HANA Exit Variable Details for Fiscal year–
For posting Period –
Step 4 –
In SAP GUI open t-code 18 and enter the HAVA BadI “RSROA_VARIABLES_HANA_EXIT” click on Display
Step 5 –
Under Implementations create Enhancement Implementation “ZXX_CL_VARIABLE_HANA”
Step 6 –
Inside Enhancement Implementation “ZXX_CL_VARIALBLE_HANA”
Step 7 –
Write the code to populate the FISCAL Year / Posting Period Default value
Save and Activate.
Step 8 –
To test the CLASS Method open T-code SE24 execute the methods
Follow the steps as highlighted in Yellow
Enter the HANA Exit Variable Name in “I_VNAM”
Step 9 –
Now Execute the Report in T-code RSRT [ Web Version] Selection screen Value populated with default Current Fiscal year/ Posting Period.
This document explains to you in detail how to use the HANA exit variable on top of the SAP HANA Analytics report for default values.