Overriding Automatic Cardinality Detection

As discussed in Identifying Query Traps, Style Studio automatically detects query traps known as the chasm trap and the fan trap by analyzing the cardinality and connectivity of relationships between tables. As a result, Style Studio is able to generate an appropriate warning message when a report developer or end user constructs a data model binding that creates a query trap. Because Style Studio generates these warnings automatically, you do not need to manually analyze your model for query traps in general.

The automatically-detected cardinality for a join is indicated by a fan icon on the join link. However, if you need to override the automatic cardinality detection, you can do this by manually specifying the relationship between tables associated by a join.

 

To manually specify the cardinality relationship for a join, follow the steps below:

1. Click on the desired join line to select the join.

2. Right-click the join, and select 'Properties' from the context menu. This opens the 'Join Properties' dialog box.

 

3. In the 'Join Properties' dialog box, click the Options tab.

4. Select the desired cardinality relationship in the 'Cardinality' section, and click 'OK'.

 

The 'fan' icons on the ends of the join links will update to reflect the cardinality relationship that you have specified.

<< Changing the Join Operator © 1996-2013 InetSoft Technology Corporation (v11.5) Resolving Loop Traps >>