Print Page - How to move entire cognos FM model and reports from sql server to oracle

Title: How to move entire cognos FM model and reports from sql server to oracle
Post by: cgb on 28 Jan 2017 01:16:29 PM

I have a model in FM with sql server as source with around 80-90 query subjects. Now We want same model but only in oracle. Views are created in oracle. If structure (naming conventions) of views and columns are not same in sql server and oracle then how can we achieve this.

Do we need to recreate entire model from scratch right from importing data from oracle views, creating business and presentation layer or

Is there any way to use existing model by mapping to save time and efforts.

Title: Re: How to move entire cognos FM model and reports from sql server to oracle
Post by: bus_pass_man on 28 Jan 2017 03:38:18 PM

Well might you use the term mapping for there is a remapping tool in FM.

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_fm.10.2.2.doc/t_remap_an_object_to_a_new_source.html

http://www.cognoise.com/index.php?topic=28359.0

http://www.cognoise.com/index.php/topic,31048.msg101299.html

http://www.cognoise.com/index.php/topic,29271.msg94664.html

http://www.cognoise.com/index.php/topic,29738.msg96731.html

https://www.safaribooksonline.com/library/view/ibm-cognos-10/9781849685764/ch08s02.html

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: cgb on 28 Jan 2017 01:16:29 PM