Posts

Showing posts from November, 2014

List of Values for HANA (SPS 07 Rev 70) Input Parameters In IDT 4.1 SP2

Image
This blog discusses the use case where we can use list of values generated in SAP Business Objects Information Design Tool's (IDT) data foundation layer for SAP HANA input parameters (from SAP HANA information view).

As we know that we can map SAP HANA input parameters to universe parameters in data foundation layer of IDT and this can be done by creating derived table in IDT. If you are not sure how to achieve that then please refer to document here. You would need to write a SQL statement to create derived table in IDT. I would like to suggest you to look at SQL statement generated in HANA studio when you preview your data. You can copy the part in green and then use it in IDT (as shown below).


SQL Statement in SAP HANA Studio:



SQL Statement in IDT:



Challenge/Issue/Gap:When we use SAP HANA input parameters in Information Design Tool then the list of values created in SAP HANA doesn't come along. For example, following is the input parameter created in SAP HANA information view (…

SAP HANA Input Parameter - Derived from Table - Use Expression in Filter Value

Image
Recently, I have experienced something while modeling HANA information view that I want to share with everyone. 


Case: Dynamic Filter for projection with current Fiscal Year and Fiscal Period. 

Method:There are different parameter types that we can use to do this. I decided to use following "Derived from table" type as shown below: 



Challenge:When filtering column then it displays list of values from the same HANA information view and we can select the date. Now, as the requirement is current Fiscal Year and Period so how do we filter the column to dynamically select current date in "Filter Value" section?
Solution:Like everyone, I expected it to understand the expression. So I tried following and it worked. I used the expression 
currentdate()


I was aware that I could use expression in the "Default Value" section (as explained in SAP HANA Developer Guide) but didn't expect it to work in "Filter Value". I was able to filter the projection using t…