Skip to Content
Technical Articles
Author's profile photo Souman Halder

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%20Selection%20Screen%20Value

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%20Composite%20View%20with%20all%20Business%20Logic

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%20BW%20Prospective%20Select%20New%20Query%20tick%20Check%20Box%20to%20Create%20Query

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

BW Query Created on top of Composite Provider

BW%20Query%20Details

BW Query Details

Step 3 –

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

Create%20and%20Add%20HANA%20Exit%20Variable%20in%20BW%20Query

Create and Add HANA Exit Variable in BW Query

HANA Exit Variable Details for Fiscal year–

HANA%20Exit%20for%20FIscal%20Year%20details

HANA Exit for FIscal Year details

For posting Period –

Posting%20Period%20HANA%20Exit%20Variable%20details

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%20T-code%20SE19%20or%20SE18%20for%20SAP%20Badi

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%20Code%20Snapshot

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%20the%20Step%20by%20Click

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%20Report%20Output%20After%20including%20HANA%20Exit%20Variable

BW Report Output After including HANA Exit Variable

 

Conclusion-

 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.

 

 

 

 

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Frank Riesner
      Frank Riesner

      Great blog post - thanks for sharing these details.