Expression

An Expression is a user-defined tool that supplements other IDs and enables to manipulate data flexibly. Expression has three different uses:

To specify a calculated column that the Oracle Financial Services Analytical Application derivatives from other columns in the database.
To calculate assignments in data correction.
To create calculated conditions in data and relationship filters.

Example:- Calculations like average daily balances, current net book balance, average current net book balance, and weighted average current net rate can be created through Expressions.

Based on the role that you are mapped to, you can access read, modify or authorize Expression window. For all the roles and descriptions, see Appendix A.

The roles mapped to Expression are as follows:

Expression Access
Expression Advanced
Expression Authorize
Expression Phantom
Expression Read Only
Expression Write

Figure 8-27 Expression Summary window

This illustration shows the Expression Summary window, which displays the list of pre-defined Expressions with other details such as the Expression Name, Folder Name, Return Type, Created By, and Creation Date. The window has the Search and Expression pane. In the Search pane, you can specify the details of the expression to search. In the Expressions pane, the search results are displayed, you can also Add, Edit, copy, Check Dependencies, and Delete the expression from this pane.

The Expression Summary window displays the list of pre-defined Expressions with other details such as the Expression Name, Folder Name, Return Type, Created By, and Creation Date. For more information on how object access is restricted, see Object Security in Dimension Management module section.

You can also search for a specific Expression definition based on Folder Name, Expression Name, or Return Type and view the list of existing definitions within the system.