Merge Dimension and Join in WebI
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.