Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Eg:

Table 1

2010 Cus 1

2010 Cus 2

2011 Cus 3

table 2

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 ?

Regards,

Kannan.B

Former Member
Not what you were looking for? View more on this topic or Ask a question