Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Session Variables with URLs

Received Response
84
Views
6
Comments
Dennis Hancy
Dennis Hancy Rank 5 - Community Champion


Hello,

We have a session variable that stores a URL.

How can we reference that variable when creating an action link on a field in an analysis?

The dialog box asks for the name of the URL. But instead of hardcoding it, we want to use the value that is stored in the session variable.

We tried a few things, such entering VALUEOF(NQ_SESSION.ourURLvariable), but so far, nothing has worked.

Is there something else you can suggest? Thanks!


Dennis

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Hello,


    Which version of obiee . in 12c you have option to select the sesson variable in action link



  • Dennis Hancy
    Dennis Hancy Rank 5 - Community Champion

    Hi.

    We have 12.2.1.4.0.

    We tried entering this as a parameter, but we received the following error message. The value of HELP_URL is something like https://www.google.com/


    We also tried entering this: VALUEOF(NQ_SESSION.HELP_URL), but then it attempts to open this: http://valueof(nq_session.help_url)/


    Thanks.

    Dennis

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    But your action link is missing.



  • Dennis Hancy
    Dennis Hancy Rank 5 - Community Champion

    Yes. We were hoping to have the entire URL as a parameter. Is that possible?

  • You could use an action calling a browser script which will open a new page with your URL.

    Or you must host a page somewhere (could even be the same OBIEE/OAS weblogic) receiving the URL as parameter and doing a simple redirect.

  • Dennis Hancy
    Dennis Hancy Rank 5 - Community Champion

    Thanks everyone for your suggestions on this.


    Because we were in a bit of a time crunch on this, we took the path of least resistance - at least for now.


    We ended up defining an alias in ActionFrameworkConfig.xml - one in Dev, one in Test, and one in Prod. The URL field in Action Links allow us to reference that value, even though we're not using it a parameter.


    At some point, when the proverbial dust settles, we'll look into using a browser script or implementing a simple redirect.


    Thanks again. Much appreciated!


    Dennis