This website is not affiliated with, sponsored by, or approved by SAP AG.

Query combining (almost) non-related data?

Business Warehouse

Moderators: Snowy, thx4allthefish

Query combining (almost) non-related data?

Postby ThomP » Tue Apr 12, 2011 7:17 am

Hi

The tilte may be a little misleading, but nevertheless it is true, at least to a certain extend...

I have a user request for a report showing the average number of Quality Notifications per Batch/Production Order by week/month.
I can easily make a query showing the number of notifications, and I can probably find the number of batches that these relate to (since batch is an attribute of notification), but I need to find the total number of batches for the specified periode, including batches that had no quality issues and therefore are not present in the notification master data.

Any good ideas on how to accomplish this?

/Thomas
ThomP
 
Posts: 13
Joined: Mon Jul 03, 2006 4:05 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 1 guest





This website is not affiliated with, sponsored by, or approved by SAP AG.