COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: mike.son on 29 Mar 2012 09:14:59 AM

Title: SQL - Conten Store - ReportURL
Post by: mike.son on 29 Mar 2012 09:14:59 AM
hello,

i created a select againts the content store, to get information about reports. It's possible to show the path, report name, ...
Now i want to select the url of the report, to link the report.

Which table include this information?

thanks

mike.son

Title: Re: SQL - Conten Store - ReportURL
Post by: mike.son on 25 Apr 2012 04:22:36 AM
I resolved the problem. Now it's possible to link the reports. I have created the url itself. First i used an hierarchical select of the public folder, to get the full path of the report.

The Script concat the reportpath with the 'http:'-part e.g.:

http://servername/ibmcognos/...||reportpath