can we migrate existing FM model from CQM to DQM?

[umareddy0706]

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

[MFGF]

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.

[umareddy0706]

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.

[MFGF]

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:


Assuming both are set up and working properly, it's fine to leave the data source type as OR in Framework Manager.

Cheers!

MF.