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

[SOLVED] Relationships In Framework Manager

Started by agorsky, 14 Feb 2006 11:51:07 AM

Previous topic - Next topic

agorsky

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

agorsky

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