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.
In order to use Un merged dimensions in a report block which had merged dimensions the technique is creating details objects which should qualify the corresponding merged dimensions. so you can follow that rakesh said or try below.
1. create details objects for dim 1 as dim1_detail and dim4_detail for dim4 respectively
2. Associate the details objects to merged dimension as
For dim1_detail is associated to DIM 2
For dim4_detail is associated either to DIM 2 or DIM 3.
3. Instead of DIms use detail objects in the report.
Suresh Babu Aluri.