changing DATA SOURCE in FM

[pooja]

please guide..How to change DATA SOURCE IN FM

thank you in advance.....

[blom0344]

If you want to point the data source to another database, then change the properties in Cognos connection --> Configuration of the corresponding datasource.
The datasource in FM is just a Cognos label that corresponds to the one used in connection (Content Manager Data source) 

[pooja]

bloom,

here is the case--we have a model pointing data source "AD1" with qualifier "a1dev", which belongs to test region.
now, since all the tables moved to production region data source and qualifier also changed to "AP1" and a1prod.
now our concern is , how to change data source and qualifier for existing model.

thank you in advance for great help

[tupac_rd]

make a copy of the FM model, and in the model.xml file do a find replace. Will this work?

[pooja]

thak you ,

suppose change has been mande on model.xml. now what would be the next step?would you please xplain more
thank you again for gr8 help.

[tupac_rd]

same as what you did with the earlier datasource, I believe. Test a couple tables in FM to make sure they are working fine and publish the package etc.,

[Heba_elfaid]

Simply you need to create a new data source in cognos connection referring to your production data source then you will need to change the name of content store connection name in the framework manager to the new name you just created.

if you need the detailed steps just feed me back

[bloggerman]

Normally, we tend to have 2 different environments, one for prod and one for Dev....In such case you create connections in the cognos connections for the 2 environment with the same name. You keep the same label in FM too...As you move the package from Dev to Prod the FMs would point to the right databases......

If you want to remain in the same cognos environment and switch between Dev and Prod then you would need to do as suggested above.