11 Replies Latest reply: Jul 21, 2014 7:18 PM by saimohan chennuru RSS

#multivalue error for detail object in webi report

Shreya Singh
Currently Being Moderated



I am facing #multivalue error in my webi report.

I am using 2 queries 


Query 1


Account Number

Cost Center


Query 2

Account Number

Order Number


Now I want to display Account Namer,Cost Center and Order Number in the report.


So I merged Account Number from both the queries, and created a detailed object "Order" and associated it with [Query 1].[Account number].


But Order displays values for some accounts, and displays Nulls and #MULTIVALUE error for some accounts.


Please through some light on this issue.

I tried every possible solution from my side, but couldn't get it work. It is happening because there is a 1:N relationship between Account Number and Order. I can not use any aggregate function because it will give only the Max or Min value, but I want list all the value of for each Account Number. Avoid Duplicate Row Aggregation was also checked but it didnot help.