BO 4.0 Error on document link

[Former Member]

Hello

I'm using BO 4 SP 2 Patch 10.

I'm trying to use the link document functionality within Webi.

In report 1 you will filter down to the customer this must be passed to report 2.

In report 2 the customer is set as a single BW bex variable.

I specify the customer field as a prompt in document link [Sold-to] and as a key field [Sold-to].

The url looks like this:

="<a href=\"../../opendoc/openDocument.jsp?iDocID=ASIlm_MtOO9IlsAWzaA2P_U&sIDType=CUID&sType=wid&sRefresh=Y&lsSZBOE_CUST="+URLEncode(""+[Sold-to party (0SOLD_TO)])+"&lsIZBOE_CUST="+URLEncode(""+[Sold-to party (0SOLD_TO)])+"\" title=\"\" target=\"_blank\" nav=\"doc\">"+[Sold-to party (0SOLD_TO)]+"</a>"

On clicking the hyper link this gives the error message WIS 00013.

While trying to invoke the method java.util.List.size() of object loaded from local variable 'values'

If I set the prompt to "user prompt at runtime" on clicking the hyperlink it will then prompt you to specify the customer.

Is this a bug that needs to be fixed? or is there another way to pass the variables using document prompts?

Graham

[aharon_digilov2 · Accepted solution]

Hi Graham

You have to transfer the KEY values to BEx variables so  replace [Sold-to party (0SOLD_TO)] with [Sold-to party (0SOLD_TO)].[KEY] .

Additionally you don't need this part of code+"&lsIZBOE_CUST="+URLEncode(""+[Sold-to party (0SOLD_TO)]) it's unnecessary.

if after this corrections Document Link still will not work try to replace lsSZBOE_CUST with lsMZBOE_CUST (this for Multiple/Range variables)

Regards,

Aharon Digilov

[Former Member · Accepted solution]

Hi Aharon

Thanks for the reply

Sorry do I enter the (Sold_to)].[key] in the formula bar or within the document link by docuement prompts? If I add this in the formula bar I get a error message that the key does not exist? If I enter .[Key]. with a formula within document prompts I also get an error message.

If I change the IsS with IsM and save then click on document link the document prompt is reset to "use document default"?

Regards

Graham

[aharon_digilov2 · Accepted solution]

OK,

lsM is for Mutliple variable if your BEx variable is single value  leave it lsS

try to put [Sold-to party (0SOLD_TO)].[Sold-to party (0SOLD_TO) - KEY] or just when you edit the link formula

choose instead of [Sold-to party (0SOLD_TO)] sold-to party KEY object

Regards,

Aharon

[Former Member · Accepted solution]

Hi Aharon

I specified the sold-to key from the query and have been able to pass the field through to the second report successfully.

Many Thanks for the help

Regards

Graham

[aharon_digilov2 · Accepted solution]

Hi Graham

You welcome

please only select that it's answered to your post:)

Regards

Aharon

[Former Member]

Hi Graham,

Does your prompt names excatly matches the Bex variables?

Regards,

Nakul Mehta