Retail Fund Toolkit: Preconfigured Components

OLAP Reports

Entity Reports

Profile Name

Description

Profile Name

Description

eglMFP-Entity

Display all share class entity data

NAV Query Reports

Profile Name

Description

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

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

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)