6 Replies Latest reply on Aug 14, 2018 2:16 PM by Christian Berg

    How to bypass SSO for a public user/password to display BI analysis - 12c

    Joel Saunders

      In 11c, we could bypass SSO by appending &NQUser and &NQPassword to the analytics URL when the dashboard was specified.  Here's an example below:

       

           http://hostname:port/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FDashboardname&Page=Dashpage&NQUser=XXXXX&NQPassword=YYYYY&syndicate=Siebel

       

      This allowed us to put a public analysis on a public website effectively bypassing SSO.        Note the above URL was called by another URL to hide the user and password that we were using!

       

      We are now upgrading to 12c and this is no longer supported (when we attempt it, it sends us back to the OBI signon screen.)

       

      Has anyone else encountered and solved this?

       

      MOS suggested using BI WebServices, but I'm not sure that that will allow for the display of the Chart and pivot table to the user.  

      Webservices are normally a machine to machine implementation strategy.

       

      All we want to have is the same ability as we had in 11g. 

       

      Any and all comments are welcome...  We need to have this working in a few weeks.

       

      Thanks...

       

      Joel