Skip to Content
1

HANA Cross Join

Dec 02, 2016 at 02:22 PM

342

avatar image
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?

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

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded