12 Replies Latest reply: May 23, 2013 10:30 AM by user8030589 RSS

    Navigation to URL Action

    783226
      My report displays table with results.
      When user click on the table cell I want to open popup with action to navigate to some URL with that cell's value.

      I saw the option to add action URL:

      a. How can I set it to be opened in new window and not instead of the current dashboard?

      b. The URL is something like http://somedomain.com/tt/rr/xx, where xx is the value I got from the cell's value.
      How can I transfer the xx from the cell to the opened URL?
        • 1. Re: Navigation to URL Action
          user248025
          Hi,

          Navication url Action -->go to edit action --> option --->invoke action as "Open in new window"


          refer my screen http://imageshare.web.id/images/nyap5y9ae9knss1dxvrq.jpg

          Thanks

          Deva
          • 2. Re: Navigation to URL Action
            783226
            Thanks Deva,

            Any information about the usage of URL and parameters?
            How to transfer the selected value?
            • 3. Re: Navigation to URL Action
              user248025
              Hi,

              Here we define Parameter like (user define values,passing session variable,column values,RPD varaible) then it will pass into another page.

              let say ex:


              http://PC:9704/WebApplication1_V01/BU_firstpage.jsp?$Country=@{1}$BU=@{2}$Business_Date=@{3}$groupname=@{4}$Subgroup=@{5}$Userid=@{6}

              we can use it external application like -->user comments with external J2ee - jsp application


              http://www.rittmanmead.com/2010/07/obiee-11gr1-action-framework-and-conditions/

              http://siebel-essentials.blogspot.com/2010/09/11-obiee-11g-tips-7-action-links.html

              Thanks

              deva
              • 4. Re: Navigation to URL Action
                783226
                Thanks for tips, but in my case the URL is without the question mark and the regular parameters delivery.
                The URL I use is http://somedomain.com/xx where xx is the value in the selected cell.

                Can you please show me what should be the syntax for transferring this value?
                Should I use http://somedomain.com/@{xx}
                and define parameter as follows:
                name -> xx
                prompt -> ????
                value -> mttable.myfield
                • 5. Re: Navigation to URL Action
                  user248025
                  Hi,

                  Keep it like this,

                  Web page link give it this
                  http://somedomain.com?&column name=@{value}

                  Or
                  http://somedomain.com/&column name=@{value}


                  Thanks

                  Deva
                  • 6. Re: Navigation to URL Action
                    783226
                    Thanks Devarasu for answer, but can you please elaborate regarding the defined parameter.

                    Assuming the URL is http://somedomain.com/&column name=@{value}

                    what should I enter in
                    name
                    prompt
                    value -> mttable.myfield
                    • 7. Re: Navigation to URL Action
                      user248025
                      Hi,

                      Let say url template like below one

                      http://accounts.google.com/ServiceLogin?&userid=@{name1}&Password=@{name2}

                      actual link:
                      http://accounts.google.com/ServiceLogin?

                      now u r going to pass two dashboard prompt filer --> column values into var1 & va2
                      Action link url path like below

                      i.e
                      name1=userid
                      name2=Password

                      note: this var1,var2 are the alias name of the column values

                      "&" ---> is the column splitter ( splitting each column use also use $,&)

                      @{name} ----> where 'name' is the value specified in the name column below

                      no limits to defining paramter in the url link

                      for more refer below link:

                      http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21bi-311005.html

                      Thanks

                      Deva
                      • 8. Re: Navigation to URL Action
                        783226
                        Sorry but in my case I have problematic URL:

                        http://www.ip-adress.com/whois/64.23.18.254
                        or
                        http://whois.arin.net/rest/nets;q=64.23.18.254?showDetails=true&showARIN=false&ext=netref2


                        I tried:
                        http://www.ip-adress.com/whois/@{selectedIP}
                        or
                        http://whois.arin.net/rest/nets;q=@{selectedIP}?showDetails=true&showARIN=false&ext=netref2
                        where name='selectedIP' and prompt='q'
                        but it failed, since there is no'?' before the parameters.

                        The same issue I have when my column field is domain and I want to give the option to navigate to it:
                        http://@{domain}
                        • 9. Re: Navigation to URL Action
                          user248025
                          Hi,
                          Are u trying to access lap host name? can you please elobrate more about your reuirement and current output screen short & expected output screen (place it via image share weblink)



                          Thanks

                          Deva
                          • 10. Re: Navigation to URL Action
                            783226
                            I added screenshot: http://www.image-share.com/ijpg-1070-263.html

                            I'll try to elaborate:

                            I have a table report with IP field and Dmain fields.

                            I want to give the user action links on both columns:
                            When clicking on IP value, I want popup menu with the option to navigate towrds the site http://www.ip-adress.com/whois/xx where xx is the selected IP value.
                            For example http://www.ip-adress.com/whois/64.23.18.254, when table cell contains the value '64.23.18.254'.
                            When clicking on Doman I want popup menu with the option to navigate towrds the site http://xx where xx is the selected Domain value.
                            For example http://www.bbc.com, when table cell contains the value 'www.bbc.com'.
                            • 11. Re: Navigation to URL Action
                              783226
                              Can someone please advise?
                              • 12. Re: Navigation to URL Action
                                user8030589
                                Hi Nir,

                                Coincidentally, I am going through the same issue right now and have a post from yesterday with the subject 'Action Links - Browser Script'. OBIEE doesn't seem to let parameters be passed without the ? before it. So if you have a URL without a query string (the question mark), you won't be able to launch your URL. I got around this by creating an ASP Page (http://xxxntsapp04/redirect.asp) and updating the URL that gets launched from OBIEE to be http://xxxntsapp04/redirect.asp?http://www.google.ca where http://www.google.ca is the url in the cell that I am clicking on. The asp page then strips off everything prior to the ? and launches http://www.google.ca. This works great but I don't want to rely on an ASP page somewhere on one of our servers so I was playing with invoking a browser script from OBIEE. I am very close but my url's now get launched with a comma at the beginning of them.

                                If someone provides assistance on my post, I will let you know.

                                Thx,
                                Mike