Why non indexed columns are set as facts in usage property in cognos framework manager??
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.
QuoteFramework 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).
Quote from: bi4u2 on 25 Jul 2014 12:02:36 PM
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?
Quote from: Joker on 28 Jul 2014 05:35:33 AM
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.