XQE-PLN-0086 The aggregate 'count' can not be applied on the data item 'xxxxx_DA

[HelloCognos]

Hi, :) :)
Does anybody knows why I'm getting this error,
XQE-PLN-0086 The aggregate 'count' can not be applied on the data item 'xxxxx_DATE' because it implies the aggregation to be occurring after the calculation of detail values of multi-facts which can lead to double counting. The aggregate 'calculated/automatic' is more appropriate in this case as it ensures that the fact values are properly aggregated before being used in other calculation operations.

pls help if you can.

Thanks

[MFGF]

Hi, :) :)
Does anybody knows why I'm getting this error,
XQE-PLN-0086 The aggregate 'count' can not be applied on the data item 'xxxxx_DATE' because it implies the aggregation to be occurring after the calculation of detail values of multi-facts which can lead to double counting. The aggregate 'calculated/automatic' is more appropriate in this case as it ensures that the fact values are properly aggregated before being used in other calculation operations.

pls help if you can.

Thanks

Hi,

What specific version of Cognos Analytics are you using? There was a defect prior to 11.0.9 that could result in these kinds of messages:

https://www-01.ibm.com/support/docview.wss?uid=swg1PI88989

I think if you're using 11.0.9 or later, this was fixed.

Cheers!

MF.