XI 3.0 Open Document and BEx variables (prompts)

[steve_bickerton]

Can open document in Web Intelligence 3.0 be used to pass values to BEx variable/prompt (where the BEx variable is part of a query which populates the universe)?

Thanks

[steve_bickerton]

We were actually able to get this to work, but the we have discovered we cannot pass values that have two words.

For example, the value "Batteries" is accepted successfully. But the value "Fuel and Gases" is not passed successfully.

Here is the open document syntax (as generated by the wizard):

="< a href=\"https://stld9862.hydroone.com:8081/OpenDocument/opendoc/openDocument.jsp?iDocID=M0jqGzEABdqBABTwlgAAQ.IAAo4KDH8AAAA&sIDType=CUID&sType=wid&sRefresh=Y&lsMMaterial%20Group%20Mandatory="URLEncode(""URLEncode([L01 Material Group]))"&sWindow=New\" title=\"\" target=\"_self\" nav=\"doc\">"[L01 Material Group]+"</ a>"

Please note, I changed the tags <a to < a so to keep the formula in BOBJ syntax.

Edited by: Steve Bickerton on Oct 7, 2008 3:13 PM

Edited by: Steve Bickerton on Oct 7, 2008 3:14 PM