Hi Everyone,
I'd like to get your input on this topic. This is based on creating universes off the Information Design Tool.
Basically I have a bunch of fact tables that share many of the same dimensions.
Let's take this example.
I have 5 fact tables A,B,C,D,E
I have 5 dimensions V,W,X,Y,Z
Each of these fact tables are in a different subject area, so each fact would go into a separate business view.
Because the facts share dimensions, we have a looping problem so would you
a) Create contexts? It will save on creating table aliases, however your Master view will look like a huge spider web.
b) Create aliases? In my opinion it seems conceptually easier to understand and easier to manage (good for maintenance), however we run into the inefficiency of multiplying the amount of dimension tables. In our case we will have 25.
It would be appreciated to see everyone's thoughts on this.
Thanks!
David