If you are unable to create a new account, please email support@bspsoftware.com

 

Aggregation not always changed on changing id, fact or attribute

Started by wdv72, 04 Sep 2017 08:23:43 AM

Previous topic - Next topic

wdv72

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?