Change of Column Name in Database Table

[srinu1253]

I have a Question for you in Cognos Administration. Consider I have 100 reports in Report Studio. FM layer is fine. But the issue is Column name in a Table has been updated. So obviously the reports that are pointing to the table will not run. Is there any atomized way to know how many reports are affected from Cognos Administration point of View? Could you please let me know? Thanks

[MFGF]

I have a Question for you in Cognos Administration. Consider I have 100 reports in Report Studio. FM layer is fine. But the issue is Column name in a Table has been updated. So obviously the reports that are pointing to the table will not run. Is there any atomized way to know how many reports are affected from Cognos Administration point of View? Could you please let me know? Thanks

Hi,

Reports don't point to a table directly. They point to metadata in a package, and it's the metadata that links the report to the table. If you have designed your FM model using a layered approach, you can isolate your reports from name changes in the database - you can update the lowest layer in FM to reflect the change, but leave the higher layer using the existing name, so none of the reports break.

If you did decide to change the name in the higher layer in FM, you can use the "Analyze publish impact" option (without re-publishing the package) to find out which reports would be affected if you were to go ahead and publish.

Cheers!

MF.

[nsaxena]

Its so interesting to read your reply. Thanks for MFGF for your active support in all cognos areas.