Skip to Content
avatar image
Former Member

XI 3.0 Open Document and BEx variables (prompts)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 07, 2008 at 01:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded