Reference Guide

Building Reports Using the Web Intelligence Java Report Panel 53
Incompatible objects and SQL
When you build a query, Web Intelligence generates SQL behind the scenes. This SQL is
run against the database to produce a result that Web Intelligence displays in a report. For
a query to be free of incompatible objects, Web Intelligence must be able to generate a
single SQL query to retrieve the data. If this is not possible, the query contains
incompatible objects.
How Web Intelligence handles incompatible objects
If a report requires more than one SQL query to provide its data, Web Intelligence places
the data from each query in a separate block, as shown below.
Web Intelligence does not allow you to place incompatible objects in the same block by
dragging and dropping. You can create a block with incompatible objects by using the
formula bar to type the names of the objects. In this case the incompatible objects appear
as #INCOMPATIBLE.