COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: omustafa on 04 Jul 2013 03:53:59 PM

Title: how to merge 2 fm model
Post by: omustafa on 04 Jul 2013 03:53:59 PM
Hi,

I have a question, what is the right way to merge two framework model using 2 different data source. after the merger do i need to build the relation between the query subject or FM will
take care of that?
thank you in advance.
Title: Re: how to merge 2 fm model
Post by: blom0344 on 05 Jul 2013 03:11:33 AM
Depends what you mean with merge. FM will not add relationsships on it's own..
Title: Re: how to merge 2 fm model
Post by: omustafa on 05 Jul 2013 08:36:43 AM
thank you blom0344,

what i meant by merge is  I have 2 FM models in porduction and since there is many reports using both model, we want to merge both model into one.
Title: Re: how to merge 2 fm model
Post by: blom0344 on 05 Jul 2013 04:01:32 PM
You can import metadata from one model into the other, though you need to make sure that the namespace references are not changed. If the 2 models have been originally build as completely seperate ones, then adding relationships may not be applicable.  Another approach is using segments. You keep 2 seperate models , but you can define packages over the combination.
Title: Re: how to merge 2 fm model
Post by: omustafa on 08 Jul 2013 10:38:17 PM
thank you blom0344

it works, thank you again.