Can't join on constant (slow changing dimension)

Bug reports
1

Hi, i'm not able to create a join on visual UI that uses a constant value as part of a join.
Example:

SELECT * FROM table t2
JOIN table2 t2 ON t1.code = t2.code and t2.last_version = 1

I'm able to do it on sql query but my model was already built and I don't want to change its id because this would lead us to rewrite 100+ questions that use the model.

2

Unfortunately you can’t do this in the gui questions yet

3

Create a view, that includes a concatenation of the two columns. Then create an index of that concatenation.