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).