Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle issue Hyperlink

Posted on 2014-12-09
1
Medium Priority
?
436 Views
Last Modified: 2015-01-01
Hello
Within Oracle Business Intelligence Enterprise Edition 11g, I created an analysis and added a column. Then I did this for that column:
Column properties > interaction > edit action links and added a link in this way (sample link)
https://prodgtpm.Hero.net/econ_enu/start.swe?SWECmd=GotoView&SWEView=SRR+Single+Rcrd+CSS+CG+addr+rawNum+View&SWERY=1&SWEHo=prod-gtpm.Hero.net&SWEBU=1&SWEApplet0=SRR+Single+Record+CG+addr+List+Applet+NonCorp&SWERowId0=1-6HJKG
when I am trying to click on the the link from the report itself, it giving this error:
Could not find 'View' named ' SRR+Single+Rcrd+CSS+CG+addr+rawNum+View.

I believe it’s the ‘+’ in the above hyperlink that’s causing the issue. How to do replace OR surround the ‘+’ within the herperlink before feeding it to the action link?
0
Comment
Question by:Rayne
1 Comment
 
LVL 5

Accepted Solution

by:
Sanjeev Labh earned 2000 total points
ID: 40492622
Hi,

First you have to verify what is the correct url by checking in the browser. If you are sure the + sign is the main problem creator and you have to replace it with the appropriate one then using sql you can very easily do that with the REPLACE function. I have placed below an example of that.

I am assuming you will be replacing + with -
You can replace - with any other string which you thing is right for your url.

This example is executed in sql plus

define url='https://prodgtpm.Hero.net/econ_enu/start.swe?SWECmd=GotoView&SWEView=SRR+Single+Rcrd+CSS+CG+addr+rawNum+View&SWERY=1&SWEHo=prod-gtpm.Hero.net&SWEBU=1&SWEApplet0=SRR+Single+Record+CG+addr+List+Applet+NonCorp&SWERowId0=1-6HJKG'

PDB1@ORCL> select replace('&url','+','-') new_url from dual;
old   1: select replace('&url','+','-') new_url from dual
new   1: select replace('https://prodgtpm.Hero.net/econ_enu/start.swe?SWECmd=GotoView=SRR+Single+Rcrd+CSS+CG+addr+rawNum+View=1=prod-gtpm.Hero.net=1=SRR+Single+Record+CG+addr+List+Applet+NonCorp=1-6HJKG','+','-') new_url from dual

NEW_URL
----------------------------------------------------------------------------------------------------
https://prodgtpm.Hero.net/econ_enu/start.swe?SWECmd=GotoView=SRR-Single-Rcrd-CSS-CG-addr-rawNum-View
=1=prod-gtpm.Hero.net=1=SRR-Single-Record-CG-addr-List-Applet-NonCorp=1-6HJKG
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Viewers will learn how the fundamental information of how to create a table.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question