update a catalog

[neil2grow]

hello all
I have a huge catalog,I have created some additional views in the database,but the table list doesnt show me the new views.Does anybody know the reason for this.How can i updated my catalog to include the new views in impromptu.
Thanks in Advance
Neil

 

[griffindm]

Neil,

Do a keyword search on "Add View" on the Keyword Search tab here.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[neil2grow]

griffindm
I need to update a catalog after a new view or table is added to the database,i dont think cognos impromptu gives the new tables views to be selected for the old catalog .
Neil

 

[Coglearner]

This is Given by Griff..Please follow this , you will get the new views...


Views on any database will not automatically appear in Impromptu. Go to Tools | Options | General and turn off the checkbox for "Retrieve database tables when editing catalog tables". This will cause a new button to appear when in the Catalog | Tables screen that will say "Retrieve Tables". Pressing that button will produce another screen with checkboxes for the types of database objects to retrieve. Make sure that the view checkbox is selected. Your view should then be visible.

 

[CognosProfessional]

Click Verify Tables once you pick your new views from the list of tables.

CP