Release 2.2.0
This major release includes exciting updates and improvements across all parts of Xplain:
New features
- Entity Level NAV: Introduces support for managing NAV at the legal entity level
- Overlay Contextual Market Data: View relevant Market Data in context of Overlay tasks for IR_INDEX & INFLATION
- Highlighted Column Groups: Configurable view column groups can be highlighted with color/border
- All Market Data Tab (MD XM): All Market Data is visible under the ALL tab in preliminary tasks
- Preliminary Clearing—View All Data: Option to view both relevant and non‑relevant Market Data for Preliminary MD clearing
- XM Outcome API: MD/VD Exception Management outcomes are available via API
- CSV Export for Dashboards: Export VD & MD exceptions dashboard data to CSV
- Client‑Side Task Results Grid: task-results-grid moved to a client‑side grid
- Performance—Org Hierarchy: Company/Entity/Portfolio performance improvements (imports/usability)
- Back Navigation to Task: From a dashboard → trade navigation, Back returns the user to the originating task
Improvements
- Auto‑refresh Lock Monitor: Lock monitor page now refreshes automatically as locks change
- Resolution Scope Removal: Removed the Overall/Individual resolution scope selector in MD & VD XM tasks
- FX Collar Import Validation: Put strike must be equal to or lower than the Call strike
- VD Dashboard NULL Tests: Only NULL tests are set up to run on P1 for Valuation Data Dashboard
- Exception Settings Optimization: Faster calculation of applicable settings for legal entities
- Curve Config Optimization: Improved performance for curve config IDs by marked data
- Dedicated Checkbox Column: Checkboxes are their own column and append on column click
- Dashboard Toggle Enhancement: Old dashboards toggle now applies to attached tasks as well
- Break Test Filtering: Filter and sort on Break Test values within MD & VD XM tasks
- Cashflow Export: Cashflow exports use on‑screen display formatting
- Portfolio Settings Stream: CompanyPortfolioSettingsResolver.settingsStream performance optimised
- Preliminary MD XM Visibility: In sub‑streams, data from all other providers is visible
- Task Grid “Filter by”: Added Filter by action to MD/VD XM task‑clearing grid
- Workflow Auto‑assignment: Engine can automatically assign underlying tasks
- Results Sorting: Backend sorting by ExternalTradeID / Trade Type in Calculation Results
- Date Labels: “Curve / Valuation Date” renamed to “Curve Date” and “Valuation Date” respectively
- MD Dashboard Outputs: Improved outputs for MD dashboard list and tasks
- Relevant Data Column: Dashboard list shows whether Relevant data only was applied
- Terminology: “Relevant portfolios only” renamed to “Relevant market data only”
- Test Updates: Updated tests after resolution scope removal and cleanup
- Grid Sorting/Filtering: Enable sorting and filtering on all MD/VD task‑clearing grid columns
- Button Counts: Always show counts on buttons for filtered/selected rows
- Horizontal Scrolling: Task‑clearing grids support horizontal scroll and drag
- Org List Counts: Counts added to company/entity/portfolio list window
- Bulk Non‑MTM Upload: NonMtmPortfolioUploadService supports bulk like PortfolioUploadService
- DKK3M Nodes: Added new node types to DKK3M curve
- Dashboard Grid Simplification: Removed expand/collapse from dashboard grid
- Stable Stats Window: Stats window size is no longer dynamic in XM tasks
- Smoother View Switching: Clear existing FE data while reloading on view switch
- Preferences Terminology: “Discounting Settings per Trade Type” renamed to “Index Mapping Rules for Discounting”
- Reset Break Test Forms: Break test definition forms reset properly
- Faster Task Navigation: Optimised navigation to a trade from a task
Resolved Issues
- Inflation Conventions: Use One/One instead of 1/1 to improve CSV export
- Offshore OIS References: OISOISXCCY nodes now reference Offshore OIS index correctly
- Dashboard Status Reversion: Status returns to In‑progress when tasks are re‑run
- Reactive Filtering: Surrounding tables update immediately after main table filtering
- Open Multiple Tasks: Multiple tasks can be opened without header‑too‑large errors
- Tasks View Filterable: XM tasks view supports filtering
- CLP Accrual Consistency: CLP accrual rate calculations align with accrued method
- Process Completion Marking: Dashboard marks completed on top‑level ProcessDoneEvent
- Preliminary Phase Completion: MD XM phase set to Completed when no preliminary breaks
- Dynamic Columns Sorting: Sorting/filtering works on dynamic ExternalId/Custom Field columns
- Audit Log Dates: Correct date formatting when count column has a value
- Large Dashboard Handling: Prevent Mongo >16Mb document rejections for large MD dashboards
- Task Definition Optionality: Not all fields required in task‑definition grid table (ZOHO 231)
- Permissions Enforcement: Removing Dashboard Admin prevents Exception Management settings updates
- Projection Curve Display: Correct projection curve shown in calibrated curve configuration
- Onboarding UI: Removed Collapse/Expand all button
- NAV Table Refresh: NAV table refreshes on anchor date change
- Back Navigation from VD Tasks: Navigation back to dashboard restored from VD tasks
- Portfolio Date Filters: Date filters work in Portfolio Trade List
- VDG Values Count: Values count on VDG list reflects settings
- Tree‑select Isolation: Tree‑select only uses its own dropdown values
- VD Inside VDG: View Valuation Data within a VDG when trade‑level NAV data present
- Back Navigation from Trade: Back works after navigating from a dashboard for all trade types
Data migration
- v2.02.0_01 Create database views supporting the new Entity Level NAV feature. These are recreated on every launch.
- v2.02.0_02 Add new index to ipvDataValue
- v2.02.0_03 Add new index to companyLegalEntityNav (new collection)
- v2.02.0_04 Add new index to nonRequiredProviderData (new collection)
- v2.02.0_05 Update all records in exceptionManagementSettings to set default NAV level to TRADE_LEVEL
- v2.02.0_06 Add new vdkPrefix property to all records in companyLegalEntity
- v2.02.0_07 Add new index to portfolioItem to replace existing valuationDataKey index
All changes
SXSD-6930 | Entity Level NAV |
SXSD-7815 | See relevant MD in context to Overlay tasks to facilitate XM process for IR_INDEX & INFLATION |
SXSD-9668 | Highlight configurable view column groups with colour/border |
SXSD-9737 | ALL Market Data should be visible under the ALL tab in MD XM preliminary tasks |
SXSD-9793 | View All Market Data (Relevant + Non-Relevant) for Preliminary MD Clearing |
SXSD-9833 | MD/VD XM Make outcome available as an API |
SXSD-9868 | ZOHO 314: Ability to export VD & MD exceptions dashboard data to csv |
SXSD-9998 | Convert task-results-grid to a client side grid |
SXSD-10094 | Company/Entity/Portfolio related performance improvements (imports/usability) |
SXSD-10214 | Zoho #325: When navigating to a trade from a dashboard the back button should take a user back to the task |
SXSD-7796 | Make lock monitor page refresh automatically as locks change |
SXSD-8112 | Remove the “Resolution Scope” (Overall/Individual) selector control from the resolution UI in MD & VD XM tasks. |
SXSD-9204 | Extension: FXCollar Imports The Put strike should be equal to or lower than the Call strike |
SXSD-9518 | Only set up NULL tests to be run on P1 for Valuation Data Dashboard |
SXSD-9759 | Optimisation for MdExceptionManagementSetupResolver.applicableSettingsForLegalEntityIds |
SXSD-9760 | Optimisation for CurveConfigurationValuationsResolver.curveConfigsIdsByMarkedData |
SXSD-9787 | Checkboxes should be their own column across xplain and append if clicking in the column |
SXSD-9794 | The toggle for showing / hiding old dashboards should also include the attached tasks |
SXSD-9821 | Be able to filter and sort on Break test values within MD & VD XM tasks |
SXSD-9830 | Cashflows should export the display |
SXSD-9837 | CompanyPortfolioSettingsResolver.settingsStream performance optimisation |
SXSD-9846 | Regression: In a Preliminary MD XM sub-stream, I should be able to see data from all other providers |
SXSD-9874 | Add “Filter by” ag-grid action to MD VD XM task clearing grid |
SXSD-9899 | Introduce capability to the workflow engine to allow for automatically assigning underlying tasks |
SXSD-9941 | Add back end sorting by ExternalTradeID / Trade Type for Calculation Results |
SXSD-9949 | Rename “Curve / Valuation Date” for MD XM (+ Batch) and VD XM to “Curve Date” and “Valuation Date” respectively |
SXSD-9987 | Improve Outputs for MD Dashboard list and associated tasks |
SXSD-9988 | For EXCEPTION MNGT / MARKET DATA, add a column in the dashboard list stating if “Relevant data only” was applied |
SXSD-9989 | When creating a MD XM dashboard, rename “Relevant portfolios only” to “Relevant market data only” |
SXSD-9994 | Update tests after resolution scope removal and code cleanup |
SXSD-10027 | Enable sorting and filtering on all columns of the MD/VD Task Clearing Grid |
SXSD-10030 | Always show counts on buttons for filtered and selected rows |
SXSD-10034 | Add horizontal scrolling to XM task clearing grids as well as dragging |
SXSD-10123 | Add counts at the top of the company/entity/ portfolio list window |
SXSD-10151 | Update NonMtmPortfolioUploadService to work in bulk like PortfolioUploadService |
SXSD-10153 | Add new node types to DKK3M curve |
SXSD-10182 | Remove the expand / collapse from the Dashboard grid |
SXSD-10183 | The size of the stats window in XM tasks should not be dynamic |
SXSD-10186 | When switching view, it would make sense to remove the existing data from the FE while it’s re-loading |
SXSD-10256 | In Preferences / Valuations, rename “Discounting Settings per Trade Type” to “Index Mapping Rules for Discounting” |
SXSD-10268 | Break test definition forms should be reset |
SXSD-10275 | Optimise navigation to trade from task |
SXSD-8130 | Inflation conventions should be defined using One/One instead of 1/1 for better CSV export |
SXSD-9036 | OISOISXCCY nodes should reference the Offshore OIS index and not the Onshore index |
SXSD-9564 | The dashboard status should revert to In-progress if a user re-runs tasks |
SXSD-9630 | When the user filters by something, surrounding tables should update as soon as the main table updates. |
SXSD-9738 | It should be possible to open multiple tasks (Currently leads to a 400 Bad request - header too large) |
SXSD-9786 | XM tasks view should be filterable |
SXSD-9791 | CLP accrual rate calculations should be consistent with the way we calculate accrued |
SXSD-9796 | Dashboard should be marked completed when ProcessDoneEvent is received for top-level process |
SXSD-9894 | In a MD XM, if there is no preliminary breaks, the phase status should be set to “COMPLETED” and not “NOT STARTED” |
SXSD-9943 | Sorting/Filtering should work on dynamic ExternalId/Custom Field columns in calculation result table |
SXSD-10015 | Audit log date not formatted correctly when count column has value |
SXSD-10059 | Large MD dashboard creates Mongo document > 16Mb which gets rejected |
SXSD-10124 | ZOHO 231: It should be possible to not have to select a value in every field of the task-definition-grid-table |
SXSD-10134 | Removing Dashboard Admin permission should prevent update of Exception Management settings |
SXSD-10209 | We should show the correct projection curve in a calibrated curve configuration |
SXSD-10224 | Remove the Collapse/expand all button on the onboarding page |
SXSD-10247 | Refresh NAV table data on anchor date change |
SXSD-10257 | Fix the regression that allows navigation back to the dashboard from VD Tasks |
SXSD-10290 | Date filters should work in the Portfolio Trade List |
SXSD-10319 | Values count on VDG list should reflect settings |
SXSD-10395 | The tree-select component should only consider values from it’s own dropdown |
SXSD-10435 | It should be possible to view Valuation Data within a VDG when NAV data is present on Trade level |
SXSD-10438 | Clicking back on a trade after navigating from a dashboard should work for all trade types |