Detecting cardinality from the data source
The available options are
- Use primary and foreign keys
- Use matching query item names that represent uniquely indexed columns
- Use matching query item names
The most common situation is to use primary and foreign keys as well as matching query items that represent uniquely indexed columns. The information is used to set some properties of query items as well as to generate relationships.
To view the index and key information that was imported, right-click a query subject and click Edit Definition. For a query subject, you can change the information in the Determinants tab.
Optional relationships, full outer joins, and many-to-many relationships can be imported from your data source. IBM® Cognos® Framework Manager will run them as queries.