Retail Fund Toolkit: Preconfigured Components

OLAP Reports

Entity Reports

Profile Name	Description
eglMFP-Entity	Display all share class entity data

NAV Query Reports

Profile Name	Description
eglMFP AdHocPerf	Performance statistics for a user input date range. Uses link period override feature.
eglMFP Audit (12M)	Rolling 12 month performance statistics used to feed performance audit advanced reports
eglMFP Audit (6M)	Rolling 6 month performance statistics used to feed performance audit advanced reports
eglMFP Audit (Ad Hoc)	Ad Hoc performance statistics used to feed performance audit advanced reports
eglMFP NAV Analysis (12M)	Rolling 12 month performance statistics used to feed price analysis advanced reports
eglMFP NAV Analysis (3M)	Rolling 3 month performance statistics used to feed price analysis advanced reports
eglMFP NAV Analysis (6M)	Rolling 6 month performance statistics used to feed price analysis advanced reports
eglMFP NAV Analysis (ITD)	ITD performance statistics used to feed price analysis advanced reports

Dynamic NAV Returns Reports

Profile Name	Description
eglDNR-AnnRptPrePostTaxPerf	Returns typically shown in an annual report including pre tax, post tax and post liquidation for the 1, 5, 10 and ITD periods. All returns are load adjusted and annualized.
eglDNR-ClosedEndPerf	3 variations of performance. At NAV, At Market Price (NAV as reinvest price), At Market Price (Mkt Price as reinvest price).
eglDNR-ConvertiblePerf	Convertible returns for standard periods.
eglDNR-DailyStdPerf	Short term returns, daily frequency, commit map set. Daily workflow to support daily trend reporting of short term returns.
eglDNR-LoadAdjustedPerf	Load adjusted returns for standard periods (including applicable redemption fees).
eglDNR-LoadImpactPerf	Displays load adjusted and no load returns as well as the difference for standard periods.
eglDNR-MonthlyGrowthPerf	Monthly workflow report showing various growth of 10K values for static periods.
eglDNR-MonthlyStdPerf	Longer term returns, monthly frequency, commit map set. Monthly workflow to support trend reporting of longer term returns.
eglDNR-NoLoadPerf	No load returns for standard periods.
eglDNR-NonStdPerf(Synthetic)Perf	Non standard, synthetic returns for standard periods.
eglDNR-PriceOnlyPerf	Price to price returns (all fields are set to ignore all distribution types).
eglDNR-QuarterlyStdPerf	Quarterly frequency, commit map set. To support quarterly trend reporting (10 years of quarters).
eglDNR-RetailFundVsBenchmarkPerf	Fund and benchmark relative returns for standard periods. Benchmark returns based on NAV method.
eglDNR-Rolling1YearDecompositionPerf	Various stats for rolling 1 year period including standard /non standard returns, price and distribution data, load and redemption fee amounts, and so on.

Query Tool Views

Profile	Description
eglQT-MFPDailyStdPerf	Trend reporting of daily short term performance statistics (rolling 30 days)
eglQT-MFPMonthlyStdPerf	Trend reporting of monthly longer term performance statistics (rolling 12 months)
eglQT-MFPQuarterlyStdPerf	10 Years of quarterly returns (rolling 10 years)