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...?