Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: BobaGreek on 13 Dec 2007 09:59:34 AM

Title: How to determine what reports use SQL Server view?
Post by: BobaGreek on 13 Dec 2007 09:59:34 AM
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
Title: Re: How to determine what reports use SQL Server view?
Post by: kristysmith on 13 Dec 2007 10:38:52 AM
I dont think there is a way, other than asking your users if they have reports built using that view.
Title: Re: How to determine what reports use SQL Server view?
Post by: BobaGreek on 13 Dec 2007 10:53:36 AM
For some reason I though that Framwork manager might provide this information...I guess not
Title: Re: How to determine what reports use SQL Server view?
Post by: kristysmith on 13 Dec 2007 01:15:45 PM
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.
Title: Re: How to determine what reports use SQL Server view?
Post by: BobaGreek on 13 Dec 2007 01:51:05 PM
Great. Thanks  ;D
Title: Re: How to determine what reports use SQL Server view?
Post by: MFGF on 13 Dec 2007 02:15:09 PM
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.
Text only | Text with Images