BusinessObjects Board

Setting cardinality or not?

building semantic layer
#1

I have inherited a universe that someone else built and a lot of the joins do not have a set cardinality. The universe works but is there a benefit at this point to go back to all of the joins and set the cardinality?

Secondly a lot of the joins are defined as complex (box between the tables when looking at the join says complex) but the joins are not complex. These are straight single field equal to joins but when the person created the joins a carriage return was added to the end of the join statement. If I take out the carriage return the complex designation goes away. Does anyone see a benefit to spend the time cleaning this up by taking out the carriage returns other than it would be cleaner?

There are a ton of joins that would have to be modified.

jbarnes794 :us: (BOB member since 2008-06-13)

Cardinalities of Joins in Universe
#2

Cardinality settings are primarily used for the loop resolution wizard, where it is able to suggest contexts or aliases based on the patterns of one to many joins. Removing carriage returns from joins won’t change the SQL either, not in a functional sense anyway. So it’s really up to you and how much free time you have. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)