Solved

Oracle issue Hyperlink

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

832 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