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.

Report Selection Screen Value

Prerequisites –

◉ 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

Solution

Step 1 –

◉ Build HANA Composite view with all relevant details as per your business requirement.

CDS Composite View with all Business Logic

Step 2 –

Build the BEx Query with required selection [ selection Fiscal Year / Period ] using CDS SQL name as Transients Provider.

In BW Perspective Select New Query tick Check Box to Create Query

BW Query Created on top of Composite Provider

BW Query Details

Step 3 –

Create respective selection variable for Fiscal Year and Posting Period in BEx with “Processed By” = HANA Exit.

Create and Add HANA Exit Variable in BW Query

HANA Exit Variable Details for Fiscal year –

HANA Exit for FIscal Year details

For posting Period –

Posting Period HANA Exit Variable details

Step 4 –

In SAP GUI open t-code 18 and enter the HAVA BadI “RSROA_VARIABLES_HANA_EXIT” click on Display

Use T-code SE19 or SE18 for SAP Badi

Step 5 –

Under Implementations create Enhancement Implementation “ZXX_CL_VARIABLE_HANA”

Step 6 –

Inside Enhancement Implementation “ZXX_CL_VARIALBLE_HANA”

Open “IF_RAROS_VAR_HANA_EXIT~PROCESS”

Step 7 –

Write the code to populate the FISCAL Year / Posting Period Default value

Save and Activate.

Source Code Snapshot

Step 8 –

To test the CLASS Method open T-code SE24 execute the methods

Follow the steps as highlighted in Yellow

Follow the Step by Click

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.

BW Report Output After including HANA Exit Variable