Hi,
I am working on changes to an FM 8.4.1 Model migrated to FM 10.1.1.
When I run the Model Advisory on an object combination, say one fact and one of it's reference objects at the database layer, it reports Facts Identified by Cardinality.
My fact has:
All FKs set to identifiers
All Measures set to facts
relationships created are; Fact (1:n) to the PK in each reference object (1:1)
I would like to ask could be the possible causes why the Fact Query Subject is not interpreted by FM 10.1.1 to be a Fact Query Subject, and what effects can this have on the model and it's performance.
Fact detection and the correct use of cardinalities is not about performance, but about generating correct SQL . I am afraid that the rest of your post escapes me ;)
When you run the Model Advisor, I think you are interpreting the message "Facts Identified by Cardinality" as a bad thing. It is not an error message or a warning, it is simply an informational message letting you know that based on you having a 1.n relationship on the query subject that your fact is in, it is able to properly identify it as a fact. This is the key piece of Cognos being able to write the sql that will allow this fact to correctly aggregate.