Hello Gurus--
This is a basic question. Do I need to explicitly set the relationships within the Object Diagram? I notice that with the gosales_goretailers model there are no relationships defined yet the model works. Does it use the column names to match/join? I set my relationships with my model but the Relationship SQL that is created uses nested queries for the join. Any info/advice you can offer is appreciated.
Thanks,
Aaron
As a general rule I never let the wizard create relationships for me when I import metadata. I just do it manually after importing. Sounds like more work but you will gave a good control over relationships.
Which database are you using. If it is Oracle then there is a known issue with importing all tables in one step. The relationship SQL features outer joins etc. You had better import one table at a time
HTH
NKT
Hi--
I don't let Cognos create my relationships for me. However, I notice that in Go Sales there are no relationships defined. It is confusing to me. I look at the Go Data Warehouse model and the relationships defined look like a spider web. Any insight you can offer?
Thanks,
Aaron
check the database view...in the model..
Srik