Transaction File failures with no error message

Fund Analyser is not providing any indication within the Reconciliation Status tab as to why these files have failed. We have reviewed and selected all available tabs and filters within the application, but no error messages, validation results, or failure details are being displayed.  As a result, we are unable to determine the root cause of the issue to assist the users. Can this be reviewed and meaningful error message be displayed to users?

Correction tool improvements

Bulk relationship imports Too many clicks for record corrections Record entity states for AFM not showing in the relationship correction

System Time out

I've noticed that if there's no activity on the system for a certain period, it times out and displays an error message. This has been causing some inconvenience as it disrupts the workflow. Could you please look into this issue and see if there's a way to extend the timeout duration or provide a solution to avoid this interruption? screenshot below for details.

File Loade Completeness checks - Data Download excel

The completeness checks additional tabs are not necessary. This needs to be streamlined further and easier for the user to understand as there is unwanted data that is not necessary, otherwise we could end up with more delays before receiving the final data.

File Loader - Blank value

Blank FUM or Transaction columns error message Change from ‘collected value is missing’ to ‘Transactions column is missing’ so that is clear a column is missing and not a value.

File Loader - Duplicate File

Where a duplicate file has been detected could we change the error message to the following. Error duplicate file detected. ‘You have loaded a duplicate transaction file XXDummyTransactions202411.csv’ OR ‘You have loaded a duplicate FUM file XXDummyFUM20241130.csv’ Please select the tick box and select ‘confirm’ to overwrite the existing file for this period.

File Loader 'Upload Settings' page

The upload settings screen is not clear on what the user needs to do first. We need clear instructions so maybe something as follows. ‘To upload a file please select the browse buttons below and choose your prepared files. Please select ‘save changes to load your files’.

File Loader - 'Upload' page

Could we amend ‘Upload’ to ‘File Upload’

File Loader, 'Home' page blurb

Could we add the following ‘welcome’ blurb ‘Welcome to Fund Analyser File Loader’

Annual Static Form errors uploading

The acceptable downloads for annual static form are .xlsx as shown below, however uploading the same file in .xlsx produces an error message. See second screen shot for details. The upload process should accept file type .xlsx I observed the file contains all funds with a status of , active, closed, merged, pending funds. The file needs to exclude all except ‘Active funds’. Second screen shot

Transition to Openfunds, with automations

Data enrichment

Possible new data attributes: Institutional and retail FUM: splitting FUM data by the 2 different channel categories. Channel split: many records still assigned to channel code 1700 (Other intermediaries). ETF: flagging ETF funds and allowing filter on Industry Reports

Industry Report: more configurations

Group column by subsector SDR labels filter

Hermes Feedback

Hi all, Just a few points from me having had the chance to play around with the tool for a while. Do let me know if anything is unclear. Landing Page after login to be the new reports page Move the Run report button to the bottom of the page, of have the sidebar scroll down as you scroll down and change the filters Rename Asset category to Asset Class Definitions button on report page – not quite sure what I am looking at in the export when I have Report rank in the Statistics bar When I have distribution channel in group rows (I just get unspecified?) Have “Report display settings” and “Statistics” as a multiple click dropdown menu? Instead of having to click into their search bars to bring up the stats. For the “i” where it gives information, maybe have this as a button to press as sometimes when I hover over it, the definition doesn’t appear straight away Charting function instead of excel download Be able to group rows by – any of the filters i.e. domicile, product types, wrappers etc When having more that one statistic, have them one after another.. so Jan – June 2024 net flows and then Jan to June 2024 gross flows etc.. instead of grouped together Auto width columns after exporting For time periods – be able to select trailing figures i.e. YTD,1Y/3Y/5Y etc as well as monthly, quarterly etc Add a filter for vehicle? i.e. mutual fund/ETF etc

EFAMA UCITS REPORT TOTAL DIFFERENCES

FundAnalyser recreated EFAMA report for June 2024 noted data difference for Net Asset value UCITS Mixed assets total v ECHO Live. Created a fund level report on FundAnalyser to assess the funds within this category so that I can match with ECHO LIVE. FundAnalyser fund report totals differs to FundAnalyser UCITS Mixed Assets total.

Industry Report: Scheduled distribution

Data alignment with Echo

Private client (reallocated)

Data download

Press Release Report Fixes

Data collection improvements

Data not expected flag and status on dashboard. More dashboard statuses for files in holding queue. Anonymise TPA uploads. Datasource failure notifications. Reconciliation output dialogue - more results per page. Improved handling of underscore and cases for upload file headers.

Improved error logs

Missing column

Go-live stabilisation

SDR label in Fund Directory

SDR data in Press Release

For Press Release in early June.

Raw Data download

Porting over some of the original Echoweb functionality to download a unpivoted raw data file. The following two reports will be available to download: Industry_FUMSales_ExcludeWrapper.xlsx Industry_SalesOnlybyChannel_PostJan2010.xlsx No period date, instead specify start and end start post be post 2010, max range 12 years.