Skip to Content
0
Former Member
Aug 15, 2016 at 09:54 AM

OpenDocument problem with numeric Webi Parameters

164 Views

Hi everyone,

I'm having a problem with the BO 3.x version of OpenDocument.

I have a webapp which creates an OpenDocument URL, containing the Webi Report to kick off, along with its parameter names and list of values.

If my Webi parameters are text, then I can happily include a list of values for that parameter:

http://uswfpres690:8080/OpenDocument/opendoc/openDocument.jsp?

&iDocID=AVMsV5ewXQlMqnJay3VhtT8

&sIDType=CUID sOutputFormat=H

&sType=wid

&sRefresh=N

&sInstance=Param

&lsMList+Of+Currencies=GBP;CHF;USD

&lsMList+Of+Years=2013

This all works perfectly fine.

But, if I now try to pass a list of numbers for the (numeric) "List Of Years" parameter, it fails, with an error of:

The prompt 'List Of Years' contains an invalid numeric value. (WIS 10705)

I don't get it.

In Webi itself, I can run this report, and pass it three year values, and it's shown as 2013;2014;2015... but I set this in my URL, it throws this error.

I have tried changing that part of the URL to the following values, and each gives that error:

&lsMList+Of+Years=2013;2014;2015

&lsMList+Of+Years=(2013;2014;2015)

&lsMList+Of+Years=(2013,2014,2015)

Does anyone have any idea how I can get around this issue...?