Troubleshooting aggregation problems
As we saw in this chapter, we can merge several datasets (data providers) in the same report into one table.
As long as we have the same common dimensions or we are able to merge data relying on the same number of common dimension objects, the results in the table will be projected correctly.
However, we might face some trouble when we try to merge data from datasets that don't have the same common dimensions.
This case can be very common as we will find ourselves many times building queries that don't match each other in all the aspects and objects.
Different queries can have a different granularity level or a different detail level. We can't expect a highly summarized query returning sales figures at the product ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
