Oracle Analytics Cloud and Server

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

How to pass Presentation Variable to URL ?

Received Response
112
Views
18
Comments
Muhammad Kamal
Muhammad Kamal Rank 3 - Community Apprentice

Hi All,

We have Oracle Business Intelligence EE 12c v12.2.1.2.0

what we need to do is pass a parameter to URL using Action Link - Navigate to a Web Page from one of our Dashboards, the options available for this parameter are:

  • Value
  • Session Variable
  • Repository Variable
  • Column Value

but what we need to pass is Presentation Variable "not available in previous menu", because we have some Dashboard Prompts in this Dashboard, we are using them to set some Presentation Variables, and the only options available for Prompts to set are:

  • Presentation Variable
  • Request Variable

we tried to select "Value" option, then fill the box with the following: "where P_VAL is the Presentation Variable comes from the Prompt"

but with no success

any idea how can we mange to do this ??

thanks in advance

«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Why not simply capture the presentation value inside a column formula and then reference that column in the navigate action's parameters?

  • Muhammad Kamal
    Muhammad Kamal Rank 3 - Community Apprentice

    @Christian Berg

    thanks for the reply, solved my first question,

    now my second one:

    How to hide the Dialog Windows with Execute button??

    we need the URL comes direct after clicking the link, no need for this Dialog Windows to show us first which values we are passing, is that possible ??

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Sure just tick the "Hidden" checkbox

    pastedImage_0.png

    Edit: And the action link itself like this of course:

    pastedImage_0.png

  • Muhammad Kamal
    Muhammad Kamal Rank 3 - Community Apprentice

    @Christian Berg

    Thanks, when we ticked the "Hidden" checkbox, the "Fixed" checkbox ticked automatically, also all parameters passed as NULL, and the URL didn't return correct results, any idea ??

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You've got to look at this more in detail. What is the URL passing? What isn't it passing? Are the parameter missing? Are they passed wrong? Are they not applied?

  • Muhammad Kamal
    Muhammad Kamal Rank 3 - Community Apprentice

    @Christian Berg thanks for the reply

    here is what we actually do, we have this intranet URL:

    http://something.com/?Road_NO=@{R}&AreaCode=@{A}&Date_from=@{DF}&Date_to=@{DT}

    we used this URL in the Navigate to a Web Page - Action, we defined all 4 parameters as mentioned before as Columns, if we leave the Hidden Option unticked, then every thing works fine, the parameters passed like a charm,

    but when we tick the Hidden Option, then yes the Dialog Window doesn't show up, but all parameters passed as null values, and the web page tries to call the URL as following:

    http://something.com/?Road_NO=&AreaCode=&Date_from=&Date_to=

    any idea ??

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Is "Fixed" true or false?

  • Muhammad Kamal
    Muhammad Kamal Rank 3 - Community Apprentice

    @Christian Berg

    Once we tick the Hidden Option, the Fixed Option turn itself ticked automatically, and if we untick it again, then the Hidden Option untick itself back too !!

    2017-08-16_8-41-26.png

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    It could be an issue with your internal security. There is no reason i could find values are not passing while it is hidden. Try from a different environment and see.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Just tested and with column values this effectively gets dropped in 12.2.1.2.0. Damn.

    So alternative approach. Change from presentation variables to request variables. Yes you'll need to create 4 fake placeholder session variables but you can defer their execution.