HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

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.