Usage Property

[Joker]

Why non indexed columns are set as facts in usage property in cognos framework manager??

[bi4u2]

Framework Manager normally interprets numeric data as facts. Sometimes you might need to change this to Attribute if the field is not truly data that you would want to summarize.

[Michael75]

Framework Manager normally interprets numeric data as facts. Sometimes you might need to change this to Attribute if the field is not truly data that you would want to summarize.

Or, indeed, you might need to change this to Identifier if the column in question is a surrogate key (these are not always indexed).

[Joker]

Framework Manager normally interprets numeric data as facts. Sometimes you might need to change this to Attribute if the field is not truly data that you would want to summarize.

So FM assumes the indexed columns as identifiers and non indexed numeric columns as facts.Isn't it?

[MFGF]

So FM assumes the indexed columns as identifiers and non indexed numeric columns as facts.Isn't it?

Columns defined as keys or used in indexes are assumed to be identifiers. For any other columns, FM then looks at the data type, and assumes any character data type columns are attributes and any numeric data type columns are facts.

Cheers!

MF.