...
2. Dynamic NAV Returns Report. Based on your chosen workflow(s), schedule the appropriate Dynamic NAV Returns report to calculate and commit the returns and referential data associated with that workflow. For example, if you wish to deploy all three workflow frequencies, schedule each of the three following Dynamic NAV Returns reports and turn on the commit option.
EglDNR-DailyStdPerf. Short term returns (daily, MTD, QTD, YTD, and so on) that are typically reviewed on a daily basis. This report stores the calculated performance statistics with a ‘daily’ frequency flag.
EglDNR-MonthlyStdPerf. Longer term returns (1, 5 10, ITD, and so on) that are typically reviewed on a monthly basis. This report stores the calculated performance statistics with a ‘monthly’ frequency flag.
EglDNR-QuarterlyStdPerf. Quarterly return (et al) calculated and stored each quarter to support ’10 years of quarterly performance’ reporting. This report stores the calculated performance statistics with a ‘quarterly’ frequency flag.
Note that if any of the standard performance reports above either include data you do not wish to support or is missing information you need, the reports can be copied and modified to meet your exact needs.
3. To review performance you can either:
View the output of the reports noted in step 2 by navigating to the report studio results tab, or
Commit Journal. Use the Commit Journal to review calculated returns. The Toolkit reports commit returns as preliminary. You can either use these returns as is, or choose to enhance your workflow by instituting a process whereby returns must be finalized prior to use in downstream reports. Note that all system components can be used with preliminary returns. Finalized performance is an optional workflow that must be configured separately based on specific business requirements.
4. NAV Query Reports. If a fund has a suspect return, you can use one of the NAV Query reports to review and validate the fund accounting data loaded to the system. Just set the report to run for the fund and dates in question and scan the output for suspect data.
...
7. Frequency Based Trend Analysis in Query Tool. Once performance is calculated and committed, you can do frequency based trend analysis in the Query Tool. There is one Query Tool report for each of the three underlying Dynamic NAV Returns reports noted above, as follows:
eglQT-MFPDailyStdPerf. Displays all daily performance statistics for a rolling 31 day period. This query can be customized to display any number of days.
eglQT-MFPMonthlyStdPerf. Displays all monthly performance statistics for a rolling 12 month period. Can be customized to display any number of months.
eglQT-MFPQuarterlyStdPerf. Displays all quarterly performance statistics for a rolling 10 year period. Can be customized to display any number of quarters.