#Multivalue on Calendar day

[Former Member]

Hi,

I have two reports – Main and Detail report:

Main report:

I have applied hyperlink on the Date column which passes Calendar day, Plant and Material to the detail report.

Now, if I select one plant and one material for a date range(1^st oct till 31^st oct), the hyperlink works fine. But if I select two plants, one material for date range I get #Multivalue error.

If I apply “Avoid duplicate row Aggregation” , I don’t get the #Multivalue error but now I have two rows for one date.

I don’t want to display two rows for single date. The measure values (Gallons, ($) etc)  should show the summation for both the rows (1^st oct) in one row .

I tried using In, ForEach and ForAll but i think i am not using the formula correctly.

Please advice.

Thanks,

Antara

[arijit_das]

what is the formula for your hyperlink ? If you are passing Plant object as parameter, try to pass UserResponse("Plant Prompt Text") instead.

[Former Member]

Hi Arijit,

Following is the formula for hyperlink:

="<a href=\"../../opendoc/openDocument.jsp?iDocID=ATwsf6ciPehMoSWQ.JZB7JU&sIDType=CUID&sType=wid&&lsS0P_FIL_PLANT="+URLEncode(""+[Plant])+"&lsI0P_FIL_PLANT="+URLEncode(""+[Plant].[Plant - Key])+"&lsS0P_FIL_MATERIAL="+URLEncode(""+[Material])+"&lsI0P_FIL_MATERIAL="+URLEncode(""+[Material].[Material - Key])+"&lsSpsEnter%20value%20for%20Calendar%20day%20(Start)%3A="+URLEncode(""+[Calendar day])+"&lsSpsEnter%20value%20for%20Calendar%20day%20(End)%3A="+URLEncode(""+[Calendar day])+"\" title=\"\" target=\"_blank\" nav=\"doc\">"+[Calendar day]+"</a>"

Thanks,

Antara

[Former Member]

Hi Antara,

You have mentioned lsS in front of Plant which allows only single parameter. Try using lsM which allows you to pass Multi parameters.

lsM0P_FIL_PLANT="+URLEncode(""+[Plant])

Regards

Sunil

[arijit_das]

I can see some points here to be noticed:

1. lsS0P_FIL_PLANT : This means the parameter accepts only single value. You need to define prompt in the target report to accept multiple values by using inlist operator. Then you need to use lsM0P_FIL_PLANT in the url. I assume 0P_FIL_PLANT is the prompt text.

2. ...&lsS0P_FIL_PLANT="+URLEncode(""+[Plant])... : May be [Plant] object is having multiple values in the row. Check it by dragging [Plant] dimension in the report and check if the rows are split into two. If yes, then you can not pass multiple values in this way. If you have Plant prompt in source report, then you can use ...&lsM0P_FIL_PLANT="+URLEncode(UserResponse("Enter Plant"))...

3. No need to pass plant keys separately if there is no duplicate plant names for different keys. This can cause #multivalue also.