Open document to open multiple reports

[Pepa]

Hi

i have created 3 Webi Reports, namely
Report 1
Report 2
Report 3

Report 1 has company and its revenue
Report 2 has Site and its Revenue
Report 3 has Service and its revenue

Example :

 
Report 1
 
Company    Revenue
abc            456
adf           789 
dsd            145
 
Report 2 
Site                 Revenue
s1                  7255
s2                  8985
s3                  4444
 
Report 3
 
Services        Revenue
sr1               10
sr2               15
sr3               45

which falls under the hierarchy
1.company -> Site
2.company -> Service

In Report 1 , i should have a open document link on Company object, if i click any of the company, it should ask for options to navigate either to Report 2 or Report 3 ie by SITE or SERVICE.
Is this possible by open document functionality in Web intelligence. If so please guide step by step.
I have tried directly creating a object with hyperlink from universe

Case	@Prompt('Select Measure: ','A',{'Site', 'Service'},MONO,CONSTRAINED) 
	
	When 'Site' then ="<a href='#' on.click=\"javascript:window.open('http://ptpl-vm3:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=Afkjn4VJ.qpHqciiP5iOlwE&sIDType=CUID&sType=wid&sRefresh=N&lsSEnterYear%3A="+[Year]+"')\">"+[Year]+"</a>"
 
	When 'Service' then ="<a href='#' on.click=\"javascript:window.open('http://ptpl-vm3:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AdLLgIJn7XJCv85q2wVZlOo&sIDType=CUID&lsSEnterYear%3A="+[Year]+"&lsSEnterQuarter%3A="+[Quarter]+"')\">"+[Year]+"</a>"
 
End

its throwing an error on parse failed.
and also tried in infoview, creating hyperlink

="<a href='#' on.click=\"javascript:Case	@Prompt('Select Measure: ','A',{'Site', 'Service'},MONO,CONSTRAINED) 
	
	When 'Site' then 
		window.open('http://ptpl-vm3:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=Afkjn4VJ.qpHqciiP5iOlwE&sIDType=CUID&sType=wid&sRefresh=N&lsSEnterYear%3A="+[Year]+"')
 
	When 'Service' then 
		window.open('http://ptpl-vm3:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AdLLgIJn7XJCv85q2wVZlOo&sIDType=CUID&lsSEnterYear%3A="+[Year]+"&lsSEnterQuarter%3A="+[Quarter]+"')\">"+[Year]+"
 
End
 
</a>"

which is also not working.

Is there an way to create this?

Thanks&Regards,
Pepa

[rickythomas]

You should follow the easiest path for the following, it is quite important to know the basics of the applications, i am not aware of that particular program.