Multiple queries can be related in a Web Intelligence document in different ways.
· Basic multiple queries draw unrelated data from different sources.
· "Synchronized
queries" relate the data from different queries around a dimension
that contains data common to both queries. These dimensions are called
merged dimensions.
You merge dimensions in the Web Intelligence reporting interface after you
have created and run your multiple queries.
· "Combined
queries" are a special kind of query created in the Web Intelligence
query interface. Combined queries generate SQL containing the UNION,
INTERSECT and MINUS operators (if the database supports them) or
simulate the effect of these operators.
Combined queries allow you to answer complex business questions that are
difficult to formulate using standard queries.
You cannot create combined queries in Query - HTML.