The View/Download Calculation Results feature allows you see the Performance Returns report results for auditing and maintenance of report profile entities. You can drill down into the underlying data and run diagnostic queries. With the appropriate privileges you can then edit the data. You can also export the results to Excel.
The following are the options for View/Download:
- Calculation Results. Opens the underlying performance calculation report results for auditing and maintenance of all entities associated with that report.
- Calculation Results For This Entity. Opens the underlying performance calculation data for auditing and maintenance for only that entity in the row.
You can also view the selected entity's details from Portfolio Data Center.
You see the Commit Journal workspace displaying a list of available views in the right navigation.
You see the selected view in the workspace.
You see the underlying performance calculation results with tabs for details of Report, Diagnostics, Cash Activity, Price, Analytics, Position Cross Reference, Security Cross Reference, Performance, Ratings, and Details.
You see the Commit Journal workspace displaying a list of available views in the right navigation.
You see the selected view in the workspace.
You see the underlying performance calculation results with tabs for details of Report, Diagnostics, Cash Activity, Price, Analytics, Position Cross Reference, Security Cross Reference, Performance, Ratings, and Details.
The Client Side Commit process allows you to manually commit changed performance calculation results to the database.
To manually commit results:
- From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
You see the Commit Journal workspace displaying a list of available views in the right navigation. - Select a view and click Submit View on the ribbon. Or, double click the view.
You see the selected view in the workspace. - Click View/Download on the ribbon and then select Calculation Results or Calculation Results for This Entity.
You see the underlying performance calculation results. - Edit underlying data as needed. See "Edit Performance Returns."
- Click Client Side Commit on the ribbon. Or, right click and select Client Side Commit.
You see the Commit Options dialog box. - Select one or more Entities by using the Entity Selector.
- Select whether you wish to calculate to-date returns, Yes or No.
- If you selected Yes, specify the returns you wish to commit.
Options include:
– Year End
– Quarter End\
– Month End
– Use the Business Calendar - Select Additional Options as necessary.
- Select the Commit Source.
- Click Publish.
- You see a message confirming the action.
After you make changes or additions to Performance returns, you must resubmit the Performance Calculation report in order for the scrubbed records to be picked up.
To resubmit a performance calculation:
- From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
You see the Commit Journal workspace displaying a list of available views in the right navigation. - Select a view and click Submit View on the ribbon. Or, double click the view.
You see the selected view in the workspace. - Select the row you want to submit.
- Select Submit Calculation on the ribbon.
You see a message confirming that the report was submitted successfully.
The Submit Calculation with Override option allows you to resubmit performance calculation data with different parameters without first needing to download return results. You can enter values that temporarily override the options associated with the report profile and its assigned report rule. You can select dates and entities, report rule, field rule, benchmarks, and commit options.
Note |
---|
The fields on the Submit with Override dialog box are optional. You only need to change those fields that are appropriate. |
To resubmit with override:
You see the Commit Journal workspace displaying a list of available views in the right navigation.
You see the selected view in the workspace.
You see the Submit with Override dialog box with options to select dates and entities.
Options include:
– Use Entity History (default)
– Auto Add Benchmarks
Options include:
– Preliminary
– Final
– Only if With-in Tolerance
Options include:
– None
– Rollup Relations with Security Level (default)
– Rollup Relations only
You see a message confirming that the report was submitted successfully.
You can edit or scrub underlying data if you have the appropriate privileges to perform data maintenance.
Note |
---|
When you edit performance returns a new or replacement record is inserted into the database, but the original source data is not changed. The scrubbed record is an image of the original and is tagged with a different source interface instance. If you enter a new value for a performance return, you must run the Client Side Commit process to save the new value. For more information, see Client Side Commit. |
To edit underlying data:
- From the Performance Center window, click the Performance Desk and click Commit Journal in the left navigation.
You see the Commit Journal workspace displaying a list of available views in the right navigation. - Select a view and click Submit View on the ribbon. Or, double click the view.
You see the selected view in the workspace. - Click View/Download on the ribbon and then select Calculation Results or Calculation Results for This Entity.
You see the underlying performance calculation results. - Select a cell you wish to change and right click to view the editing options.
Options include:
– Add Security Position
– Edit Security Position
– Edit Performance Returns
– Performance Returns Maintenance Journal
– Go to Cash Activity Maintenance - To add a security position select Add Security Position.
You see the Add Security Position dialog box. - Enter security and other data in the appropriate fields as needed.
- To edit a security position select Edit Security Position.
You see the Edit Security Position dialog box. - Select a security and make changes to the appropriate fields as needed.
- To make changes to an existing value select Edit Performance Returns.
You see the Edit dialog box showing the Existing Value and a blank field for New Value. - Enter a New Value.
- Click Save.
You see the changes in the cell, which is now highlighted to show that it has been changed.