If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Import new columns in existing Model

Started by cognostechie, 07 Nov 2006 04:03:24 PM

Previous topic - Next topic

cognostechie

I have a package working with Oracle DB. They added some fields to existing tables. How do I bring those new fields in my tables (Query Subjects) ? When I run the Import Metadata wizard again, it brings the new fields but in a seperate query subject and it doesn't let me merge them to the same query subject.

Sorry, am new to Framework Manager.

Thanks

almeids

Right click subject and select "Update Query Subject"
Steve

Blue

Select the querysubject, under the Tools menu option select Update Object.

If this doesn't work then

Right click on the query subject and select Edit Definition.  If the SQL is just SELECT * FROM table then delete this and drag the table from the list on the left into the SQL pane.  If the query subject is shows Query Items and Calculations instead of SQL for the right hand pane the use the Add option at the bottom of the window.
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand

cognostechie

Thanks Blue !!  The 'Update Object' worked.


Arpitagrawal9

Also you can Edit the defination of the Query Subject which would automatically refresh the columns present.But you need to add the columns in Consolidation view manually in case you have it.