To my knowledge, the concept of the "derived view" had not been transferred to calculation views.
I would probably go down the route of developing the dimension view as far as possible and copy the final variant for each different "role" the dimension needs to play.
This is, fairly clearly, added maintenance in the situation where there really is the 1:1 relation between all "derived" dimensions and only the semantic meaning of the relationship to the fact table changes. However, in many situations a change in the "role" that a dimension plays comes along with functional changes and at that point the dimensions stop to be the same but diverge.
But, yeah, that's what I make of this.
If this is a thing that really impacts you negatively, maybe it's something to put into the feedback tool for product improvement.
Hi Roland,
My 2 cents: can't synonyms helps you to keep your semantic on multiple views ?
Regards,
Frederic
Add comment