SAP BLOG How to use HANA Exit in SAP Analytics Report [ Selection screen Default value ]

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,367
Tepki puanı
7
Puanları
6

How to Use HANA Exit to populate default value in SAP HANA Analytics Report




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”

Capture-9.jpg


Step 6 –


Inside Enhancement Implementation “ZXX_CL_VARIALBLE_HANA”

Open “IF_RAROS_VAR_HANA_EXIT~PROCESS”

Capture-10.jpg


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

Capture-12.jpg


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

Capture-14.jpg




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.









Okumaya devam et...
 
Üst