Alberto posted one of the patterns we use designing a dimensional model (this one is about the discretization of a measure into a dimension). We’d like to get some feedback about this solution: is there someone who used similar patterns? We consider this design a good model for its flexibility (we used it in financial environments where desired clusters of measures changes but we don’t want to reprocess the whole fact table that is very very large).
Any feedback is welcome!