how to merge 3 universes in webi

[Former Member]

Hello,

I have checked the blog here and there on google and i couln't find an answer to my problem which is rather simple I guess... but I am a beginner in webi.

So here it is :

I have 3 universes.

Universe A wich gives ID-A, Revenue, Date.

Universe B wich gives ID-B, Transactions, Date.

Universe C wich gives ID-A, ID-B.

For one ID-A, there is no more than one ID-B. And vice versa.

How can i get in the same report : ID-A, Date, Revenue, Transactions ?

I have tested several ways to merge ID, Date, and creating new variables but if i get the right figures for Revenues, then it's wrong for Transactions.

Can anyone help here ?

That would be very much appreciated as it's been hours i've be looking for the solution.

Thanks !

Raphael

[amitrathi239 · Accepted solution]

have you checked the below link.I have already provided the answer,

https://answers.sap.com/questions/336461/how-to-merge-3-universes-on-webi.html?childToView=335690#an...