WEBI Queries based on Bex Compare

[Former Member]

Hi All,

I have following fields in my Bex query .

Query1 :CustomerID,Signed Date, Create Date, End date , End Reason.

Query2: CustomerID,Signed Date, Create Date, End date

I want to create a report to display Query1 data and add a flag to show whether customerIDs match in two queries or not.

I have created a merged dimension on CustomerID and created condition as Var1= ( IF(Query1.customerID=Query2.CustomerID ;Match;NoMatch)).

The moment I add Var1 to the report, it is displaying  only match records and filtering out all Nomatch records but, I want to show entire data set with flag Column displaying match and no match .

We don't want to create universes over Bex queries and do this.

Any help or suggestions are really appreciated.

Thanks,
Raja

[sateesh_kumar1]

Hi Raja ,

Use extended merge dimension in the report .

Thanks

[Former Member]

Hello Raja,

Below document would be what you need.

Regards

Niraj