All,
Kindly help me to understand the migration from CQM to DQM.
please tell me how complex is it?
will there be any issues once we migration at report level or FM level?
Appreciate your response.
Thanks
Uma
Quote from: umareddy0706 on 20 Feb 2017 08:12:12 AM
All,
Kindly help me to understand the migration from CQM to DQM.
please tell me how complex is it?
will there be any issues once we migration at report level or FM level?
Appreciate your response.
Thanks
Uma
Hi,
Here are a couple of recent posts that provide the answers you are looking for:
http://www.cognoise.com/index.php/topic,32419.0.html
http://www.cognoise.com/index.php/topic,32400.0.html
Is there something more specific you need to know?
MF.
Hi MF,
thanks for your reply.
There are the lines I see in recent posts. ( But I see in the interface .. "OR" instead of "OD") .. how can it be ?
Thank you !
Previous Post comments...
_________________
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.
Quote from: umareddy0706 on 20 Feb 2017 08:56:14 AM
Hi MF,
thanks for your reply.
There are the lines I see in recent posts. ( But I see in the interface .. "OR" instead of "OD") .. how can it be ?
Thank you !
Hi,
OR is (I assume) an Oracle connection? Is that where your data lives? Is the connection on your Cognos server defined just as OCI, or is there a JDBC connection set up too? You can find out if you log in to Cognos and launch the Administration Console > Configuration tab > Data Source Connections, drill into the data source and then edit the connection properties. You will see both an OCI tab and a JDBC tab:
(https://image.ibb.co/fVKtsk/Oracle_Connection_zpslmisd8bc.png)
Assuming both are set up and working properly, it's fine to leave the data source type as OR in Framework Manager.
Cheers!
MF.