Compare text from two universes

building reports webintelligence
1

Hi Experts,

I work on a Web intelligence report (4.1) the fields come from 2 universes.The fields from both sources are like ‘User’–‘Martial Status’–‘Employment Status’ and so on as many as 80 odd fields. The number of users are around 50000

Now the report should display any mismatch from 2 sources/universes eg. Martial Status for a User15 is Married in one universe and another has Un-married so its should show up a mismatch

I tried doing it as per (Compare two columns in WEBI) but I get error msg as IES 10076 - Incompatible Object when I try to equate two fields from 2 universes using IF statement to get TRUE or FALSE

For few fields it works but not for all.

Is there any function/formula that compares the text from 2 sources and returns True or False ?

Kindly help for work around if any.

Best Regards
Rahul

hirahuls (BOB member since 2014-01-16)

2

Hi , the point here is that you’re trying to compare data from two universos that are not sincronized ( merged).
Try this approachhttp://scn.sap.com/community/businessobjects-web-intelligence/blog/2014/12/08/using-merged-dimensions-to-perform-set-operations-union-intersection-and-minus
Regards,
Rogerio

rgoulart :brazil: (BOB member since 2011-08-21)

3

Sorry for the delayed response. I will give a try a get back.
Thank you very much.
Rahul

hirahuls (BOB member since 2014-01-16)