Hi There,
We have something strange going on in the FM behaviour. Normally when you change a numeric field in FM from the automatically set fact (just because it's a number) to an attribute, the aggregation rules also changes from sum to count.
However sometimes it does not change the aggregation.
We are working with a database layer with unchanged tables. Based on the database tables we made query subjects in a separate (modeling layer) namespace. We make the changes in the modeling layer where it more often goes wrong.
We thought it was caused by specific datatypes or lengths, but can't seem to get it pinpointed. If often goes wrong when FM makes the datatype Int32
Also we noticed when we make the change in the database layer (where we dont want that), the aggregation DOES change correctly.
Database is oracle 11 (oracle 12 soon)
Cognos 10.2.1 FP8
Does anyone have any clue on what might be the cause of this behaviour?