I have basic concept doubts about how creating star schemas...
That's my situation, i have 2 stars that shares one dimension query subject... i have read about stitch queries.. but i still don't know how to model it. I tried this way:
Add my "data source query subjects" to a namespace in the physical layer (but i don't create the relationships between them here), i create star schemas with the wizard and then i create the relationships between the shortcuts (in another namespace within physical layer). Doing that way, when i create the business view, i have to create two times the dimension that i have shared... the shortcuts i created are totally isolated and its behaviour its like they were different query subjects.
- Other possible way to do that is to mix shortcuts and datasource query subjects within the same physical layer but i don't know if that is a right way of modelling....
Thanks..