Writing Result Column Formulas

As described previously, the result columns that correspond to the criteria report columns in a combined analysis do not contain a formula. These columns do not reference the database, so there is no analytic field reference. These result columns receive their data from the criteria reports. Adding a formula that references the Oracle CRM On Demand database to result columns will cause an “Unresolved Column” error in your report.

It is possible, and often desirable, to use a formula in a result column to aggregate data across the multiple criteria reports. To do this, we must write a formula that references the columns in the combined report rather than the columns in the database. Every column in a combined report ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.