#Multivalue error in hyperlink

[vinayakgole]

Hi,

We have a situation where in we need a scorecared as a parent report which will then pass on the relevant information to the child detail reoprt.

The scorecard will look like:

Red                      Yellow                 Green

------                     --------                 ---------

10                          20                       30

----                        -----                     ----

  |                            |                           |

hyperlink            hyperlink               hyperlink

The hyperlink should pass values to the child report which should show the details for the selected customers.

Hyperlink:

="<a href=\"../../opendoc/openDocument.jsp?sRefresh=Y&sDocName=Child Report&lsMCustomer="+URLEncode(""+[Customer])+"\" title=\"\"target=\"_blank\" nav=\"doc\">"+[Status Count] +"</a>

The child report has a prompt for customer.

However, the measure Status Count on the parent report always throws up a #Multivalue error. I know this issue has been discussed in some other posts. But I have started a different thread so we can arrive at a work around. If in the case above, I cant use a hyperlink to pass multiple values, what can be a better way.

The above is using

WebI 4.0 over Bex using a BICS connection.

Thanks,

Vinayak

[MariannevL]

I don't know how the detail report is built, if it is the same bex query or a different one,

but really the easiest option would be to have the category as the prompt/variable,

not a list of customers.

The only way to pass multiple values to a prompt is to have them in a row separated by semicolons (;).

ant it will take some doing to get a list of dimension objects values to go into one cell.

(that is if you get it to work at all... )

No seriously you would have to have a fixed maximum number of customers in the list
and pinpoint every single one of them. So this would work for 5 customers, 10 is hassle and if you do not even know how many there will be (1000?) it's simple not doable.

Hope you can make the category red/yellow/green somehow a bex variable (pre-query?) instead of customer...

Hope this helps,

Marianne