Inaccessible view user_mini-session referenced in retention

[Rups]

Hi, I am having some issues referencing a dimension from one view into another. (unable to post without the spaces in between some words)

dimension: retention {
type: d u r a t I o n d a y
s q l _ start: ${user . created _ date _ date} ;;
s q l _ end: ${user _ mini _ session . created _ date};;                                                                                                 The field I am referencing is ${user _ mini _ session . created _ date} where user_mini_session is the view name and I have followed the rules via online documentation. This is how the  dimension is currently saved via the other view:

dimension _ group: created {
type: time
timeframes: [raw, time, date, week, month, quarter, year, hour]
s q l: ${TABLE}."created At" ;;
}

The tables are also joined in the model, when I change the s q l _ end line the error has gone and is working fine. The explore itself with the error currently is calculating, I am just unable to save and push my changes to production.

The error I believe is due to the s q l _ end line, would I maybe need to create a derived table instead?

Appreciate any help here.