Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: Victor on 30 Mar 2007 01:29:19 PM

Title: Drill-through feature does not work in IWR
Post by: Victor on 30 Mar 2007 01:29:19 PM
Hi,

I was wondering if anyone else has ever encountered this issue before. I have a drill-through report that works fine in Impromptu but doesn't work when it is published to the web. I have the report set to open up with Adobe Reader 7.0 and when I click on the drill-through link in the report nothing happens. I tested the report on a computer with Adobe Reader 6.0 and it seems that IWR tries to open the report when I click on the drill-through link, but I end up getting an error message that just says "Unable to execute report". I have the drill-through report published to the same newsbox as the report that has the drill-through link and if I run the drill-through report on the web directly, it opens up fine. Any helpful comments or suggestions would be appreciated. Thanks.

Victor
Title: Re: Drill-through feature does not work in IWR
Post by: COGNOiSe administrator on 31 Mar 2007 06:16:14 PM
Any popup blockers? What's the version of Impromptu?
Title: Re: Drill-through feature does not work in IWR
Post by: Victor on 02 Apr 2007 10:57:10 AM
No pop-up blockers that I'm aware of and the version of Impromptu is version 7.3 MR3.
Title: Re: Drill-through feature does not work in IWR
Post by: COGNOiSe administrator on 02 Apr 2007 11:03:22 AM
Is the webserver in your IE trusted zone? Any URL filters on the webserver? In the past, URLScan would block some of the drill-through reports for me.
Title: Re: Drill-through feature does not work in IWR
Post by: Victor on 02 Apr 2007 01:42:14 PM
Yes, I have the webserver as a trusted site in IE. I don't believe that there are any URL filters on the webserver but I'm not completely sure. Is there a simple way to check for this?
Title: Re: Drill-through feature does not work in IWR
Post by: COGNOiSe administrator on 02 Apr 2007 02:03:38 PM
Would you be able to capture the URL for both, direct and drill-through actions?
Title: Re: Drill-through feature does not work in IWR
Post by: Victor on 02 Apr 2007 06:44:06 PM
Here is the URL for the drill-through action:

http://sotest001/cognos/cgi-bin/imrap.cgiAFDATAIU=IMRAP&CD=GetTemplate&TNAME=iwr_255fdrillthrough_252eutml&DCD=Drill&E=POCommitDetails&DID=417abfa1d73c11dbbf808071d0362b9b&FT=_255b_2522Contract_2522_2520_253d_2520_252224069_2522_252c_2522Account_2522_2520_253d_2520_25220325_252d000_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2520_2522_255d

And here is the URL for running the report directly:

http://sotest001/cognos/cgi-bin/imrap.cgi?IU=IMRAP&CD=DV&nia=View&nid=c90c7599dc9811dbb2d6e6440cd89fa6&nih=1&back=http%3A%2F%2FSOTEST001%2Fcognos%2Fcgi%2dbin%2Fupfcgi%2ecgi%3Fxmlcmd%3D%3CGetPage%3E%3CTemplate%3Emain%2eutml%3C%2FTemplate%3E%3C%2FGetPage%3E%26id%3Db8f485badc9811dbb2d6e6440cd89fa6

I'm guessing that the drill-through URL probably isn't normal in some way.
Title: Re: Drill-through feature does not work in IWR
Post by: COGNOiSe administrator on 02 Apr 2007 07:26:26 PM
Yup, the drill-through is missing a ? right after imrap.cgi. Might be a bug or misconfiguration. Where it says AFDATA it should say just a ?.
Title: Re: Drill-through feature does not work in IWR
Post by: Victor on 02 Apr 2007 07:33:18 PM
Ok now if it is in fact a bug, would you say that it is being caused by IWR or would it possibly have something to do with Upfront? I don't really understand how the IWR/Upfront interface works so any clarification on that would be appreciated. By the way, thanks for your help so far.
Title: Re: Drill-through feature does not work in IWR
Post by: COGNOiSe administrator on 03 Apr 2007 11:32:28 AM
If I recall correctly from my IWR days, the drill through is generated by one if iwr templates. I don't have a copy running right now, so I will have to ask you poke around webcontent and other cognos directories, looking for them. One option would be to use something like fgrep for Windows, or UltraEdit (my all-time favorite text editor), and search all Cognos subdirectories for one of these keywords (imrap, gateway, IU, CD, DV) in *.tmpl files, then in *.*. You will eventually find it. Also, I'd check Fix Lists for IWR versions higher then yours, looking for any related bug fixes.

Last, but not least, consider moving to ReportNet or Cognos 8. Much more fun and it looks pretty, too! Although Cognos Connection is not nearly as customizable as Upfront. But reports design tools in the above open far more possibilities then Impromptu.
Text only | Text with Images