Solved

Oracle issue Hyperlink

Posted on 2014-12-09
1
383 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 500 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now