Skip to Content
Author's profile photo Former Member

Multi-joins on table in universe cardinality error

I was getting errors when trying to join two fields in one table to two fields in another table… “Invalid expression. Parsing of expression for the business object’, etc… “has a different cardinality than the detected cardinality”.   I joined the fields–> tables externally by dragging the field name in one table to the other table.   This works in sql… but not in the data foundation.   What  I had to do to correct this was select on link externally table1.field1 to table2.field2, then right click to edit the join. Once in the editor click and control click the 2 fields in table 1 to select, the click and control click the 2 fields in table2 that you want to link to.  Once I did this I was able to “detect cardinality” and it worked.  I’m not longer getting “join” errors when I do the integrity check.

dataFMultiJoin.jpg

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      An old post, but I've only just seen it as I've been away from SCN for a while (but not BO). I'd strongly recommend against using the detect cardinality functionality - the logic can be flawed. It's better to rely on the knowledge of the data model (obtain the ERD or data schema and use that for example).