Webi report from SAP BW

[Former Member]

Dear all,

We have requirement to crate report from SAP BW to get some materials. (query 1 in cube 1) In second query we would like to have details for this materials from query1 from cube2. From SAP NOTE 1367620 you can't use subqueries. How can we solve this problem?

Thank you for help!

Regards,

Gregor

[IngoH · Accepted solution]

Hi,

you could

a) use 2 reports in Web Intelligence and use the functionallity called merged dimensions

or

b) you can use hyperlinks and link from report 1 to report 2

Ingo

[Former Member · Accepted solution]

Hi Ingo,

Thank you for reply but I'm looking for solution that query 1 retrive me materials that we sold to specific customer and this is imput for second query...

If I understand with merge I need to merge materials from query 1 with all materials in BW cube to get that data?

Can you tell me more about hyperlinks?

Thank you for understanding and help,

Regards

Gregor

[IngoH · Accepted solution]

Hi Gregor,

you can find more details in the user Guide for Web Intelligence. Hyperlinks seems to be what you are looking for.

Ingo