Alternative for result from other query and merge dimension option option
Hi Everyone ,
Am Developing one webi report over bex Query.
Actual scenario is output of one webi report should be the input of other webi report.
2010 Cus 1
2010 Cus 2
2011 Cus 3
cus1 m1 100
cus2 m2 200
Cus3 m1 400
Report 1 designing
First report created using table 1 and prompt for year
Report 2 designing
Second report created using table2 and prompt for customer
So when am Running first report it will ask for parameter year and if am selecting 2010 then the report will return C1 and C2
this out put should e the input for report 2.
So out put will be 100+200=300
NOTE:1. Result from other query is not working in webi filter pane since am building on olap universe.
2. Merge Dimension performance is very slow .
Any Solution ?