Modifying column definitions

Interactive Reporting leverages a JavaScript syntax programming language throughout each product section in computed items and custom programming. However, the Query section is the only section in the product that requires the use of database-specific SQL syntax for computed items or modifications to items in the query. Since the SQL is generated from the query and sent to the database, any modifications or computed items are passed to the database similar to the columns added to the Request line. New items can be added to the Request line by right-clicking on the Request line and selecting the Add Computed Item menu option. The Definition can be added in the blank Properties window that appears, as shown in the following ...

Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with O’Reilly online learning.

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