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

How to Refresh Database Structure in Frame work Manager

Started by rajua99, 12 May 2010 11:19:28 AM

Previous topic - Next topic

rajua99

Hello,

I am trying to refresh my database structure in frame work manager in order to update according to the database but i cant find the option where to do it.
There is a change in the database table and i want to update my table in Framework with those changes so that i can use those objects as a Query Item.

Thanks
Raju

MFGF

Assuming the query subject you imported for this table originally is still set to the default 'select * from <table>', all you should need to do is to right-click the query subject -> Edit Definition, then click OK.  This should update the query subject to display an up-to-date set of query items.

Alternatively, if you edited the original SQL query, simply add in the new column(s) to the query and save.

MF.
Meep!

rajua99

Quote from: MFGF on 12 May 2010 11:40:06 AM
Assuming the query subject you inported for this table originally is still set to the default 'select * from <table>', all you should need to do is to right-click the query subject -> Edit Definition, then click OK.  This should update the query subject to display an up-to-date set of query items.

Alternatively, if you edited the original SQL query, simply add in the new column(s) to the query and save.

MF.

Thanks...I was able to update my Query subject using your solution.