Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
10 replies Latest Post - ‏2014-05-29T15:31:21Z by shaurya123
SystemAdmin
SystemAdmin
1959 Posts
ACCEPTED ANSWER

Pinned topic Problem rendering Cognos 10 reports in iFrame

‏2013-02-11T15:45:34Z |
Hello,

I am new to Cognos. We are trying to get our application to render Cognos 10 reports in iFrame. We have just recently upgraded from Cognos 8 to Cognos 10.

Our application uses an identity management service called eAuthentication (eAuth). The idea is to have one login for every application. Users can sign up online or see a local registration officer depending on the eAuth level they need.

eAuth uses a Computer Associates (CA) product called Siteminder to protect applications. You install siteminder on your public facing webserver and when someone goes to the URL they are redirected to a eAuth login page. Once the user logs in they are allowed to proceed to the site.

We had problems getting eAuth to work with Cognos. The way siteminder was configured at the OCIO wouldn’t allow Cognos to communicate with the server. We ended up having to take the “Siteminder light” approach.

Basically, we store the users eAuth internal ID number in Oracle Directory Services(ODS). The user will goto our URL, sign in to eAuth, and Cognos will check to see if they are in the ODS. If they in the directory they are let in. If they are not in the directory Cognos will prompt them for a UserID and Password.

The problem we are having is that eAuth is blocking the application from rendering the reports in iFrame. Here is the description of the error:

"The system has encountered an error.

The URL you were trying to access contains embedded HTML tags. The eAuthentication system does not allow authentication from URL's that contain characters known to be used in cross site scripting attacks. These characters were most likely generated by the application you were trying to access. Please open a new browser window and log into the application you were trying to access again."

Any suggestions/comments/recommendations would be greatly appreciated.

Thank you.
Updated on 2013-02-13T18:37:59Z at 2013-02-13T18:37:59Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1959 Posts
    ACCEPTED ANSWER

    Re: Problem rendering Cognos 10 reports in iFrame

    ‏2013-02-13T11:02:23Z  in response to SystemAdmin
    Can you give a sample of the URL contained within the Iframe ?

    We use Iframes for Cognos and show the charts in WebSphere Portal.
    • SystemAdmin
      SystemAdmin
      1959 Posts
      ACCEPTED ANSWER

      Re: Problem rendering Cognos 10 reports in iFrame

      ‏2013-02-13T12:38:47Z  in response to SystemAdmin
      Here's the URL contained within iframe:

      reports.htm?action=runReport&runReportName=/content/folder/folder/folder/folder/folder/folder/report

      Search path: /content/folder/folder/folder/folder/folder/folder/report
      • SystemAdmin
        SystemAdmin
        1959 Posts
        ACCEPTED ANSWER

        Re: Problem rendering Cognos 10 reports in iFrame

        ‏2013-02-13T12:42:45Z  in response to SystemAdmin
        Here's the complete URL
        • DanielWagemann
          DanielWagemann
          850 Posts
          ACCEPTED ANSWER

          Re: Problem rendering Cognos 10 reports in iFrame

          ‏2013-02-13T13:40:02Z  in response to SystemAdmin
          It would be nice to understand how you are actually calling the iframe itself with the completed code. Here is simple example of how I call Iframes from an html object within an IBM Cognos Report Studio report.

          
          <html> <head> </head> <body> <iframe width=100% height=100% src=
          " http:
          //servername:port/p2pd/servlet/dispatch?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2fpackage%5b%40name%3d%27Cube%27%5d%2freport%5b%40name%3d%27Report%201%27%5d&ui.name=Report%201&run.outputFormat=&run.prompt=true&cv.header=false&cv.toolbar=false" id="theiframe1" name="theiframe1"></iframe></body> </html>
          
          • SystemAdmin
            SystemAdmin
            1959 Posts
            ACCEPTED ANSWER

            Re: Problem rendering Cognos 10 reports in iFrame

            ‏2013-02-13T14:10:10Z  in response to DanielWagemann
            We have a servlet that calls a jsp to open iframe and render the report. See attached.
            • DanielWagemann
              DanielWagemann
              850 Posts
              ACCEPTED ANSWER

              Re: Problem rendering Cognos 10 reports in iFrame

              ‏2013-02-13T14:22:42Z  in response to SystemAdmin
              Much clearer now thanks!.... So I wonder if its the iframe or the variable which replaces the report name. What happens when you hard code a report name, like in my example, instead of passing in the variable ReportName? (As a test of course.)
              • SystemAdmin
                SystemAdmin
                1959 Posts
                ACCEPTED ANSWER

                Re: Problem rendering Cognos 10 reports in iFrame

                ‏2013-02-13T15:10:04Z  in response to DanielWagemann
                It worked when I hard coded the report name.
                • DanielWagemann
                  DanielWagemann
                  850 Posts
                  ACCEPTED ANSWER

                  Re: Problem rendering Cognos 10 reports in iFrame

                  ‏2013-02-13T15:32:29Z  in response to SystemAdmin
                  OK so its not the iframe itself ... if I had to guess I would say its the less than, or percent characters in your variable assignment.
                  
                  <%=reportName %
                  


                  Unfortunately, I am not sure what you would have to do to these characters to the exceptions list and what impact it would have to your security.(Cross site scripting, injection etc.)
                  • SystemAdmin
                    SystemAdmin
                    1959 Posts
                    ACCEPTED ANSWER

                    Re: Problem rendering Cognos 10 reports in iFrame

                    ‏2013-02-13T18:37:59Z  in response to DanielWagemann
                    Thanks, Daniel. It appears that those characters are being blocked by SiteMinder. I will have to do some research on how to deal with them, or come up with another solutiion on how to render the reports.
                    • shaurya123
                      shaurya123
                      3 Posts
                      ACCEPTED ANSWER

                      Handling Drill through reports from Iframe

                      ‏2014-05-29T15:31:21Z  in response to SystemAdmin

                      Hello All,

                      We have implemented Iframes  for one of the requirements in our project.

                      Iframes is working fine, we have drill through reports from Iframes, a new pop up window appears for drill through reports.

                      The requirement now is we need to hide the address bar from this pop u window.

                      Anyone who has implemented this or any guidelines on how this can be achieved?

                       

                      Thanks,

                       

                      Updated on 2014-05-29T15:31:41Z at 2014-05-29T15:31:41Z by shaurya123