The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

Computed items

While there is a significant ability to add and create custom columns in the Query section, the Results and Table section also contains the ability to create custom columns. Computed items are custom columns where logic is used to create new values, modify existing items, or to create calculations.

The syntax used in computed items in Query section is the SQL of the database, but the syntax used in the Results and Table section leverages JavaScript to create the custom columns. To add a computed item, right-click anywhere in the Results or Table section and select the Add Computed Item menu item or click on the Add Computed Item menu item from the Results or Table menu. Once the menu item has been selected, the Computed Item window ...