Webi - Linking reports

[lenastodal]

I've recently learned about linking reports to each other, but I'm wondering if it is possible to have 2 reports linked where when the first report is run and a set of data is returned, that data is immediately transferred to the linked report and processed through its query.

For example, to make it simple let's say my first report brings in a list of 10 products (model & serial number) sold by my company. Can I then have all 10 of those products transfer over to the second report's query? The second report would take each model/serial number combination and return the names of the customers.

The issue I have now is that I can link the reports so that when I click on any product sold, the second report will run for that item, but I need all the items included together in the same report. My real life situation involves hundreds of products so clicking on each link individually does me no good. Thanks

[lenastodal]

Welcome and thanks for visiting SAP Community to get answers to your questions. Check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html By adding a picture to your profile you encourage readers to respond to your question: https://www.youtube.com/watch?v=46bt1juWUUM

[former_member447840]

You would need to pass a value to the 'child' report that has relevance to the 10 products that your selecting on. As an example you could create the hyperlink (via the wizard) on a 16 ounce cups category which then (passes the category to the child report) shows the 10 cups you have in the line of 16 ounce cups. In other words, you need to find a hierarchy in your data that works to do this.

Hope this helps.. ~Joe

[mhmohammed]

Hi Michael,

If you want to merge data from multiple queries, you WILL NEED a common identifier/column between the 2 queries, if not, how can do it?

Query 1: State, Expense

Query 2: Store, Revenue

Using the above data, can we create a report showing State, Store, Expense and Revenue? No, we can't, coz we don't have State level Revenue data and Store level Expense data.

Except for an unconventional way of doing it, by merging State and Revenue, we can get Summary level of Revenue by State (if we know which Store falls in a specific State), and NOT Expense at Store level, as Store is the lowest level of granularity, and we don't have Expense data at that level.

Thanks,
Mahboob Mohammed

[mhmohammed]

Hi Michael,

You can do this one report by created 2 queries:

Query 1: To get Model and Serial Number of products (say 100 products or more)
Query 2: To get data of the Customers (related to the 100 products from Query 1), the main idea is to create a filter on Query 2 as, Serial Number inlist Result/Object from Query 1 (and select Serial Number from Query 1).

The limitation though is that you can't pass more than 1000 values, if the Query 1 is returning more than 1000 values, the Query 2 will fail. In that case, you'll have to use only 1 query to create the report (Query 2), with a sub-query in the filter area.

Thanks,
Mahboob Mohammed

[former_member1184047]

Hi Mahboob,

Thanks for the response. The issue I have is that each report pulls data from a different universe. In my company, our BOBJ specialists are in high demand and they are booked out for several months, so I am trying to teach myself how to create the report I need so that I don't have to wait for their availability.

I have 2 existing reports and I am trying to create a new report with the data I need from each existing report. I tried creating 2 queries, each pulling from a different universe, and merging them but it did not work. I don't have common identifiers between each universe that would allow me to successfully merge them. I thought I could just leave each report as is, link them as I described above, and be able to work that way for now until I can get one of our experts to assist with merging the data I need from each universe.

Linking the reports works for individual cells, but if there is a way I can get the data from an entire column to transfer over to the second report all at once, that would be ideal.