Primavera Unifier collects data from various managers, including cost, portfolio, resource and schedule, and displays it in cash flow curves. Curve options, for example, data sources, and distribution selections, determine the appearance of a curve in a cash flow worksheet. The worksheet window displays a graph on the top portion of the window, and a list of curves in this file on the bottom portion. Each curve listed has its own data set, which you can view in the Details window. Depending on the curve set up, the Details window is where you manage the curve data.
To open a cash flow worksheet
| 1 | Navigate to the Cost Manager and select Cash Flow. The Cash Flow log opens. |
| 2 | Select a curve from the log and click Open, or double-click the curve. The Cash Flow Worksheet window opens. |
To set curves for viewing in the cash flow worksheet
| 1 | Navigate to the Cost Manager and select Cash Flow. The Cash Flow log opens. |
| 2 | Select a log and click the Properties button. |
| 3 | On the General tab, check the data source(s) that has the curve types you want to view. |
| 4 | Click OK. The Properties window opens and the selected worksheet opens with a graphic of the curve(s). |
The worksheet is divided into two parts: a graph view on top, and a table view below. Each part can be individually maximized.
There can be multiple curves displayed on the graph. You can add as many curves as you need to the worksheet. Each curve must be associated with a data source, which are created in Administration Mode. The curves are color coded; the color is determined in the data source.
In the graph, you have the option to filter out some curves and display a subset of the available curves; change the zoom level between monthly and yearly; or print the graph. You can switch between incremental view or a cumulative view.
Just as you would with a spreadsheet, you can use the split screen view to make your information much easier to read. In the Detail window, you can see two parts of a row by splitting the view so that you can see the beginning part of a row and the middle or end of the same row.
To get the split screen, click on the Split button and the bottom of the Detail window displays two columns. The same row is highlighted across both columns. You can drag the vertical column separator to suit, and use the horizontal scroll bars to view different parts of the row.
You can switch the display of the curve and worksheet data between a monthly view or yearly view by changing the zoom level. This will not affect the time scale itself, just the data and curve display. The Year zoom level is only applicable if you have data that spans over multiple years.
| • | The Zoom buttons are in the top right portion of the Cash Flow Worksheet. |
| • | Month (M): This changes the time line focus of the curve and table to show months and year in the cash flow time period. |
| • | Year (Y): The displays time period increments in years, and is useful for multi-year projects or contracts. |
Changing the zoom setting will adjust the zoom for both the graph and the table.
The table underneath the graph shows the data for the curves. Each row corresponds to one of the curves on the graph, and displays the curve data in columns. The view is incremental; you can click the drop-down on the right to change the view to cumulative, which is view-only. The columns are:
Color: The color of the graph displays in the first column
Name: This is the name of curve, taken from the Data Source
From Date: The starting point of the curve. This can be entered manually or taken from a date field on the project/shell master schedule sheet, as defined in the curve properties.
To Date: The ending point of the curve, also manually entered or pulled from the schedule sheet.
Total: This amount is the cost portion of the curve. It can be pulled from a specified cost sheet column or business process. This total amount will then be distributed over the time period (From Date to To Date) to generate the cash flow curve. This is defined in the curve properties.
Unassigned: Any amount left over from the Total amount that has not yet been distributed.
Time Period Columns: These are the incremental time periods for the duration of the cash flow time period. That is, the From Date to the To Date, entered above. For monthly distribution, these will display each month and year from the From Date to the To Date. If shown Yearly, then each period is one year.
The data in these columns show the distribution of cost -- the value in the Total field. If you are doing auto distribution using a distribution profile, these values will be calculated based on the distribution percentages. If you are doing manual distribution, you will enter values into each time period (distributing the amount in the Total column). The Unassigned column will display how much of the Total column is left to be distributed. Primavera Unifier displays cost data using the latest exchange rate table.
Primavera Unifier displays commitment costs in both the graph and the curve portions of the worksheet window. Use the currency drop down menu to switch between the transaction and project currency, if they are different (otherwise, you will not see this menu). For more information, see Transaction Currency.
You can select a curve from main window and copy the data (time and amount) to another curve, with manual entry as distribution. Additionally, process data (time, amount and distribution) associated with WBS Codes (from schedule sheet) will be copied over to destination curve. See Copy Cash flow curves and curve data.
To view details for the curves
Select a row from the table and click Open (or double-click the row). The Details window opens.
| • | For cash flow by WBS or Summary WBS, all WBS or Summary WBS codes will display. If selected WBS or Summary WBS codes have been chosen in the Filter tab of the Properties window, then those codes display. |
Note: For cash flow by WBS in a baseline curve, the list of WBS codes displayed in the details window are from the schedule sheet and are read-only.
| • | For cash flow by commitment, all associated records (the base commit, any change orders, etc.) display. |
| • | If the curve has been designed for manual entry rather than in auto-mode, you can enter values in the Details window. |
Use Bulk Edit to edit cash flow data for multiple rows on the Details window
Filter the curves to display on the cash flow worksheet
Create and manage distribution profiles
View and manage cash flow properties
Activate or deactivate rollup status
Oracle Corporation
Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.