Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multivalue error from detail object after merging dimensions in WebI

HI experts,

I have merged 2 queries 

Query1(Delivery) contains 

·         Delivery num

·         Delivery Item

       Reference number

QuQuery2(Sales) contains

·         Sales order

·         Sales Item

·         Material

I merged Reference number and Sales Oder number, after merging I was getting incompatible object error while trying to add Delivery Num and Delivery Item to report layout, so I created a variable and made it detail  =[ Delivery Num]and associated it with merged dimension  and same as detail=[ Delivery Item]

It worked fine for Delivery Number. But a Delivery number may contain many Delivery item,(1:N relationship) and Delivery item is not getting segregated. Hence I am getting #MULTIVALUE ERROR

I have gone thru many formus and no where there is a solution to this.

Does anyone know alternate method to add incompatible object to report after merging, instead of converting it to detail?

Please Help.

Thanks in advance

Former Member
Not what you were looking for? View more on this topic or Ask a question