Is it advisable to use “avoid duplicate row aggregation” to get rid of multivalue error? In the report we are merging data from 2 queries and in the report aggregation is not happening as expected. Selecting “avoid duplicate row aggregation” is giving the line level details.
crystallite100 (BOB member since 2014-07-31)
From you other posts it seems like all your measures should be reviewed.
Please read this:-
https://bobj-board.org/t/107995/6
Are you sure your duplicates are not the result of a chasm / fan trap?
Mak 1 
(BOB member since 2005-01-06)
Hi Mark,
Our data model is something like this. If there is one quote no there will be multiple quote line ids associated with that. 1:n. And there are around 35 columns in the report as its a raw data report. So if I select the avoid duplicate row aggregation for 1 quote no if there are 10 quote line ids its showing 10 lines which is actually correct. Otherwise instead of showing 10 lines it was showing 6 lines and in the quote line id column its showing multivalue error. And I can’t show quote line ids like this 123,234,345 in one cell while fixing multivalue. As it will create problems while creating pivot tables. Please suggest.
crystallite100 (BOB member since 2014-07-31)
Well, I have worked with something similar before.
https://bobj-board.org/t/166900
As far as pivoting goes, most databases can do this for you, these alterantive methods might help:-
http://scn.sap.com/thread/3245018
https://bobj-board.org/t/88778
Mak 1 (BOB member since 2005-01-06)