Interesting solution. I might have created a ud8 member with a formula
attached to it so as to retrieve and display the text value in a column
of a cube view.
That's correct. It's definitely flawed. But it's also useful, especially
if it avoids having to maintain (and consolidate) two different
structures. As in all implementations, there are multiple approaches
with multiple pros and cons.
Unless I'm not understanding the question correctly, there is a field
called Auto Translation Currencies in the entity dimension. You could
have an EUR entity tree to an EUR parent, but put USD in the Auto
Translation Currencies field. Of course if y...