#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

[Former Member]

Vinayak,

Is [Status Count] defined as a measure? And is it counted at the Customer level? If not it should be, and that may solve the problem.

Thanks

[vinayakgole]

Hi Bill,

Thanks for your comment.

Yes it is a measure and is created with a pseudocode like

Red: count(customer) where sales<100

Green: count(customer) where sales>100

etc

Best regards,

Vinayak

[Former Member]

Hi Vinayak,

Should it not then be:

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

and that formula would be the same in each cell of that row.

Is it a vertical table or a crosstab?

Thanks

[MariannevL]

The multivalue is not caused by the measure (the count), but by the customer dimension object.

Since you have more than one customer and you try to put it in one cell, you get multivalue.

Really the only option to pass more than one value to an opendocument is to use the concatenation.

Because you are on BW, it is also not an option to build the pre-query in webi and use the results of that query as a list of values for the detail report.

Because you are on BW they expect you to solve that kind of problem in BW.

I am sorry but I do not see any other options than either concatenation or the pre-query bex variable in the detail bex query.

Good luck,

Marianne