I am working on a report which is coming from two BEx queries.
User Name Report Name Session
User Name Fund Center Department
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.
Fund Center Department User Name Report Name Countofsession
Medicine #Multivalue User1 ZQW_1 5
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.
Can someone please suggest on this?