cancel
Showing results for 
Search instead for 
Did you mean: 

Hyperlink issue in webi

Former Member
0 Kudos

Hi Friends.

I have some doubt regarding adding hyper link in Webi for open-doc report.

My requirement is I need to add hyperlink for each cell.

Above screenshot is example .

1.If i click yahoo, it redirects to yahoo page.

2.If i click google, it redirects to google page.

Is it possible??? If so kindly help me plz

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Maya Sharma,

Try this

Location

Date

East

1/5/10

East

1/6/10

North

1/10/10

North

1/11/10

South

1/2/10

South

1/3/10

South

1/4/10

West

1/7/10

West

1/8/10

West

1/9/10

Create a variable [Hyperlink]="If([Location]="East") Then "<a href=\"www.google.com\">Eastt</a>" ElseIf([Location]="West") Then "<a href=\"www.yahoo.com\">West</a>"ElseIf([Location]="North") Then "<a href=\"www.flipkart.com\">North</a>"ElseIf([Location]="South") Then "<a href=\"www.myntra.com\">South</a>" Else [Location]"
Add  hyperlink column to table.

Date

Location

hyperlink

Month

Week

1/2/10

South

<a href="www.myntra.com">South</a>

Jan

1

1/3/10

South

<a href="www.myntra.com">South</a>

Jan

1

1/4/10

South

<a href="www.myntra.com">South</a>

Jan

1

1/5/10

East

<a href="www.google.com">Eastt</a>

Jan

1

1/6/10

East

<a href="www.google.com">Eastt</a>

Jan

1

1/7/10

West

<a href="www.yahoo.com">West</a>

Jan

1

1/8/10

West

<a href="www.yahoo.com">West</a>

Jan

2

1/9/10

West

<a href="www.yahoo.com">West</a>

Jan

2

1/10/10

North

<a href="www.flipkart.com">North</a>

Jan

2

1/11/10

North

<a href="www.flipkart.com">North</a>

Jan

2

Right click on hyperlink column. select "format cell"-------> under "Display"----------------> Read contents as text: Change it to hyper link. then we can get like this

Date

Location

hyperlink

Month

Week

1/2/10

South

Jan

1

1/3/10

South

Jan

1

1/4/10

South

Jan

1

1/5/10

East

Jan

1

1/6/10

East

Jan

1

1/7/10

West

Jan

1

1/8/10

West

Jan

2

1/9/10

West

Jan

2

1/10/10

North

Jan

2

1/11/10

North

Jan

2

trun this table to cross tab

hope this will work. Let me know if any queries

Regards

Dinesh

Former Member
0 Kudos

edit the variable with this query.

1/2/10

1/3/10

1/4/10

1/5/10

1/6/10

1/7/10

1/8/10

1/9/10

1/10/10

1/11/10

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

East

North

South

West

then we will get

1/2/10

1/3/10

1/4/10

1/5/10

1/6/10

1/7/10

1/8/10

1/9/10

1/10/10

1/11/10

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

12/31/99

<a href="www.flipkart.com">North</a>

<a href="www.google.com">Eastt</a>

<a href="www.myntra.com">South</a>

<a href="www.yahoo.com">West</a>

Former Member
0 Kudos

then right click on this select format cell choose hyperlink in read as cell

Former Member
0 Kudos

dinesh,

Really so thankful for your screen shot.

If you dont mind can you send the screen shot which is related to my original screen shot plz

Former Member
0 Kudos

Share your screen shot with vertical table format .

Former Member
0 Kudos
Former Member
0 Kudos

"If([Material price]="A1") Then "<a href=\"www.google.com\">A1</a>" ElseIf([Material price]="A2") Then "<a href=\"www.yahoo.com\">A2</a>"ElseIf([Material Price]="As") Then "<a href=\"www.flipkart.com\">As</a>"ElseIf([Material price]="aw ") Then "<a href=\"www.myntra.com\">Aw</a>" Else [Material Price]"



Likethis update ur fields ;

   Hope this will work.

Former Member
0 Kudos

Thanks for the quick response..ll let u know soon

Former Member
0 Kudos

dinesh,

Its nt working. it shows error

Former Member
0 Kudos

share the screen shot clearly and the requirement  you need .

Former Member
0 Kudos

Dinesh,

Its working,

Thanks a lot

Former Member
0 Kudos

I sending one example to you .Refer this

Country

Year

Revenue

France

FY2004

76,270

France

85,560

France

81,085

France

53,025

US

180,590

US

186,930

US

207,908

US

192,186

FY2004

Country

Year

Revenue

France

FY2005

70,400

France

80,050

France

74,960

France

54,900

US

204,630

US

202,836

US

216,090

US

203,374

FY2005

Country

Year

Revenue

France

FY2006

61,895

France

76,555

France

70,080

France

50,640

US

196,831

US

189,886

US

234,574

US

235,269

FY2006

here iam applying the hyperlink for each country
=If ([Country] = "France") Then "<a href=\"www.google.com\">France</a>" elseIf ([Country] = "US") Then "<a href=\"www.yahoo.com\">US</a>" Else [Country] .
hope you understood how to apply
Regards
Dinesh

Answers (2)

Answers (2)

sateesh_kumar1
Active Contributor
0 Kudos

Hi Maya,

on each row measure cell, right click ->Linking->Add Hyperlink ->Paste your web page address.

Former Member
0 Kudos

No. Hyperlink should be an object within CMS and not external sites

Former Member
0 Kudos

Avinash,

Screenshot is for example..

So i m for internal sites only.

Former Member
0 Kudos

Ok..

you can do it then..

right click > Add hyper link ...select the target report from infoview

Make sure you have prompts in the target report (optional prompts)

Former Member
0 Kudos

its easier to do it from infoview