Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to pass a presentation variable via GoURL/prompted URL?

Received Response
649
Views
23
Comments
2

Answers

  • airwolf_86
    airwolf_86 Rank 3 - Community Apprentice

    I did try passing a value for &val3 but it hard codes it. I will once again as per Boris's blog you shared.

    For example, the dashboard prompt on dashboard page 1 for district has a default value of "Sydney".

    I tried adding this fr &val3. Of course, then the value gets passed to the 2nd dashboard prompt via the GoURL.

    But when i change the value on dashboard page 1 to another district (eg: Melbourne) and use the link to navigate to dashboard page 2, it still uses the value "Sydney" initially set in the URL and doesn't pick the new changed value in the prompt.

  • airwolf_86
    airwolf_86 Rank 3 - Community Apprentice

    Hi Christian,

    I tried various approaches but I wasn't able to pass the value of the Presentation variable. Boris's article doesn't specifically highlight a scenario with a presentation variable.

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

    If you use the interface option for the Navigate action, then you can choose a column as well. Just fill the variable into a column and use that column.

  • airwolf_86
    airwolf_86 Rank 3 - Community Apprentice

    Hi Christian,

    this is the interface option.

    pastedImage_1.png

    /saw.dll?Dashboard&PortalPath=@{1}&Page=@{2}&Action=@{3}&var1=@{4}&psa1=@{5}&col1=@{6}&val1=@{7}

    I saw this blog, http://www.iwarelogic.com/2010/09/integrating-oracle-obiee-content-using-go-url-850/

    but still a bit confused as to how to pass the variable

  • airwolf_86
    airwolf_86 Rank 3 - Community Apprentice

    Hi Christian,

    I was able to get the Presentation variable to work in the URL, but only on a table analysis. The same column used in a performance tile does not pass the value of the presentation variable to it.

    /saw.dll?Dashboard&PortalPath=@{1}&Page=@{2}&Action=@{3}&col1=@{4}&val1=@{5}&psa1=@{6}&var2=@{7}&cov2=@{8}&val2=@{9}&psa2=@{10}

    pastedImage_0.png

    pastedImage_1.png

    Clicking on the  3rd column we see that the values get passed to val1 and val2.

    pastedImage_2.png

    But if i click on the performance tile, val1 and val2 don't get populated.

    pastedImage_3.png

    Ever come across such behaviour?

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

    Aaaaah a performance tile! Yeah you'll have an issue there. Better add a second view which hosts the link.

  • airwolf_86
    airwolf_86 Rank 3 - Community Apprentice

    Can you kindly elaborate what you meant by that?

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

    Rather than just having a performance tile put a second view into the analysis which will be the host of the action

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Like creating a pure action link on the same dashboard, or embedding it in a text area...

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

    Precisely. Performance Tiles are....weird.