Solved

Oracle issue Hyperlink

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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 take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

912 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

21 Experts available now in Live!

Get 1:1 Help Now