Webi Report Data compare between two columns when Source is different

[#1]

Hello Friends,

Need your help on below:

There are two different queries and tabs (One tab for each query) in Webi Report BI 4.2

Query 1 - Account Number1 column has 100 records

Query 2 - Account Number2 column has 2000 records

On the report, I need to compare the data between Account Number1 and Account Number2 and need to flag them as Y or N in a different column. Need to show this Flag in Query 1 where the tab has only 100 records.

If Account Number1 = Account Number2 then Y Else N

If statement is not working in this scenario as these two columns are coming from two different universes/source and merge dimension is not useful.

[former_member702336]

Hi Brian,

I even tried enabling "Show rows with empty dimension values", but no luck.

[former_member702336]

Hi Amit,

When I enable "Extended Merged Dimension," all 100 account numbers are flagged as Y instead of 50.

[omacoder]

Merge on Account Number, then on the block of the report, right click and check the option that says "Show rows with empty dimension values"

[former_member702336]

Hi Amit,

Yes, I have tried using both objects in IF - ELSE statement, but I only get matching rows (Only 50 rows) where Account Numbers in query 2 matches with Account Numbers in query 1.

Requirement is to get all Account Number from query 1 (in this case 100) and flag them as Y or N.

[amitrathi239]

in the webi document property->check the check box of "extended merged dimension" and try.

[amitrathi239]

have you tried with merged dimension.after merging these two objects, use both objects in IF-else statement.