Webi isn’t trying to aggregate the detail object. It simply doesn’t know which of the many values to put in that cell. This is by design; a detail object should have a one to one relationship with its owning dimension.
Thank you mark for taking the time to answer.
Is it possible to somehow achieve the 1 to many goal?
that is if i have 2 dp’s
for example dp1 is customer number and customer name
and dp2 is customer number and items bought (descriptive strings)
each customer can have more than one item in dp2
is it possible to display one table showing customer number, customer name and items
and if a customer has more than one item in dp2 then show all of them 1 row for each?
and all that without doing free hand sql or changing the universe