12 Replies Latest reply: Jan 8, 2016 12:31 AM by JEFFREY PENNER RSS

#multivalue error for detail object in webi report

Shreya Singh
Currently Being Moderated

Hi,

 

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.

 

 

Thanks.