BusinessObjects Board

Report Linking in BO XI.

Hi,

I’m trying to link report in BO XI (webi to webi). It seems that the syntax is not the same with BO 6.5. Below is the syntax that I tried to do but it still doesn’t work.

="http://accel-demo:8080/businessobjects/enterprise11/desktoplaunch/opendoc/openDocument.jsp?sRepoType=corporate&sRepo=DocDomain&sPath=Web+Intelligence+Samples&sType=wid&Web+Intelligence+Sample"

My question is

  1. Do we still need sRepoType and what is the default name?
  2. Do we need the sRepo since BO XI doesn’t have any document domain?
  3. We do need to identify the sPath right? How?

Can any provide the successful linked report syntax?

Thanks,
Kat.

Can anyone give me an example of the link


sanitkat (BOB member since 2004-09-28)

These parameters are not applicable for XI.

This parameter is not mandatory, you can use doc name instead.


Anil Kumar :india: (BOB member since 2005-04-19)

sRepo & sRepoType are deprecated in XI and no longer used.
Inbox & Personal have been remapped to specific folder accessed through their InfoObjectID

In XI we have 2 ways to reference a document

  • With the XI object identifiers (id, cuid, or guid)
  • With the document/folder name as in 6.5

Code sample:
<based on folder & document name>

openDocument.jsp?sPath=[reports]&amp;sDocName=Charting&amp; sType=rpt
openDocument.jsp?sPath=[reports],[finance]&amp;sDocName=Summary&amp; sType=rpt

<based on SI_ID property of InfoObject - will only work in 1 environment, not recommended>

openDocument.jsp?iDocID=23115

<based on CUID of report - strongly recommended to follow best practices for Change Management as CUIDs are retained between dev, qa, and production environments and during updates>

openDocument.jsp?iDocID=Abk9XIKnJexPl1ONUYlAcDc&amp;sIDType=CUID

snagoski :canada: (BOB member since 2004-12-13)

Here is the working syntax.

="<a href=" + "/businessobjects/enterprise11/desktoplaunch/opendoc/openDocument.jsp?sDocType=wqy&amp;sRepoType=0&amp;sDocName=ReportName1"  + ">" + [object1] + "</a>"

if you have any space between document name or prompt name use %20 character.

Still working without DocumentID. In previous version you need documentid for webi documents.


RadN :us: (BOB member since 2003-04-28)

Web Intelligence report could be viewed using a link, with the following syntax:

http:///businessobjects/enterprise11/InfoView/scripts/openDocument.jsp?

Where is the web server and is the list of the following parameters joined with ‘&’:
• (required) Either:
• sPath and sDocName, where
• sPath= – the path of the report
• sDocName= – the name of the report
• iDocID= – the object ID of the report
• sType=wid – document type, it’s wid for Web Intelligence document.
• sRefresh=<yes/no> – refresh the report or not, either Y or N.
• sReportName= – the name of report in the document.
• lsS= - the name and value of a single value prompt.
• lsM=<value_1>;<value_2>;…;<value_n> - the name and values of a multi values prompt.
• lsC= - the value of a context.
• sWindow= – the target window to display, either Same, New, or the name of a window.

Here is an example:

="<a href=http://server:port/businessobjects/enterprise11/desktoplaunch/opendoc/openDocument.jsp?sDocName=object&amp;sType=wid&amp;sRefresh=Y&amp;sReportName=Report1&amp;sWindow=New>link to the report</a>"

I have worked extensively on report to report linking. If you have any more queries do let me know.

Njoy!

Sharat


sharatthakur (BOB member since 2005-04-28)

Hi ! I have a similar problem. I am using efashion database and created a hyperlink as below

'<a href=http://jyothia:8080/businessobjects/enterprise11/InfoView/scripts/openDocument.aspx?sDocType=wqy&amp;sRepoType=0&amp;sReportName=CityWise-SalesRevenue&amp;sRefresh=Y&amp;lsSState=' &amp;@Select(Store\State)  &amp; '>' &amp; @Select(Store\State) &amp; '</a>'

I get a blank document.

Can u help me where i am going wrong


jyothimd (BOB member since 2005-04-17)

I think wqy is not supported by XI.
:frowning:
Anil


Anil Kumar :india: (BOB member since 2005-04-19)

Hi,
I got the report link working: I can “drill” to a new report, opened in a new window and refreshed by the prompts, in InfoView.

But the original report lose control and gives an error:
An error occurred while communicating with the server (Error: INF -2146823266).

And same goes for all the other reports: if I refresh allready opened, linked report, all the other reports in Infoview gives the same error message.
Strange thing is that everything works fine when I open the report from the admin side (Objects -> -> preview)

Any idea where this might come from ?

-Petteri :confused:


PetteriRomsi (BOB member since 2005-05-12)

Hello,
could you please tell me how to find out CUID of report?


minebox :ru: (BOB member since 2004-11-29)

Can you tell us exactly how you got it working? What syntax did you use? Maybe that will give us a clue as to what the issue is.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

if you are using web intelligence documents, use the following syntax.

‘<a href=http://jyothia:8080/businessobjects/enterprise11/InfoView/scripts/openDocument.aspx?sDocType=wid&sRepoType=0&sDocName=CityWise-SalesRevenue&sRefresh=Y&lsSState=’ + [State] + ‘>’ + [State] + ‘’

let me know if you are having problem


RadN :us: (BOB member since 2003-04-28)

I’ve done an object in webintelligence with formula:


= "<a href=http://fioul-l-4000005/businessobjects/enterprise11/InfoView/scripts/openDocument.aspx?sDoc=VuoronKonerullat&amp;sType=wid&amp;lsSpva="+[pva]+"&amp;lsSVuoro=" + [Vuoro No] + "&amp;Refresh=Y&amp;sWindow=new>" + [pva]+ "</a>"

It opens the new report with correct data (2 prompts) in a new window so it works great… except that the original report with the above object can’t be refreshed anymore.

It works on the admin side (as mentioned earlier)… :crazy_face:

-Petteri
(Sorry for the delay, I’ve been out of office)


PetteriRomsi (BOB member since 2005-05-12)

I have report linking working to and from Webi docs.

My preference is set to use "Interactive"which works fine on the Source doc but the linked (Target) doc does NOT come up in interactive mode. Does anyone know how to get the target to come up “interactive” or better still where to find the list of all valid parameters ?

Thanks, Tony


BOTONY (BOB member since 2005-04-21)

The target report (webi) after an opendocument.jsp call comes up but I cannot filter or sort on the target. The target was saved as “enhanced” and the session of the user is set to “interactive” but no functionality (sort or filter) exists in the target.

Any clues ?


BOTONY (BOB member since 2005-04-21)

Tony,

No clues here. I haven’t heard of this before. Have you called Tech Support? I’d suggest opening a case.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

I have taken clue from this link to create following as a WebI object

="<a href=“http://http://iwdbsss1.dcs.mcorp.com:8812:8812/wijsp/scripts/openDocument.jsp?sDocName=Report2&sType=wid&sRefresh=Y&
lsSYear=”+UserResponse (“Query 1 - DP1” , “Year”)+ “>”++""

but while trying to validate in WebI getting following error message

The object ‘http://iwdbsss’ at position 11 does not exist in the report. (Error: WIS 10006).

one of my friend suggested that we need to check on server if we have the OpenDocument funtionality. is this correct or am i just missing something in the syntax


ganta (BOB member since 2005-05-12)

I think ur syntax is wrong. I can see two “http” and w2 port numbers. Try removing that.

Anil


Anil Kumar :india: (BOB member since 2005-04-19)

I am sorry . looks like i got the wrong url here.
here is the one i am actually using

‘<a href=http://iwdbsss1.dcs.mcorp.com:8812/businessobjects/enterprise11/desktoplaunch/InfoView/scripts/openDocument.jsp?sDocType=wid&sRepoType=0&sDocName=SLA_Detail2&sRefresh=Y&&lsSMSG_SEQ=’||TRD_WORK_ITEM.MSG_SEQ||’“Target=”_parent">’||TRD_WORK_ITEM.TRANS_REF_NO||’’

while clicking on the hyperlink i am getting following error message

HTTP Status 404 - /businessobjects/enterprise11/desktoplaunch/InfoView/scripts

type Status report
message /businessobjects/enterprise11/desktoplaunch/InfoView/scripts
description The requested resource (/businessobjects/enterprise11/desktoplaunch/InfoView/scripts) is not available.

Apache Tomcat/5.0.27


ganta (BOB member since 2005-05-12)

No more infoview/scripts directory. use for the following link , try and let me know the error.

‘<a href=http://iwdbsss1.dcs.mcorp.com:8812/businessobjects/enterprise11/desktoplaunch/opendoc/openDocument.jsp?sDocType=wid&sRepoType=0&sDocName=SLA_Detail2&sRefresh=Y&&lsSMSG_SEQ=’||TRD_WORK_ITEM.MSG_SEQ||’“Target=”_parent">’||TRD_WORK_ITEM.TRANS_REF_NO||’’

thanks


RadN :us: (BOB member since 2003-04-28)

I worked perfect while using the link you provided.
Thanks for the timely tip


ganta (BOB member since 2005-05-12)