COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: vinch999 on 17 Mar 2011 09:19:46 AM

Title: How to share reports
Post by: vinch999 on 17 Mar 2011 09:19:46 AM
Hi all,
I'm lost. I have to share my reports with remote users.

What are the possibilities?
-implement a web portal to the cognos server (the user run the report himself)
-Make active reports (with cognos 10) and send the mht file. (It's the easiest but I have problems with some objects (date prompt, value prompt) in active reports).
-...

What do you do personally to share your reports? Can you give me some advices
(Sorry for the bad english)
Title: Re: How to share reports
Post by: AussiePete2011 on 20 Mar 2011 07:34:27 PM
I think what you have to consider first and for most is security. 
What data are the end users allowed to see?
Are these users part of the same Corporate domain?
Do the users require CANNED reports or Interactive Reports?
If Canned, then in what format?

If interactive, then are these users in the corporate domain or not?  If not how do you filter the data specific to these users.

Etc etc etc
Cheers
Peter B
Title: Re: How to share reports
Post by: vinch999 on 22 Mar 2011 10:31:20 AM
I try to give access to the web portal from the internet . I use IIS 7

Currently the gateway is:

http://localhost:80/c10/cgi-bin/cognos.cgi (it works fine ;) )

I want to give access from:

http://www.site.com:80/c10/cgi-bin/cognos.cgi

What should I change in the configuration (Cognos/IIS)?
-Gateway URI,..

Sorry for the nooby question  ;D
Regards, vinc
Title: Re: How to share reports
Post by: AussiePete2011 on 22 Mar 2011 04:36:03 PM
Hi Vinc,

Thats cool.
Basically a couple of things need to be done.
First you need to change the Gateway in Cognos Configuration to use the Fully Qualified Domain Name (FQDN)
http://www.site.com:80/c10/cgi-bin/cognos.cgi

In IIS7
https://www-304.ibm.com/support/docview.wss?uid=swg21381516

The concern is if you have a proxy server setup as this may cause problems accessing the FQDN
The other issue you may hit is that you will need to add this address as a trusted site

Hope this helps
Cheers
Peter B
Title: Re: How to share reports
Post by: vinch999 on 23 Mar 2011 03:58:09 AM
Hi Peter, thank's for your support .
I already configured the IIS with this link https://www-304.ibm.com/support/docview.wss?uid=swg21381516. So,nothing more to do.
Then, the only thing to configure is the URI gateway

In fact the Cognos Server in on a Virtual Machine accesssible via VM.site.com.
In IIS, I have two bindings for the cognos site:
localhost and VM.site.com.
Maybe I have more to configure ...

EDIT:
I don't understand, I just changed the gateway and restarted the service but nothing changed. I still connect with localhost...
Title: Re: How to share reports
Post by: vinch999 on 01 Apr 2011 03:00:08 AM
Hi all,

I can access to the web portal from the intranet
http://localhost/c10 ==>OK
http://x.x.x.x/c10 ==>OK (x.x.x.x = localIP)

I cannot access from the internet (public IP)
What is the problem?
Maybe the DNS?
Any idea? ???

Title: Re: How to share reports
Post by: AussiePete2011 on 03 Apr 2011 04:27:17 PM
Hi there

I'd suggest looking at the host file under windows\system32\drivers\etc
Check to see if localhost is set there.
If it is, then add a #comment
Enter the IP address of the server and then tab across and enter the server name.  You'd need to do this per BI server and possibly per work station until the DSN router tables are updated.

Hope this helps
Cheers
Peter B