How to determine what reports use SQL Server view?

[BobaGreek]

Hello forum,

I need to alter a SQL Server view by adding new columns in there. Is there a way to find out what Cognos reports use that view?

Thank you,

Bob

[kristysmith]

I dont think there is a way, other than asking your users if they have reports built using that view.

[BobaGreek]

For some reason I though that Framwork manager might provide this information...I guess not

[kristysmith]

Sorry... in Framework... there is a "report dependency" that you can run by field or table. It will show all the reports that are dependant on the field or table.

[BobaGreek]

Great. Thanks  ;D

[MFGF]

Hi,

Be careful - if your view (or part of it) is used in a query subject, which is then used in another model query subject, which is then used by reports, the "report dependency" feature is not clever enough to detect this.

MF.