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
this might help
http://cognosm.blogspot.com/2019/03/dqm-in-cognos-analytics.html
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.
Quote from: dougp 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.
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.