COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Framework Manager => Topic started by: Abdel on 22 Jun 2015 05:38:34 PM

Title: Add one field to an existing table
Post by: Abdel on 22 Jun 2015 05:38:34 PM
I am having the toughest time performing a very simple operation on Framework Manager/Database layer.  That is, adding one field to an already existing query in FM.

Simply, I have added one new field to my SQL Server data warehouse table and want to include that new field in my namespace/query in order to use in report studio. How do I do this without throwing an error?

Abdel
Title: Re: Add one field to an existing table
Post by: cognostechie on 22 Jun 2015 05:43:39 PM
Click on the query subject in the Database Layer, from 'Tools' menu select 'Update Object'. The new field will show up
Title: Re: Add one field to an existing table
Post by: Abdel on 22 Jun 2015 05:56:15 PM
That worked. Thank you so much!!!!


Abdel