Compatible vs Dynamic Mode

[knip]

Hi All,
            Recently we have published all our packages with dynamic mode and to our surprise we found that all reports (crosstab reports) giving different aggregate values compared to the one in compatible mode. Do any one here have faced any similar issue?

[cognostechie]

I can expect the reports to stop working if they were made using CQM and later the package was published using DQM but if they are working I don't understand why they would show different values. One reason can be that Cognos does caching and CQM is probably reading from an earlier cache than DQM or vice versa.

[knip]

And sometimes we get this error

RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0086 The aggregate 'count' can not be applied on the data item 'Col1' 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.

[bdbits]

If you make the suggested change, does it resolve the error?

I seem to recall when DQM came out, Cognos said that the DQM engine was more stringent in requiring proper modeling - that CQM let you "get away" with some things that DQM did not. I wish I could recall the specifics, but you might want to double-check your model to be sure you are not doing anything unusual. Check you are using star/snowflake schemas with proper cardinality, and nothing funky like say many-to-many relationships. This is especially true if you have a DMR model, which it sounds like you might.

[schrotty]

Hi,

here are two good IBM-Documebts abiut DQM:

First about migration
http://www.ibm.com/developerworks/data/library/cognos/upgrade_and_migration/bi/page568.html

And second about DQM:
http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html

schrotty

[knip]

Suggested change did resolved error, but didn't return expected values on the crosstab, it returns empty crosstab

[bdbits]

Hi,

here are two good IBM-Documebts abiut DQM:

First about migration
http://www.ibm.com/developerworks/data/library/cognos/upgrade_and_migration/bi/page568.html

And second about DQM:
http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html

schrotty

Thanks for sharing those, schrotty. I knew about the 2nd one - the cookbook - but that first one is great for troubleshooting.