Skip to Content
0
Jan 11, 2014 at 08:32 PM

CE JOIN on between fields

38 Views

Hey Devs!

it might be probably an easy question but I didn't find a thing about it. I tried joining on a field which is between a lower and a upper value. As graphical views only provide equal joins I tried the same in a CE based calculation view. Nevertheless it didn't work either 😔

So I can use SQL in the CE calculation view to implement this kind of non-equal join but I really want to avoid any mixing of CE and SQL.

Therefore a short question: Is there a way to implement such a join on between based on CE functions? Or any workaround to do this?

In my example I want to join the time dimension table in HANA with a valid from / valid to based table (the between values).

Regards,

Marcel