Rules for setting properties for query subjects

You can change the Usage and Regular Aggregate properties for all types of query subjects. The settings for these properties are based on characteristics such as data type and participation in keys and relationships.

For model query subjects, IBM® Cognos® Framework Manager uses the settings of the underlying query subjects. If the source query subject does not use these properties, the rules for data source and stored procedure query subjects are applied.

For data source or stored procedure query subjects, Framework Manager uses the following rules to set the Usage and Regular Aggregate properties when importing the query subjects.

Object	Usage property	Regular Aggregate property
Query item is part of a key in a determinant	Identifier	Count
Query item participates in a relationship	Identifier	Count
Query item is data type date or time	Identifier	Count
Query item is data type numeric or time interval	Fact	Automatic if the item is a calculation Sum if the item is not a calculation
None of the above applies	Attribute	Unsupported