Model - Inbound and Outbound Relationships

Hello folks

I have a very basic doubt. I am deploying a model and I don't know what Inbound and Outbound Relationships mean. Are they always necessary for foreign definitions?

Can someone explain me this?

Regards

Hi,

The Inbouds Relationships is added where you have the primary key.
The Outbounds Relationships is added where you have the foreign key.

If you add an inboud relationship, an outboud in automatically added in the other table and vice-versa.

If your database is correctly built, these relations are added automatically and you don't have to do anything.

Your model needs these informations to create the links between tables when you are using your Qbe.

Guillaume

Hello,

The Inbouds Relationships is added where you have the primary key.
The Outbounds Relationships is added where you have the foreign key.

Do you talk of the physical tables which must have the primary key and foreign key defined or of the business model (identifier)?

Greatings,

Eric

If your keys (primary and foreign) are defined in physical tables, relationships will be automatically created in business model but you can always add others relationships or remove existing ones.

Hello,

Than you for the tip.

Greatings,

Eric

guillaume@altic.spw wrote:Hi,
If your database is correctly built, these relations are added automatically and you don't have to do anything.

Can you please give more details on mysql? I used hibernate with annotations to build my mysql-db with innodb. Within phpMySQL i see the foreignkeys being created correctly. But SpagoBI does not recognize them.

Thank you

Stefan

Hi,

Do you use SpagoBI Studio ? If you do not, try this way, it could fix your problem quicklier.
Seems strange relations do not appear. I built a datamart without the studio and there was no problem but it was several months ago.

BR