Detail Objects and #Multivalue

building reports webintelligence legacy
1

Hi.

We have upgraded to webi from boxi3
and i encounter a problem on webi that i don’t recall having on boxi3:

I have 2 data providers with relation of 1 to many
and a detail object on the many dp

when i use the detail in a table with the 1 table i get an annoying multivalue message in the column in which i put the detail.

I understand that webi maybe trying to aggregate the detail object with no success because it is a string object…

I am sure i could do this in boxi3

Any suggestions how to fix this?

Thanks

Rafael

Rafaelzan44 (BOB member since 2015-07-12)

2

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.

3

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

Thanks
Rafael

Rafaelzan44 (BOB member since 2015-07-12)

4

Try and adapt your problem to fit with this suggestion:

https://archive.sap.com/discussions/thread/3245018