Skip to Content
Author's profile photo Dmitry Kuznetsov

HANA Input Parameters with texts

Introduction

On one hand HANA Variables are easy to use and, mostly, perform well on well-modeled HANA views. There are always exceptions with big tables where join happens at a very granular level, then it is smarter to use Input Parameters, mapped through nested layers of HANA views instead of just a Variable in the topmost one. Performance-wise you can achieve a saving of 20-50% (personal observations), but then it comes a little tricky with introducing both keys and texts in Value Help.

Exactly this situation is discussed in more detail by this how-to post. Some content here originates from idea exchange with Joaquin Grau, whom I have to say big thanks.

An example:

  • You have a basic view joining the tables BSEG & BKPF
  • This basic view is used in Reporting view

   Blog2 Picture010.jpg

Basic view

Blog2 Picture020.jpg

Reporting view, using the Basic view

Given the amount of data and knowing business requirement to make this selection, it is a smart idea to create an Input Parameter on Company Code on both of the views, add a filter on the basic view (as seen on the screenshot above) and map it in the upper reporting view for execution (as seen on the screenshots below).

Blog2 Picture030.jpg

It is also nice if you provide Value Help by changing the Parameter Type to Column

  Blog2 Picture040.jpg

Works good, but – no texts here. Even if you map Company Code Text as a label in the view, it will not get populated

Quick solution with Input Parameters

Open an Input Parameter settings, change it to Column and scroll down to define, which view should be used for Value Help. In my example I will use a SAP-delivered HANA Live view CompanyCode

Blog2 Picture050.jpg

Limitations you will notice:

  • It uses just the MasterData tables, wherein you might have unwanted / unused entries
  • There is no option to “switch” it to work based on Transaction Data view (I am missing BEx sometimes too J )

Customization

1. Create a dedicated view that you will use for Value Help for Company Codes. It can be even based on Transaction Data, but mind the performance.

2. Set the filters (as many as you can). I was lucky to be able to use Chart of Accounts for filtering the relevant Company Codes from table T001

Blog2 Picture060.jpg

3. Map your texts as Label column in the Semantics (otherwise texts will not show up in F4 Value Help!!!)

Blog2 Picture070.jpg


4. Use your custom Value Help view in the Input Parameter as a custom Column

Blog2 Picture080.jpg

The End result looks like this:

Blog2 Picture090.jpg

————————————————-

Dmitry has covered a variety of hands-on development & Architect roles on HANA, BW, BO and ABAP.

He has contributed to some major international organizations success, advising on Architecture and various mixes and matches of SAP-driven Business Intelligence technologies to suit the client’s needs best in the long run.

You can follow Dmitry’s posts on SCN and website of www.bi-consulting.eu.

Assigned Tags

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

      Thanks Dmitry!