COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: ry1633 on 31 Jul 2015 08:53:04 AM

Title: updating views or objects in model
Post by: ry1633 on 31 Jul 2015 08:53:04 AM
Hi all,

I have a question, might seem rudimentary but this is the first time that I've come across this issue.   When there are changes made to the underlying data structure (like adding fields to a data view),   does Framework Manager "know" to update the model automatically?  Or, do I have to go through and manually update everything?

-ryan
Title: Re: updating views or objects in model
Post by: Michael75 on 31 Jul 2015 09:07:29 AM
Hi,

No, FM doesn't "know automatically". Updating your model to reflect structural changes is under the control of the modeller, and I wouldn't like it to be any other way.

Click on the data source query subject(s) that have changed (you can do Ctrl+Click if there are several), then choose Tools - Update Object. You should then have a QS which reflects the changed table or view.
Title: Re: updating views or objects in model
Post by: ry1633 on 31 Jul 2015 09:10:36 AM
ok, that's helpful.  I just wasn't sure.
Title: Re: updating views or objects in model
Post by: ry1633 on 07 Aug 2015 12:25:49 PM
if the data structure itself stays the same (field names, columns, etc), but gets updated with new data entries, will FM know to update the data?  Or will I have to update my model every time there is new data added inside a table or view?     This could be potentially burdensome if I have to keep re-updating and re-deploying the same package over and over again.
Title: Re: updating views or objects in model
Post by: cognostechie on 07 Aug 2015 03:23:07 PM
Updates and publishing the package again is not required when the data gets changed/added in the tables. That being said, there is caching in Cognos which may prevent sending the query to the DB for some time but you can disable the cache.