Oracle Business Intelligence

Products Banner

Parameters not being passed to a web action link

Received Response
33
Views
9
Comments

Hello,

We have a column on an analysis that includes a hyperlink to another web site.

The URL looks like this

https://server.name/drilldown.action?value1=@{1}&value2=@{2}

The parameters are defined as:

Name: 1

Prompt: value1

Value: c

Fixed; checked

Hidden: checked

Name: 2

Prompt: value2

Column Value: "table name"."column name"

Fixed: checked

Hidden: checked

When we run this and click on the link, the URL in the new window says: https://server.name/drilldown.action?value1=c&value2=

If we uncheck the boxes for fixed and hidden on value2, we see "table name"."column name" on the confirmation screen.  When we execute, we see the complete URL.

Any ideas what might be wrong?

Thanks!!

Answers

  • Dennis Hancy
    Dennis Hancy ✭✭✭✭

    Thanks, but that link is for a 2 hour course on building analyses and dashboards.  I have some background in that already, but this is the first time I have encountered this particular problem.

    If I mark the parameters (in this case they are column values) as fixed and hidden, then they do not get passed to the second level page. That is, they show up as blank.

    If I mark them as visible and not fixed, they show up on the Execute window, and are then properly passed to the next screen as prompt values.

    Is there any documentation that would explain why this is happening?  Thanks again.


    Dennis

  • Dennis Hancy
    Dennis Hancy ✭✭✭✭

    Hello,

    After a month, I am finally getting back to this.  Thought I'd add more information to see if that helps clarify the issue I am having.

    On the criteria tab, I navigate to the hierarchy column.

    I select Column Properties and click the Interaction Tab.

    Primary Action is: Drill + Action Link

    The URL is: https://URL.com/analytics/saw.dll?Dashboard&PortalPath=@{1}&page=page2&options=r&Action=Navigate&P0=1&p1=eq&p2=@{2}&p3=@{3}

    The three parameters are defined as follows:

    1: /shared/Sandbox/myDashboard

    2: "MyTable"."MyColumn" (this is the literal string representing the actual table/column names)

    3: "MyTable"."MyColumn" (this is the column value)

    If "Fixed" and "Hidden" are checked for all three parameters, then this is the URL after I click on the link:

    https://URL.com/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FSandbox%2FmyDashboard&page=page2&options=r&Action=Navigate&P0=1&p1=eq&p2=%22MyTable%22.%22MyColumn%22&p3=

    Note that &p3 does not show the value of column that was selected on the first page (the page with the action link.)

    If I uncheck "Fixed" and "Hidden" from the third parameter, then this is the URL after I click on the link:

    https://URL.com/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FSandbox%2FmyDashboard&page=page2&options=r&Action=Navigate&P0=1&p1=eq&p2=%22MyTable%22.%22MyColumn%22&p3=myFileName

    Note that &p3 now shows the value of the column that was selected on the first page.

    Does anyone know why this particular parameter has to be visible in order for this to work (yet the other two work fine, whether it's hidden or visible)?

    Thanks!

    Dennis

  • Hi,

    After upgrading to 12.2.1.2, we are facing the same issue and we have dozens of reports based on this functionality. Any efficient solution would be highly appreciated.

    Regards,

    Rizwan

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    Hi Dennis,

    I have not experienced this but just wanted to share a couple of thoughts - I suspect if it has been a month you might have already thought of these, but you never know.

    1. Do the parameters have to be parameters? - if the URL is in the body of an analysis as a column - which I think is what you are describing - then could you generate the entire URL 'parameters' and all using a formula?

    2. Have you logged an SR, if this worked before upgrade but does not now then either it is a bug or it is a new security feature, but if you raise an SR and others who are suffering with this ( @Rizwan M ) do likewise then you may gain traction to get it resolved.

    Sorry I don't have more!

  • Thanks Rizwan and Robert.

    It's good to know that we're not the only ones experiencing this issue.  I was starting to think we were just missing something obvious.

    I'm intrigued by the idea of using a formula to generate the URL.  How would that work?  Would I create a new column whose formula results in the entire URL?  And would I then reference that column in the URL of "Navigate to a Web Page"?

    I spoke with a co-worker last week about opening an SR for this.  I apparently don't have access to do this myself, but I will follow up with him when he gets in.  This is the first time I have used this functionality, so I can't speak to whether this worked before 12.2.  But from Rizwan's comments, it sounds like it is a bug.

    Thanks again to you both for your comments on this!

    Dennis

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    Hi Dennis,

    yes 'https://etc/etc ...' || your_variable1_here||'etc etc' - then make it html in the format - is what I had in mind.

    I did this first some years ago to provide drill out functionality from invoice data to scanned images - provided you have a predictable format and can access the parameters you are away...

  • A co-worker did some research on Oracle Support earlier.  He found an article, Oracle Support Note 2272915.1.  It describes the issue we are having.  The article refers to a patch that can be applied: 25353706.

    It says that this fix is included in version 12.2.1.3.0.  Like Rizwan, we are on version 12.2.1.2.0.

    We have not yet applied to patch to see if this corrects the problem, but I wanted to pass this along in case it helps.

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    Thanks - the value of the community is increased by everyone who wants to add as well as take value!