Skip to Content
0

SAP HANA Table Function Wiered Behaviour

Apr 19, 2017 at 11:01 PM

39

avatar image
Former Member

Hello All,

I have created a table function which accepts two parameters

1] IP_DAY_DATE(date)

2] Scenario(MTD/YTD/QTD/LYMTD)

upon execution, it accepts a date and scenario and based on date and scenario it will return you the period to date ....example 2005-05-10 YTD will return me all the date from 2005-01-01 To 2005-05-10

I am using this table function in CalculationView projection so I have 4 projections where I am using this table function .

Now at Calview I have one parameter and want to pass constant value for second parameter in table function but parametermaping is not accepting that.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 19, 2017 at 11:03 PM
0

Attaching the screenshots


calview.jpg (70.7 kB)
tablfun.jpg (81.7 kB)
Share
10 |10000 characters needed characters left characters exceeded