O'Reilly logo

SAP BusinessObjects Reporting Cookbook by Yoav Yahav

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required