What Is a Combined Analysis?

A combined analysis is a report that combines the results of multiple reports (criteria) into a single report. The way in which we combine these reports allows us to simulate joins in the data that otherwise do not exist. Each column in a combined analysis, simply put, contains the results of multiple queries against the database. The tables queried by each criterion in a combined analysis do not need to be the same tables, or even come from the same subject areas.

Every report you build is querying one or more tables in the database. Think of the result of this query as a new virtual table. A combined analysis queries two or more of these virtual tables to generate a new result. Using the set operators described ...

Get Oracle CRM On Demand Combined Analyses now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.