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 add new columns from DB table to FM

Started by swarupa, 28 Dec 2015 02:29:53 AM

Previous topic - Next topic

swarupa

Few new columns have been added to existing DB table.
also DB is migrated to new version with all passwords is same as old DB.

Can anyone let me know step by step process to add new columns into FM? I have three Layers DB Layer, Business Layer and Presentation layer in FM..

bdbits

If you used "select *" star on the db layer, just update the query subject from the FM menus and the columns should appear. If you used specific SQL columns, you will have to modify the query subject yourself. In either case, get them added to the db layer as your first step.

Business/presentation layers should be selecting from the database layer, so once the above is done you should be able to select them like any other column you selected on those layers.