7 Replies Latest reply: Jun 19, 2013 6:33 PM by Simone Caneparo RSS

Merge Dimension and Join in WebI

Surya Kumar
Currently Being Moderated

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.