The table below lists the additional filters associated with the Project Finances Group Aggregate, Project Finances Element Aggregate, and the Project Finances Element Monthly Detail reports. The (Set 1) and (Set 2) are two sets of filters for two sets of output columns in the Finance Group Aggregate Report and the Finances Element Aggregate reports. The two sets allow you to compare finance aggregate values. You can independently set three filters for each set.
The Project Finances Element Monthly Detail report contains some specific filters in addition to the common Finance Aggregate Definition filters like Date Range, Finance Dataset, and snapshot for Plan.
Parameter | Value | Description |
---|---|---|
Date Range |
| The range of months that are used to generate the aggregate value of the Total, Group1, Group 2 etc., columns in the aggregate reports. For Monthly reports, this determines the months that will be populated in the output, all other months will have 0 values. For Annual totals, use one of the different Fiscal Year choices. For Quarterly totals, use one of the different Quarter choices. If you want totals for a particular month, use one of the Month choices. For a range of months, use "Any Start or End Month" You can choose aggregation of past or of future months. |
Finance Dataset |
| This filter determines which set of month-by-month values for the Date Range specified above are considered for aggregation in the Aggregate reports, and which finance values are fed into the month-by-month columns as non-zero in the Monthly reports.
For each project, the system displays by default the "Current" values in the Finance page, and it is automatically updated from the Project Activities or from the Project Team Finances (provided the Finance Template has been configured to receive these values).
You can also take Snapshots of the "Current" value and store this as a "Plan" and not have it updated as edits are made or as the Project Activity and Project Team finances change. This Filter allows you to select which Dataset (Current or Plan) you are interested in outputting in the report. If you are using Lock months to lock finances, the filter also allows you to consider the Lock month in generating the aggregate for the other months. For example, you can choose to take values from before the Lock month if you go through a finance validation that ensures that the numbers before the Lock month have been checked. Further, the filter allows you to also consider this month (when the report is run) and take the Plan values from before this month and the Current values from after (and including) this month. |
Snapshot for Plan |
| If the Finance Dataset filter refers to a Plan value, then the "Snapshot for Plan" further defines which of the Snapshots should be used for the report output. The Default Plan Snapshot is always at the top of the list.
The system shows the complete list of all Snapshots taken in the drop-down list (up to a limit of 100). To ensure consistent aggregation of values, it is recommended that all users that make snapshots use a consistent naming scheme. |
Finance Detail Level |
| The filter sets the level of detail of the Finance element hierarchy that is shown in the report. This also sets the number of rows in the output per project. Total: means show only the top level (Total). Group: means show the Group level, one level below Total (up to 5, depends on number of Groups configured). Category: means show the Category level, 2 levels below Total. Element: means show the Element level, 3 levels below Total |
Show Upper Levels |
| This filter decides if the output should show higher levels of the Finance items hierarchy when a lower level item is chosen in the Finance Detail Level filter above This is relevant if you are doing your own aggregation of the element level values using Excel and you do not want the Category, Group, Total level values to interfere with this aggregation. |
The table below describes the additional output parameters for the Project Finances Element Monthly Detail report.
Output Parameter | Description |
---|---|
Starting Month | Enter the starting month. This output setting decides which set of months will be shown in the report output. |
Number of Months | Enter the number of months. For instance, you may set the number of months to 36 starting with January 2010 for several runs of this report. Then depending on the Date Range filter setting (above) varying sets of months of these 36 will be populated for different runs of the report. |
Break down Finance Details by Organization | If this check box is selected, then each finance line is expanded and broken down by organization finance allocation. Note: This report is usable only if the finance allocation percent total is exactly 100%. The system displays a warning message if it does not equal 100%. |
Working with Finance Aggregate Reports
Legal Notices
Copyright © 2000, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, November 30, 2016