This is a document that I received from my sales consultant on how to link multiple web reports.
*************************************************
First of all, the "official" syntax:
http://<ServerName>/wi/bin/iswi.dll/WIGenerator/wigenerator/
generator/OpenDocument?
sDocName=<DocName>&
sDocType=W&
iDocId=<DocId>&
sRepoName=<DomainName>&
sOpen=Y&
lsS<PromptNamet1>=<Value1>&
lsM<PromptName2>=<Value2>&
lsM<PromptName3>=<Value3>
...
Explanation of bracketed items and names above:
ServerName : Webi server name.
sDocType : Type of target report (WebI report: sDocType=W, BO report: sDocType=R).
sDocName : document name in the repository.
iDocId : Document ID in the repository (you can found it if you check the document URL link in corporate document)
DomainName : Document domain name.
PromptName1,2 : Prompt name
Value1,2,3 : Value of the prompt
lsS is a single select prompt and lsM is muti choice prompt :
//lsS single choice prompt answer
//lsMi multiple choice prompt number i answer
//lsC context prompt answer
//lsD dialog prompt answer
// lsCBR -> refresh LOV, only one allowed
Note regarding the prompts:
In WebI 2.0 Opendocument syntax for the prompts was lsS (for single choice prompt) and lsM (for multiple choice prompt).
In WebI 2.5, we There were 2 different syntax:
äh lsCBS & lsCBM on Unix,
äh lsS & lsM on NT.
In WebI 2.6.0, the only recognized syntax was: lsS and lsM.
In WebI 2.6.1, both syntaxes are "understood", but still the "official" one is the lsS & lsM.
Ok, the practice now:
Following is an example on the use of the Opendocument syntax:
The objective is to open a triple-prompted pre-published thin client report with an Opendocument URL, and get the is Report refreshed with some specific values passed in the document prompt.
Step one: Creation of the report.
In this example I first created a basic WebI report based on universe "beach" as following:
Objects: Country, Resort and Services.
Conditions:
Prompt on Country (Displayed prompt: "Country")
And
Prompt on Resort (Displayed prompt: "Resort")
And
Prompt on Service (Displayed prompt: "Activities")
I ran this query, filled the prompts with values: "US", "Bahamas Beach", "Activities".
Once the report got displayed, I published it with "refresh on open" with name "Testpromptermelo1".
Step two: creation of the URLs:
We presume in this example that the thin client report "Testpromptermelo1" is identified in the repo as DocId #44, the Document domain name is "Document" and that the WebI server is http://ermelo1:82/
Note: you might run the below examples on the webiserver http://ermelo1:82/. (Login: ctsgensup, password: ctsgensup)
In the following URL, the report Testprompt1 is called, all its prompts valorised. Results gets automatically displayed.
http://ermelo1:82/wi/bin/iswi.dll/WIGenerator/wigenerator/ge
nerator/OpenDocument?
sDoc=Testpromptermelo1&sTyp=W&iDocId=44&sRepo=Document&sOpen
=Y&lsSCountry=France&lsSResort=French%
20Riviera&lsSService=Activities
In this next example, the last prompt isn't valorised. All prompts should then be displayed. The first two valorized, the third one empty, expecting to be valorized:
http://ermelo1:82/wi/bin/iswi.dll/WIGenerator/wigenerator/ge
nerator/OpenDocument?
sDoc=Testpromptermelo1&sTyp=W&iDocId=44&sRepo=Document&sOpen
=Y&lsSCountry=France&lsSResort=French%20Riviera
In this last example, the values for the last 2 prompts are missing. therefore, all prompts will appear
http://ermelo1:82/wi/bin/iswi.dll/WIGenerator/wigenerator/ge
nerator/OpenDocument?
sDoc=Testpromptermelo1&sTyp=W&iDocId=44&sRepo=Document&sOpen
=Y&lsSCountry=France
Note1: in the next SP (SP2), it will be possible to avoid the display of the valorized prompts by adding the variable &NAll= at the end of the opendocument URL.
Another important note: There are 2 bugs in the managment of the prompts with Opendocument.
Note2: If the non-valorised prompt is NOT the last one of the list of prompts of the URL, then Opendocument inverts the valorization of the prompts (e.g.: Value of Prompt A goes to prompt B, Value of Prompt B goes to prompt A)
Note3: order of prompts in the URL must match the order of the prompts in the report itself. e.g: based on the above example, we have the Prompts ordered as "Country", "Resort" and "Service". The following Opendocument URL:
http://ermelo1:82/wi/bin/iswi.dll/WIGenerator/wigenerator/ge
nerator/OpenDocument?
sDoc=Testpromptermelo1&sTyp=W&iDocId=44&sRepo=Document&sOpen
=Y&lsSCountry=France&lsSService=Activities&lsSResort=French%
20Riviera
will fail as the prompts Resort and Service have been switched.
This enhancement is for the next SP. (SP2).
