Creating a View and Managing an Existing View in the Cash Flow Worksheet
To create a view in the cash flow worksheet:
- Go to the shell tab and switch to User mode.
- In the left Navigator, select Financial Analysis, and then select Cash Flow to open the Cash Flow log.
- Select a curve from the log and double-click the curve to open the cash flow worksheet window.
- From the View drop-down menu, select Create New View.
The New View window opens.
- In the Save View As field, enter a name for the new view.
- Set the other view parameters in the following tabs:
- Curves: In the Curves tab, select curves from the Available Curves list, and click the Move arrow to add curves to the Selected Curves list, or click the Move All double arrow to move all available curves to the Selected Curves list. The last column in the Selected Curves list is not available for locking.
- Inflow: In the Inflow tab, select curves from the Available Curves list, and click the Move arrow to add curves to the Selected Curves list, or click the Move All double arrow to move all available curves to the Selected Curves list. The last column in the Selected Curves list is not available for locking.
- Outflow: In the Outflow tab, select curves from the Available Curves list, and click the Move arrow to add curves to the Selected Curves list, or click the Move All double arrow to move all available curves to the Selected Curves list. The last column in the Selected Curves list is not available for locking.
- Filters: On the Filters tab:
- Click the Add Filter button.
- Choose a Data Element: This drop-down list includes all Cost Code Segments and CBS Attributes. It also includes specific fixed-column items such as Total, From Date, To Date, and Unassigned.
- Choose a Condition: This drop-down list displays a list of conditions. This list is based on the type of data element selected.
- Choose a Value: Depending on the type of data element, choose a value that the query condition must meet.
Note: Currency precision is not adhered to within filters. For example, if your project currency uses four digits after a decimal point, the entries in the Value field for a Data Element related to a currency or a decimal amount or an entry in the Total or Unassigned column selected on the Filters tab for a view display only two digits after a decimal point.
You can add multiple filters to a view, and you can use the same data element multiple times. When adding multiple filters, you can use operators to specify that the view must match all listed filters or that it can match one or more of the listed filters. To add additional filters, click Add Filter again, repeat the preceding steps, and click the applicable operator that should apply. You can add up to 15 filters.
- And: If you want to specify that the view must match all listed filters, select And.
- Or: If you want to specify that the view should match any of the listed filters, select Or.
- Group By: Use the Group By tab to identify which columns should be used for grouping and in what order. When you use Group By to define a group based on CBS attributes, the summary row displayed on the final view shows the totals and distributed costs and–based on the filtered leaf-level rows–the earliest From Date and most recent To Date.
Note: To minimize the potential performance impact when a detailed, Current Cost Variance, or At Completion Cost Variance sheet is loaded, Oracle recommends that you use Data Elements (DEs) on the Group By tab that create useful groups, such as Type or Roll up Status, and avoid using DEs such as Cost Code, Code Name, and Cost Type.
- To save your changes, click Save.
To manage a view in the cash flow worksheet:
- Go to the shell tab and switch to User mode.
- In the left Navigator, select Financial Analysis, and then select Cash Flow to open the Cash Flow log.
- Select a curve from the log and double-click the curve to open the Cash Flow worksheet window.
- From the View drop-down menu, select Manage Views to open the Manage Views window.
Provided that you have pertinent permissions, in the Manage Views window you can:
- Move the order of the views in the View menu on the toolbar.
- Make a specific view visible or hide it.
- Delete a specific view.
Note: If your administrator defined global views in a Cash Flow template and pushed them to your project/shell, these views are also listed in the View menu of your cash flow worksheet. (One of the views might also be used to define the Default view in the template.) You can use these predefined views to create additional custom views and you can change the order of the views. You cannot edit or delete the predefined views.
The current view is marked with a green check mark in the Manage Views window. To save your changes, click Save. To discard your changes, or to close the window, click Cancel.
Last Published Monday, April 14, 2025