Forum Discussion
Community ChampionMaster Models
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.
Super User
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.
- littlemojopuppy
I'd think this would be very difficult if pulling data from multiple source systems with different grain, keys, etc. But all the data feeding into the master model would be sourced from the enterprise data warehouse. I'd think that all the complexities with trying to get data to work well together would have been solved during ingestion into EDW (maybe?).
The master model (along with the subs) would almost be like "wrappers" so users could access the data from EDW with measures and relationships already defined for them, etc. Theoretically, in practice it would be very similar to MDX cubes.
