Skip to Content
-1

SAP HANA Parameter Mapping: Contant to two nodes with same source

Jan 17 at 12:37 PM

36

avatar image

In SAP HANA I can use Parameter mappings.

So I made a Table Function (UDTF) which expects two parameters.
(Depending on the parameters different results are returned)

I need both results in a Calculation View.

Unfortunately I am unable to map a Parameter to both data sources:
(In the picture below you see the mapping from node Level0and2 to the paramters,
when trying to do the same with the lower node the lines are drawn only from the upper node)

So I checked the XML and noticed that the mapping is done directly to the data-source (Not the node of the data source)

So it seems that it is not possible to map a parameter to two different nodes with the same data source:

10 |10000 characters needed characters left characters exceeded

This seems to be a bug

Work-around: use a table function. Here you can set the parameter for each required table-function:

select ...
FROM "SCHEMA"."package::TF_01bParentFlag"('%', '1') p2
    JOIN "SCHEMA"."package::TF_01bParentFlag"('1', '%') p1 
0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Feb 08 at 02:06 PM
0

Hello,

Please find the below link, I think its useful for you Issue.

https://help.sap.com/viewer/fc5ace7a367c434190a8047881f92ed8/2.0.02/en-US/b02314c95e664cf5bb592b15a2125d52.html

Thank you,

Sathya.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

This is not a solution. It only says that it is not possible

0
Thorsten Niehues Feb 20 at 09:50 AM
0

Since the underlying object was a Table Function anyway.

I wrote another table function selecting the two table functions.

Then it is possible to give each Table Function the correct parameter.

Like this:

select *
FROM "SCHEMA"."meag".package::01b_ParentFlag"('%', '1') p2
    JOIN "SCHEMA"."package::01b_ParentFlag"('1', '%') p1 
Share
10 |10000 characters needed characters left characters exceeded