Detecting cardinality from the data source

When importing from a relational data source, cardinality is detected based on a set of rules that you specify.

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.

Note: All regular dimensions begin as query subjects. If you converted a query subject to a regular dimension, note that determinant information for the query subject is leveraged as a starting point to define the levels of a single hierarchy. Review the levels and keys created in the hierarchy of the dimension.