A Message to Our Esteemed Customers
We have released a new build as part of our continual product development cycle; BRSANALYTICS V2.8.7 is now available for installation.
This release addresses critical work on facilities package and AnaCredit product development.
Provided below is a list of new items available as product fixes and / or enhancements.
Please get in touch with one of our representatives to book an appointment to update your current setup. Updates typically take around 2 days per server to complete (including a health-check) depending on the setup you are currently running on.
We will revert with a more exact time-frame based on your present setup once we receive confirmation of your request to upgrade.
Fixes and Enhancements in the Application:
| INC No. | Title | Description |
|---|---|---|
| #1135 | FACS Time Dependency | The facility dimension was converted to work with Time_MemberID rather than date range (similar to the prior work on ACCS and CLTS) |
| #1141 | CLTS File – time for processing | It was identified that in some scenarios the CLTS file was taking a long time to process. An enhancement has resolved this. |
| - | • Addition of new templates in line with Phase 2 • Changes to dropdowns to be named ranges rather than ranged • Change in Country and County text to use ISO to match BRS standards • Change in Sector / Subsector to match BRS sector description Text • Addition of Regex for IDENTTYPE • Change in LegalForm dropdown to use codes • Changes in dropdown text for the following: Counterparty Identifier, Accounts Standard (Formula now in place and part of configuration), Legal Status and Counterparty roles |
|
| #1150 | AnaCredit Fields Licensing | Adding of the following fields from FINREP to both FINREP and AnaCredit • EOPB.CreditRiskFVChange FCY/LCY • ACCS.DatePastDue • EOPB.AccumulatedWriteOffs FCY/LCY |
| #1152 | SQL Scripts | Addition to A_NationalityResidency ‘RMS’ addition to Nationality.Residency for AnaCredit reporting (including MT) |
| #1126 | Toolbar using Web Services | When using Web Services, it was identified that upon loading Excel for the first time, there was a significant delay. This has been rectified. |
| #1159 | AnaCredit Legal Forms | Update in AnaCredit template to include latest Legal Forms as per CBM email 20180806 |
| #1154 #1151 #1156 | AnaCredit Conversion | Resolution of issues related to conversion of Counterparty data |
| #1146 | AnaCredit Fact Label | Consideration that HEADOFFICE / IMMEDIATEPARENT / ULTIMATEPARENT would be referenced by the AnaCredit Identifier rather than the Party Code. |
| #1148 #1153 #1097 | Loading Counterparty data | Resolution of issues related to Automatically Loading Counterparty data in the following sheets: • COUNTERPARTY RESIDENT • COUNTERPARTY NON RESIDENT |
| #1128 #1165 | AnaCredit Convert values to NOT REQUIRED | It may be the case that a bank provides more data than is required in NOT REQUIRED scenarios. For this the AnaCredit conversion toolbar offers a functionality to ignore the |
| #1134 | AnaCredit ACCS Fields | Inclusion of DSD fields in ACCS for ObservedAgent, Creditor, Servicer and Originator |
| #1145 | AnaCredit Loading | Including of logic to calculate Credit Attributes related to: • Observed Agent not Resident in Member State • Fully derecognised Instruments being serviced • Intracompany Loans • Instruments Originating Prior to 1 Sept 2018 • Fully derecognised Instruments not being serviced |
| #1149 | AnaCredit Observed Agent | If the Observed Agent is not specified in the ACCS, this is defaulted to the Reporting Agent (matching on the LEI code) |
| #1158 | AnaCredit Servicer | If the Servicer is not provided, then this should be the same like the Creditor |
| #1143 | AnaCredit XML Generation | Inclusion of new cube field “CMT1M_COMMENT” as per Data Dictionary updated on 20th July 2018 by CBM. |
| #1164 | AnaCredit JointCustomers | Anacredit supports JointCustomers by the use of ACCS.JointCustomers |
| #1163 | AnaCredit Templates | Automatic loading of AnaCredit related data: • JOINT LIABILITY • COUNTERPARTY INSTRUMENT DATA • COUNTERPARTY RISK |
| #1162 | Business Register | Fix in Business Register import process |
| #1127 | AnaCredit Update in mandatory fields | As AnaCredit conversion checks mandatory values, the system was updated as per CBM email 16th May |
| #113 | EODC.CollateralAmountOriginal | Inclusion of a new collateral field, Collateral Amount Original |
| #1144 | Credit Attributes | As part of the AnaCredit data load, calculation of the Credit attributes as specified in the data dictionary updated 20th July 2018 |
| #1168 | AnaCredit Reporting in Full | As per CBM email 22/08, the following AnaCredit tables are to be sent in full CMT1M and CMT2M. Code related to checking of previous month submitted data has been removed for the time being. |
| #1132 #1167 | AnaCredit Loading Data | Loading of AnaCredit based on the following parameters: • Mapped with the AnaCredit CoA • Check Balance + Committed Facilities > 25K • If valuetype LIABILITY consider the balance as zero but pick up the Undrawn Amount In template FINANCIAL to pick up Balance for ASSET but if valuetype LIABILITY to set balance as zero and Off balance sheet amount equal to the undrawn committed amount. If OFF BALANCE SHEET valuetype, then to also set balance as 0 but off balance sheet amount set to the balance of the off balance sheet item. |
| #1012 | Removal of BRS redundant tables | Removal of various SQL tables which have become redundant over the years. |
| #1147 | Renaming of cube field related to FINREP | From [EconomicIndustries] to [Economy Industry] |
| #1166 | AnaCredit Accounting Template | CoA (For Accounting Classification) outputted as Uppercase as CoA is in lower case |
| #1173 #1174 | AnaCredit Template and Update in Product Database | Update of National Identifiers codes and RegEx in AnaCredit Template as per CBM email 20180829 and update in product database to include CY_CBCID_CD, CY_OTHER, FR_IF_CD as Identification types. |
| #1171 | AnaCredit Load Data | Fix in the following fields to display NONE when importing • DT_NXT_INTRST_RT_RST • DT_END_INTRST_ONLY • DT_LGL_FNL_MTRTY |
| #1172 | Fix in AnaCredit XML conversion | Fixes in the JOINT LIABILITY template conversion |
| #1176 | DCS XML Conversion | Update in XSD |
| #1169 #1170 | AnaCredit Load data for Risk and Default Templates | Some duplicate entries were present as there was no filter on DEBTOR and PROTECTION PROVIDER |
| #1131 | AnaCredit Reportable Indicator | Inclusion of a reportable column on each AnaCredit Sheet. By default this is set to AUTO for all records where users can manually set to YES or NO Row will be included in XML conversion if Reportable = YES or AUTO and Full Data is to be reported for the schedule OR Updates only are to be reported for the sheet where there was a change in the record (or no previous record found) |
| #936 | BRSANALYTICS Toolbar – Database settings | Previously, each time the toolbar is re-installed, the settings were lost. These are now saved and in subsequent re-installations will be retained. |
Changes in Core Structure / Fixes in Formula Files:
| INC No. | Structure | Description |
|---|---|---|
| AnaCredit | New CoA Structure created |
| Flows2 | Cell AL48, Addition of brSectorREM_NONMMF | |
|---|---|---|
| Flows3 | Cell BB58, Removal of ‘Items in Transit’ and ‘Suspense’ as these are not part of Other Unallocated Assets. | |
| LD5 | Cells E30:E40 and Cells H30:H40, Addition of brZeroBalanceFalse and addition of CoA items with measure brM_NoA_Adjusted | |
| F_18.00 | F18.00a (c200) and F18.00c (c210) change from CollateralAmount to Collateralised Amount on Carrying Amount | |
| LC | Change from Reporting Currency to Base Currency | |
| LD4 | Cell AY261, removed CBM formula | |
| AL10 | Fixes in the following to include both Balance and Undrawn Amount: Section 1.2 , 1.4, 2, Memo Items |
|
| PL | 1.5.1.3 and 1.5.2.3 addition of Interest Receivable on Deposits | |
| BRSANALYTICS | Variables for [Measures].[Interest LCY Closing] and [Measures].[Interest LCY Opening] Fixes in Flows1: R97 / AJ97 / AL97 / R100 / AJ100 / AL100 to use the above measures |
|
| Flows1 | Fixes in Flows1: R97 / AJ97 / AL97 / R100 / AJ100 / AL100 to use brM_ExMAI | |
| AL2 LD4 | Column CB, fix in formulas to include variable to check if to use the AccruedInterestGLs or the AI in the Loan / Deposit lines. | |
| F_20.04 | Fix in cell J20 to include *-1 (for TOT and all nationality sheets incl. x28) | |
| F_31.01 | Row 010 was incorrectly picking up non-performing. Summation now from row 020 to 040 | |
| F_05.01 | Cell H8, fix from GrossCarryingAmount to CarryingAmount | |
| F_18.00b | Row 420 to 540. Removal of *-1 as all these values should be positive as per EBA Validation v5708s | |
| F_31.02 | Removal of ABS in formula in the following cells: D6 F6 G6 D8 F8 G8 D9 F9 G9 |
|
| F_31.02 | Addition of ABS to remove the negative values (due to validation rule 3975s) C7 E7 C10 E10 F10 G10 |
|
| F_09.01.1 | Fix in columns 010 – 020 – 030 These are being compared to GrossCarrying amount in F_18.00a so the column measure was fixed accordingly. (In line with validation rules 2788m, 2793m, 2795m, 2798m, 2799m, 2800m, 3020m) |
|
| F_18.00a | Rows 340-400 changed to GrossCarryingAmount rather than CarryingAmount | |
| F_06.01 F_20.07.1 | Change in Economic Industry text formatting from “[EconomicIndustries]” to “[Economic Industry]” to be in line with other cube fields | |
| FINREP BRSANALYTICS | Affecting all pack, changing of Previous Period to match End of Year Period (which the last days prior to the start of the new period). This affects the publishing Start date in the INFO sheet. |
Changes in Documentation:
| Document | Description |
|---|---|
| DSD | ACCS updates in fields CLTS minor change in text of Legal Status EODC addition of new field ACCS.ActivityType and EOPB.ActivityType data accepted in field renamed to CENTRAL ADMIN. SERV. FOR COLLECTIVE INVESTMENT due to limitation in field length |
| AnaCredit | New AnaCredit user guide |