Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bvk.cognoise on 24 Oct 2011 07:49:41 AM

Title: How to find out reports related to one package?
Post by: bvk.cognoise on 24 Oct 2011 07:49:41 AM
Hi ,

we have 300 reports.how to find out all reports which is developed using particular package?

thanks
vamsi
Title: Re: How to find out reports related to one package?
Post by: blom0344 on 24 Oct 2011 02:29:54 PM
This works - quite roughly for me:

Code Select

select distinct subselect.cmid,subselect.package,subselect.refcmid,ref1.name as report from
(select ref2.cmid as j,ref2.*,packages.name as package from
(select distinct c1.cmid,c2.name from cmobjects c1
inner join
cmobjnames c2 on c1.cmid = c2.cmid
where classid = 18) packages
inner join
dbo.CMREFNOORD1 ref2
on
ref2.refcmid = packages.cmid) subselect
inner join
dbo.CMOBJNAMES ref1
ON SUBSELECT.J = ref1.cmid
where isdate(ref1.name) = 0


provided contentstore is on SQL server   ;)
Title: Re: How to find out reports related to one package?
Post by: bvk.cognoise on 25 Oct 2011 03:10:13 AM
HI Blom,

thank you very much for your reply .i tried this method but i am not able to get correct result.could you please elaborate this.

thanks
bvk
Title: Re: How to find out reports related to one package?
Post by: blom0344 on 25 Oct 2011 03:43:23 AM
In my particular contentstore the classid 18 indicates a package. could be different with you installation, so it would be a matter of adjusting the id (to your particular value)
Text only | Text with Images