[SOLVED] Relationships In Framework Manager

[Cognos Apprentice]

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

[cognosfreelancer]

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

[Cognos Apprentice]

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

[BIsrik]

check the database view...in the model..

Srik