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

Defining Relationship between tables

Started by Manu0521, 08 May 2015 12:14:00 PM

Previous topic - Next topic

Manu0521

Hi,

I have two tables the first is user logon table and it has
UserName,Sessionid,logontime,logofftime and LogoffInformation and Request ID.

A session id will be generated for each login and request id will act as primary key , since a user can login more than once.

Second table is Report-Run table which will have the details of the report run by the user on each session.
In one session there can be many reports run.

columns will be  Session ID ReportName ,ReportDetail.


Now I have to define cardinality between these two tables and I have doubts on what cardinality it would be .

I know its going to be a left join between Userlogon and Report Run table.

But in FM

is this 1:N to 0:N
or
1:1 to 0:N

which means a session id can have 0 or many reports , I am fine with it.
but what would be the reverse ?

I always get confused in defining the reverse relationship.

Thanks,