HANA Cross Join

[Former Member]

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?

[kapil_tilwani · Accepted solution]

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