Skip to Content
avatar image
Former Member

HANA Cross Join

For one of our cases, we need a cross join between two nodes but HANA is allowing only left and right join, how do I do a cross join between two nodes in a Graphical Calculation View?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 15, 2017 at 02:35 PM

    Hi Nikhil,

    You can introduce a dummy column into a projection returning a constant (say 1) in both the nodes you intend to join. Join on the dummy columns. So, technically it is still an inner join but effectively a cross join.

    Regards,

    Kapil

    Add comment
    10|10000 characters needed characters exceeded