COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: lahdeb on 09 Jun 2017 11:04:24 AM

Title: import a new colonne in database view table
Post by: lahdeb on 09 Jun 2017 11:04:24 AM
Hello every one , I m new in frameworkmanager and I need your help please

In my database I modified a table (I add a new field) which is already used in my framework manager with its old format
My question may be sample but I don t know how to refresh my table in FM so I could find the new colon (c4) without importing all the table with new name , is that possible ?

database view (Framework manager)
table A
c1
c2
c3

Oracle database
table A
c1
c2
c3
c4


thank you
Title: Re: import a new colonne in database view table
Post by: MFGF on 09 Jun 2017 11:09:28 AM
Quote from: lahdeb on 09 Jun 2017 11:04:24 AM
Hello every one , I m new in frameworkmanager and I need your help please

In my database I modified a table (I add a new field) which is already used in my framework manager with its old format
My question may be sample but I don t know how to refresh my table in FM so I could find the new colon (c4) without importing all the table with new name , is that possible ?

database view (Framework manager)
table A
c1
c2
c3

Oracle database
table A
c1
c2
c3
c4


thank you

Hi,

The trick is to select your query subject for Table A, then from the menubar go to Tools > Update Object

This will bring in the new column or columns added to the underlying table.

Cheers!

MF.
Title: Re: import a new colonne in database view table
Post by: lahdeb on 09 Jun 2017 11:11:22 AM
thank you a lot , I found it

Good weekend :D