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

Using other query results

Using other query results is an advanced method about how to restrict other queries based on other types of operands. This concept is similar to the subquery concept with some differences:

  • The query doesn't generate SQL; rather, it uses the results returned by other query results (could be seen as a local function rather than a database function).
  • Query results from other universes can be used (in a subquery, it is limited to the same universe).
  • Other data providers such as Excel can be used too.
  • The number of rows that the main query can process from the inner query is limited to 1,000 rows (the 1,000 value limit is a common limit for most of the databases; however, in some cases, it's possible to extend it to 3,000 or even ...

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