December 18th 2017
IHS Markit is pleased to announce the v17.1 release of our EDM Warehouse software which is compatible with EDM v17.1. The highlights of this release are as follows:
User-Defined Account Groups Maintenance
- Enhanced features to maintain user-defined account groups.
- Define group start date and base currency.
- Search and assign eligible participants by Account ID and Name.
- State period of a participant in a group; i.e. start and end date.
- View participant lineage in the user-defined account group.
Reporting Currency
- Allow administrators to select exchange rates based on price types, exchanges, and sources.
- Flexibility on viewing and reporting data in alternate currencies.
- User-Defined Inquiries automatically inherit configuration from the parent unless specified.
- Define price type, price exchange, price source and price validity at the application level, if there is only one source of FX data.
- Define price type, price exchange, price source and price validity at the inquiry level if there is more than one source of FX data; e.g. FX Rates from Internal System versus Software Vendor.
Auto-Permission New Accounts
- A new rule-based feature which allows administrators to auto-permission new accounts to one or more user groups.
- Full revision history of changes in rules is maintained for audit and compliance purposes.
- Can be integrated and invoked via EDM after completion of Portfolio / Account Master load to EDM Warehouse.
- Positive or negative permissions: all permissions to User Group A where Book ID is Private Equity; all permissions to User Group A where Book ID is not Private Equity.
New Inquiries
Fund Performance Inquiry
- View performance data for a period or period range including returns, fees and expenses for funds or share classes.
- Compare performance data with linked benchmarks.
- Refine performance results by using available selections; e.g. Benchmark Type, Benchmark Purpose.
Extended Security Classification Position List
A new position data inquiry template that supports the use case of security level classification:
- Dynamic update to field business names based on the selection of security characteristics set.
- Removes the overhead of creating position-level classifications out of security-level classification as found in EDM Warehouse v9.0 and below.
Security Updates
- SQL injection and ethical hack issues were updated for Nam and Account totals inquiries.
- Column names and other secure information are not shown on capture in HTTP and HTTPS traffic and logs.
- Inline SQL code and query formations were removed and are done server-side which makes the system more robust and secure.
Table and Loader Updates
- Market Data tables have been enhanced to ease data uploads and remove the dependency on other market data table content.
- Benchmark tables have been added to allow clients flexibility in linking Indices or Benchmarks to Funds and Accounts.
For additional information about this release please see the EDM Warehouse v17.1 release note.
Please contact your client manager if you are interested in upgrading to this release.
