Forum Discussion
Solved
Master Models
Hi! I don't have an actual "solve this for me" type of question. More just looking for info. We expect to have a number of different semantic models such as "sales", "finance", "inventory", etc...
Also known as "Golden dataset". Mostly an exercise in futility, especially in larger organizations. cf "Expanded Tables"
I agree here that quite often, while it seems like it is great to create a golden data set in reality, this often doesn't happen as expected due to the complexities and different business areas. I would recommend trying to do one area at a time, and once you've got a handle on all the different areas over time, then see if it is possible to build a golden data set.
But if data stewardship and sound EDW design were in place...? Like the semantic models were almost the equivalent of an MDX cube pulling data from EDW it might work?
Ahahaha, good one... Yes, that would be great.
I see what you did there!!! 😅