Skip to Content
-1

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

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:

Add comment
10|10000 characters needed 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 
    
  • Get RSS Feed

2 Answers

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20 at 09:50 AM

    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 
    
    Add comment
    10|10000 characters needed characters exceeded