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.
An example:
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).
It is also nice if you provide Value Help by changing the Parameter Type to Column
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.
An example:
- You have a basic view joining the tables BSEG & BKPF
- This basic view is used in Reporting view
Reporting view, using the Basic view
|
It is also nice if you provide Value Help by changing the Parameter Type to Column
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
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
3. Map your texts as Label column in the Semantics (otherwise texts will not show up in F4 Value Help!!!)
4. Use your custom Value Help view in the Input Parameter as a custom Column
The End result looks like this:
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.
Source: scn.sap.com
No comments:
Post a Comment