Cardinality defined in universe Design tool not showing in WEBi

[Former Member]

2 tables have 1-N relation ship between each other but when I take objects from both the tables in report then in query of report it is showing only innerjoin not the right outrt or left outer join

[amitrathi239]

defined cardinality you can not see in the webi sql.for right/left outer join you need to tick the check box while defining the joins between table in universe designer.