This unfortunaltey has been a long standing gripe of mine. The only means of mitigation will be to create a deddicated dimension, My DB has swollen in size due to this limiting factor (I have many example of where the “Code” is something I need to remove). Here is the original post I made back in 2019: