wis 10705 invalid numeric value in OpenDoc url

[system]

I’m trying to set up a OpenDoc url to a webi doc from my xcelsius dashboards. This url should also cover some prompts

• a start period (yyyymm)
• an end period (yyyymm)

But I get the error: wis 10705 invalid numeric value when i click my url button in the dashboard.

My opendoc url is:

../../../OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=AfJomAv2nKlJuNHz5helsj8&sWindow=New&lsSFrom (YYYYMM):=F82&lsSTo (YYYYMM):=F83

F82 and F83 contain the numericvalues 201401 and 201408
from a webi report.
In webi i’ve set: =ToNumber([Q1].[CurrentPeriod])
and just to be sure F82 and F83 are set up with =VALUE(‘Sheet5’!$AZ$3)

but no luck…

Do I need to change something to the url? use “” around the excel cel references??

ps
If I change F82 and F83 with 201401 and 201408 (clean without any colons), the opendoc url runs fine…

---

Tiny (BOB member since 2004-11-10)

[system]

Try two things:

1. Check that you have a lower case l for your &lsS (and not a 1)
2. Your url looks like it’s using the actual value “F82”, rather than what’s in cell F82. Should you not have a concatenate, or be joining two cells?
   My opendoc looks something like this:

=CONCATENATE("... server/opendocument ... and other stuff... sRefresh=Y&sType=wid&lsSTaskAssTo=",AH88)

Debbie

---

Debbie (BOB member since 2005-03-01)

[system]

@Debbie

Try two things:

1. Check that you have a lower case l for your &lsS (and not a 1)
2. Your url looks like it’s using the actual value “F82”, rather than what’s in cell F82. Should you not have a concatenate, or be joining two cells?
   My opendoc looks something like this:

=CONCATENATE("... server/opendocument ... and other stuff... sRefresh=Y&sType=wid&lsSTaskAssTo=",AH88)

Debbie

Thanks for your response debbie, and indeed I think it’s trying to fill the prompt with F82 in my case

• I’ve got a lower case “l” in my prompts cause the prompt work when I replace the reference to a excel cell to a actual value (for instance 201408)

• so you should always work with CONCATENATE to concatenate the prompt excel reference cells to you url? (you can’t just add them to the url using some sort of syntax?)

---

Tiny (BOB member since 2004-11-10)

[system]

@Tiny

so you should always work with CONCATENATE to concatenate the prompt excel reference cells to you url? (you can’t just add them to the url using some sort of syntax?)

Well allegedly you can. But I’ve never got it to work. I always put the value into a separate cell and concatentate them together in the opendoc which works perfectly.

debbie

---

Debbie (BOB member since 2005-03-01)

[system]

Thanks debbie, It’s working now (with concatenate)

---

Tiny (BOB member since 2004-11-10)