Expressions

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.

Expressions is available within the Dimension Management section of Infrastructure system. You (Business Analysts) need to have ETL Analyst function role mapped to access Filters. In the left hand side (LHS) menu of Infrastructure home page, click Financial Services Applications. In the Financial Services Applications screen click + to expand Master Maintenance section and select Expressions. The Expression Summary screen displays the list of pre-defined Expressions with other details such as the Expression Name, Folder Name, Return Type, Created By, and Creation Date. You can also make use of Search and Pagination options to 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. For more information, refer Pagination and Search and Filter.

• Add Expression Definition

• View Expression

• Modify Expression

• Copy Expression

• Expression Definition Dependencies

• Delete Expression

Expression Definition Dependencies

This option allows you to view the dependencies of Expressions, created in all public folders, shared folders to which you are mapped and private folders for which you are the owner. Additionally, the Read Only role should be mapped to your user group.

To view the dependencies of a defined Expression in the Expression Summary screen:

1. Select the checkbox adjacent to the required Expression Name.

2. Click button in the Expressions tool bar. The Check Dependencies button is disabled if you have selected multiple expressions.

The Dependent Objects screen is displayed with Object id, Name, and id type of the dependant Objects.

Back to Top

Delete Expression

This option allows you to delete the Expressions, created in all public folders, shared folders to which you are mapped and private folders for which you are the owner. Additionally, the Write role should be mapped to your user group. You can delete an expression which has Read/Write Access Type. To delete an expression from the Expression Summary screen:

1. Select the checkbox adjacent to the Expression Name(s) whose details are to be removed.

2. Click Delete button in the Expressions tool bar.

3. Click OK in the information dialog to confirm deletion.

Back to Top