Skip to Content
0
Jan 05, 2017 at 04:27 PM

Multivalue error on Detail variable

192 Views

Hello,

I am working on a report which is coming from two BEx queries.

Query 1:

User Name Report Name Session

Query 2:

User Name Fund Center Department

Output:

Fund Center Department User Name Report Name CountofReports

I have merged the User Name and created detail variables for Fund Center and Department.

In my scenario, a user can be mapped to more than one department due to which I get #multivalue error when I use the Department detail variable.

I should be showing each department in separate rows for a user.

Eg

Error Output:

Fund Center Department User Name Report Name Countofsession

Medicine #Multivalue User1 ZQW_1 5

Actual Output:

Fund Center Department User Name Report Name Countofsessions

Medicine AP User1 ZQW_1 5

Medicine QA User1 ZQW_1 5

I have gone through most of the discussions from below but it did not resolve my issue.

https://onedx.find.sap.com/s#t=multivalue%20error&n=1&p=default&repo=srh

Can someone please suggest on this?