URL of a document in WebIntelligence passing parameters

[promero]

I want to launch a document from another in WebIntelligence.

I know how to make a web link in a document. The content of the cell must be &quot;<a href=&quot;URL&quot;>TEXT</a>&quot;. This works both in HTML and in PDF. URL and TEXT can be placed dinamically with a formula.

Now my problem is which is the URL of the document i want to launch. I followed the FAQ &quot;How do you link multiple web reports?&quot; from mattflynn in this forum, but the server allways returns a page with the text &quot;This page is empty (WI0100)&quot;.

I have found how to launch a document without passing parameteres. I simply copy and paste the link from the list of enterprise documents. For example:
[tt]

http://widesa.aceralia.es/wi/bin/is...&UserSubmit=pat2d&Date=1031838308&ResolveDX=Y

[/tt]
I can force to refresh the document if I put [tt]&ForceRefresh=Y[/tt] at the end of the URL. If the document contains user pormpts, the stadard form asking them appears. But what I want is to skip that form, and to pass the user responses in the URL.

Someone knows how to do it?

 

[pabloj]

You should do this with the SDK (wiasp or wijsp) looking at how it manages those prompts Stick to your guns

 

[promero]

I finally make it work. the syntax that works for me is:
[tt]
http://<ServerName>/wi/bin/iswi.dll/WIGenerator/wigenerator/
generator/OpenDocument?
sDocName=<DocName>&
sDocType=W&
iDocId=<DocId>&
sRepoName=<DomainName>&
sOpen=R&
lsS<PromptNamet1>=<Value1>&
lsM<PromptName2>=<Value2>&
lsM<PromptName3>=<Value3>
[/tt]
It's almost the same mattflynn published in the FAQ, except I use [tt]sOpen=R[/tt] instead [tt]sOpen=Y[/tt] (the latter returns &quot;This page is empty (WI0100)&quot. The bad news is that it only works if you are already in a WebIntelligence session.

 

[promero]

Sorry, [tt]sDocType=R[/tt] for full-client documents. See FAQ on this forum for more info.

 

[ssudha]

Hi promero,

Can this URL method work with BO 6.1? How can the database userid and password be sent?

I am trying to use getHTMLView method but it is not returning anything.

Please suggest.

S Sudhakar

 

[promero]

Hi S Sudhakar

Sorry, but I have no access to Business Objects 6, so I don't know. About user/pass sending, I don't know either.

You should try with the SDK (wiasp or wijsp) as pabloj said, but I can see you are already trying it. About GetHTMLView, sorry but I have not tested it.