Merge Dimension and Join in WebI

Hello All,

I have 2 WebI Reports based on BEx queries

Query 1 - Dimension1 , DImension2,Dimension3,Measure 1 and Measure 2

Query 2  - Dimension2,Dimension3,Dimension4,Measure 3 and Measure 4

My requirement is to make a third WebI Report

with the following fields

Dimension1,2,3,4 and Measure 1,2,3and 4

I made a Merged Dimension on Dimension2 and 3.

When I create the third query I am able to bring all the measures in the report

but when I try to bring Dimension4 from Query2 it tells that it is not compatible.

What should be the best way to handle this or steps to overcome the above issue.?

Thanks in advance.


Helpful Answer