C10 Model-CQM upgrade to C11-DQM

[cogtrack]

Hi,
I am working on Cognos 10 to Cognos Analytics upgrade.
I have a Cognos 10 model, use Compatible query mode
how to switch this model to use Dynamic query mode?
as we want to use DQM in Cognos Analytics, to see if can get better report performance.
This is what I did today:
I opened C10 model in FM 11, tried to switch the Query Mode in Project properties, but received error:
BMT-IMP-0017 You cannot enable Dynamic Query Mode. The model contains data source(s) of unsupported type(s): OD
(we created both odbc and jdbc data source on Cognos connections)
how to change it to DQM? or I don't need change the model, there is setting somewhere else to enable DQM? hopefully I don't need recreate the model in FM 11.

Any thoughts appreciated.

[MFGF]

Hi,
I am working on Cognos 10 to Cognos Analytics upgrade.
I have a Cognos 10 model, use Compatible query mode
how to switch this model to use Dynamic query mode?
as we want to use DQM in Cognos Analytics, to see if can get better report performance.
This is what I did today:
I opened C10 model in FM 11, tried to switch the Query Mode in Project properties, but received error:
BMT-IMP-0017 You cannot enable Dynamic Query Mode. The model contains data source(s) of unsupported type(s): OD
(we created both odbc and jdbc data source on Cognos connections)
how to change it to DQM? or I don't need change the model, there is setting somewhere else to enable DQM? hopefully I don't need recreate the model in FM 11.

Any thoughts appreciated.

Hi,

If you select one of the data source object(s) in FM and look in the Properties window at the bottom, you will see a section you can expand called "Type". Expand this, and you will see a property called Interface. This is where the 'OD' value is defined, and 'OD' indicates an ODBC data source (which is not valid for DQM). Is the JDBC connection a different data source name? If so, you're going to need to rename the data source object in FM to take the name of the JDBC connection, and you will need to change the Interface property from OD to JDBC. Once you have done this, you should then be able to select the top-level project object in the explorer tree and change the Query Mode property from Compatible to Dynamic.

Note - you might hit some errors during the upgrade validation process, where you have done odd things in the model. DQM seems to be a lot more picky about syntax and correctness than CQM, so you might need to check the DQM logs to see what errors it reports if the DQM upgrade fails or stalls.

Good luck!

MF.

[Kiran P]

Hi MFGF,

If we want to maintain the FM project in Compatible Mode but publish the package using 'Publish in Dynamic Query Mode' option, will it work if data source is defined for both the native connection as well as JDBC?

Thanks,
Kiran

[MFGF]

Hi MFGF,

If we want to maintain the FM project in Compatible Mode but publish the package using 'Publish in Dynamic Query Mode' option, will it work if data source is defined for both the native connection as well as JDBC?

Thanks,
Kiran

Is it a single data source with both JDBC and native client connectivity defined, or is it two different data sources?

If the former, yes you can do it. If the latter, then no.

MF.

[Kiran P]

Yes, it is the same data source.

Actually we are on 10.2.2 in production and created a test environment for 11.0.5 and we want to publish DQM packages from existing CQM project and test usage of package in dashboards as well as features like multiple packages in reports etc. I was trying to make sure our approach to using the same project for both type of modes is correct.

Thanks for clarification.

Regards,
Kiran

[cogtrack]

@MFGF, Thanks a lot!

[MFGF]

Yes, it is the same data source.

Actually we are on 10.2.2 in production and created a test environment for 11.0.5 and we want to publish DQM packages from existing CQM project and test usage of package in dashboards as well as features like multiple packages in reports etc. I was trying to make sure our approach to using the same project for both type of modes is correct.

Thanks for clarification.

Regards,
Kiran

Hi,

In some situations DQM behaves rather differently than CQM, so you're going to need to test your existing reports very carefully to make sure they still work and return correct results. Lifecycle Manager can be a very useful tool when doing this.

Good luck!

MF.

[Kiran P]

Hi,

In some situations DQM behaves rather differently than CQM, so you're going to need to test your existing reports very carefully to make sure they still work and return correct results. Lifecycle Manager can be a very useful tool when doing this.

Good luck!

MF.

Sure. Thanks.

Kiran