how to merge 3 universes on 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]

use Forcemerge() function in revenue column in the crosstab.

=ForceMerge([Revenue)

[Former Member · Accepted solution]

Great !

Thank you for your help.

It looks so simple... i still need to learn a lot !

[Former Member]

Here is what i get.

On top it is the 3 tables.

Down this is after merging date, IDA and IDB.

The issue is that when i put IDB in the crosstab, you can see that transaction is ok, but not revenu (it stands for all transaction that day).

If i put IDA in the crosstab, the, revenu is ok but not transaction.

Any idea on how i should handle this ?

[amitrathi239]

merge Id-a from query 1 and 3.id-b from query 2 and 3.date from query 1 and 2.assuming your revenue and transaction objects are measure objects.

If there is still issue then share issue with some sample data screenshot

[Former Member]

Hi

thanks for the reply.

Here is the screenshot with some datas.

Any ideas ?