Author Topic: How to modify a CQM package into DQM  (Read 501 times)

Offline avik1986

  • Full Member
  • ***
  • Join Date: May 2017
  • Posts: 29
  • Forum Citizenship: +0/-0
How to modify a CQM package into DQM
« on: 09 Oct 2020 01:08:37 am »
Hi Team,

There are few packages which are getting use for almost 15 years. Lots of many to many relationships are present also within that. Could you please guide how to modify the package into DQM as customer wants to use 64bit server.

Regards,
avik1986

Offline Francis aka khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 545
  • Forum Citizenship: +26/-4
    • CognosM

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 631
  • Forum Citizenship: +23/-1
Re: How to modify a CQM package into DQM
« Reply #2 on: 05 Jan 2021 12:28:35 pm »
The short answer:
Open the model in Framework Manager, change the query mode from Compatible to Dynamic, publish packages.

Be sure to test all of your reports.  DQM is less forgiving.

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,202
  • Forum Citizenship: +662/-10
  • Cognos Software Muppet
Re: How to modify a CQM package into DQM
« Reply #3 on: 05 Jan 2021 12:44:33 pm »
The short answer:
Open the model in Framework Manager, change the query mode from Compatible to Dynamic, publish packages.

Be sure to test all of your reports.  DQM is less forgiving.

You might also need to change the data source, depending which you are using. DQM requires a JDBC connection whereas CQM uses native client.

When you make the change to query mode in FM, your model will get verified. Past experience proves this to be a painful and laborious process where the process stops or hangs because of crazy things that were done (and not flagged as illegal) in the CQM model. You'll end up scouring the Dynamic Query logs to find out what is causing each issue. Then you fix it, try again, and hit the next issue. And so on. It can take a lot of time, so don't underestimate the scale of the task ahead of you. Once that is done, your next task (as Doug says) is to test the reports.

Cheers!

MF.
Meep!