If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating Star schemas

Started by churchy, 19 Feb 2008 09:18:31 AM

Previous topic - Next topic

churchy

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..