How to import newly added columns in the DB to FW model ?

[pravin.cognos]

Dear Gurus

I have a model which has table XYZ. The definition for this query subject is "Select * from Datasource connection name.XYZ". Now in the DB, new columns A,B are added to XYZ table. I need to import A, B columns to my XYZ query subject. I dont want to create a new QS as it has lot of joins. So I tried "Tools -> Update Object". But this didnot work.

I ran the Metadata Wizard again and dragged the table from my DB into the definition expression window. However this created a new definition as "Select * from Datasource connection name1.XYZ". I am not sure why is 1 suffixed to my Datasource connection name ?? Is this the correct way? Is there any unseen harm in this ??

Is there any other way to update my existing QS to fetch the newly added columns from DB??

We are using Cognos 8.3 and MS SQL 2008

Please help !!

Thanks
Pravin

[blom0344]

From the menu you can use the 'update object' from the Tools submenu  on 1 or a selection of already existing subjects..

[cognostechie]

The Tools -> Update Object usually works and if it doesn't, then shut down FM and restart it and then do it. Another way to do that is to go to the 'Test' tab and Test it. While fetching the data, it also brings in the new fields.

[tkierzko]

Thanks for this post! It helped save some time trying to figure out the exact same issue I was having!

[LR]

Thanks it works!