Determinants provide control over granularity for query subjects.
If a query subject has determinants, each query item of the query subject must be included in one
of the determinants.
Determinants are processed in the order in which they are specified in the model. You can change
the order of the determinants. If a query subject has more than one determinant, the first one that
covers all the requested items is used. Determinants are evaluated in the context of each required
join as well as the context of requested items.
Data source query subjects are imported with determinants defined for them. These default
determinants are generated based on keys and indexes in the data source.
Model query subjects do not have determinants defined for them automatically. If determinants are
needed, you must define them manually.
Stored procedure query subjects do not have determinants.
You cannot use determinants with user-entered SQL that was specified in a query defined in
Reporting.
Procedure
- Click the query subject you want, and click Actions,
Edit Definition.
- Click the Determinants tab.
- Click Add under the Determinants box.
The entry New Determinant displays in the box. To give this entry a
meaningful name, right-click it, and click Rename.
- To define a key, right-click a query item in the Available items
box and click Add as Key.
Tip: You can also drag query items to the Key box.
- To identify which query items should be associated with this determinant, right-click
query items in the Available items box, and click Add as
Attributes.
Tip: You can also drag query items to the Attributes box.
You can have a determinant with no attributes defined for it. Framework Manager uses this type of
determinant to indicate which query items are indexed.
- To specify that the selected determinant should be used as the unique identifier, select
the Uniquely Identified check box.
Do this only if the data in this item is unique for every row in the underlying data source.
You can specify more than one unique determinant if they are truly unique. At query time, the
relationship being used will determine which unique determinant to use.
- Select the Group By check box to indicate that when keys or
attributes associated with that determinant are repeated in the data, IBM®
Cognos® Analytics
should apply aggregate functions and grouping to avoid double-counting.
- If you want to change the order of the determinants, use the arrow buttons.
Determinants are processed in the order in which they are specified in the model.
- Click OK.