A Message to Our Esteemed Customers
Tuesday 4th April 2017
We have released a new build as part of our continual product development cycle; BRSANALYTICS V2.8.0 is now available for installation.
Provided below is a list of new items available as product fixes and / or enhancements.
Let us know should you wish to book an update appointment on your current setup which depending on your current version normally takes approximately 1.5 day per server including a health check. Kindly advise should you be interested and we’ll revert with a more exact time-frame based on your setup.
Fixes and Enhancements in the Application:
| INC No | Ttitle | Description |
|---|---|---|
| - | SQL2012 Application changeover | Conversion and complete upgrade of the BRSANALYTICS application to work solely on SQL2012. |
| #1013 | Total Account Opening in Flows | The total balance on the opening month is not being correctly linked to the flows record, if the TCM (or a reclassification dimension) changes from one month to the other |
| - | Flows File | Enhancement in shifting of Price and True Movement from Opening to Closing line as required for correct reporting |
| #1016 | Exposure Value Adjustment | Some of the values for ExposureValueAdjustment were not copied over to the CRD Table correctly |
| #1020 | Toolbar Changes | Inclusion of XBRL Conversion functionality in BRSANALYTICS Toolbar and change in some icons accordingly. |
 |
||
| #1020 | XBRL Toolbar Enhancements | • Automatically loading Validation sheet • Displaying automatic progress in Toolbar • HTML displaying of Error Log if process fails |
| #1025 | XBRL Toolbar Enhancement | Addition of the following features: • Validation without Rendering the Error • Stopping the Process • View Logs folder • View Results folder • View taxonomies folder |
| #1017 | Enhancement in Publishing to Folder | With the latest update In the BRSANALYTICS toolbar, the INFO sheet is automatically populated with the : • Entity Name (This is updated from Administration Tab > Configure System Parameters > XBRL Publish Entity • Start Date : This is based on the Previous Period parameter in the BRSANALYTICS sheet of reporting packs provided • End Date : this is the Reporting Period in the BRSANALYTICS sheet This is to be updated during Deployment Configuration |
| #1022 | Access to Credit Risk Module | Access to Credit Risk Module is now only available to Administrators only |
| #1024 | CRD – Accrued Interest | For customers who provide accrued interest in the column, this creates a problem for CRD as accrued interest needs to be assigned to a particular Exposure Class. Therefore this is extracted and places as a CRD Balance (with Measure Type CRD_INT) and is split by GL and Currency |
| #1011 | Maintenance in Measure Type Table | Removal of old measure types from previous BRS v1 structure. |
| #1021 | CLTS.RatingShort | Inclusion of another Clients Rating field specifically for Short Ratings for COREP licenced customers. Also accessible for the CRD UI and Pivots. |
| #1026 | XBRL Toolbar – Standalone Version | Creation of a toolbar version that is standalone without the BRS Banking functionality for none BRSANALYTICS Customers |
 |
||
| #1023 | ExposureValueAdjustment in CRD Table | Allocation of ExposureValue Adjustment (Impairment) needs to be split according to class ranking. An Exposure Class ranking mechanism has now been included. |
| #1023 | Change in CRD Execution | Change from previous Execution of 1. Exposure Value, 2. Exposure Class to instead 0. Initialisation 1. Exposure Class 2. Exposure Value |
Apart from a BRS Application Update, in order to benefit from all the above enhancements, clients should install the latest version of the BRS Toolbar V2.8.0
Changes in Core Structure / Fixes in Formula Files:
| INC No. | Structure | Description |
|---|---|---|
| FINREP | Additions in P&L Structure due to latest MFSA taxonomy package |
| INC No. | Schedule | Description |
|---|---|---|
| Flows3 | R59 – Removal of TransactionalCurrencyEURO | |
| Flows4 | R59 – Removal of TransactionalCurrencyEURO | |
| #1015 | AL2 LD4 | Fix in column CA to use BZ in the first month after End of Financial Year |
| #1015 | BRSANALYTICS | New Variable isPreviousMonthYearEnd |
| FlowLoans | Row 26, 27, 68 & 69 (Convenience & Extended Credit) Row 63 Column J, K, AG, AH & AI (Bug fix) Row 19 Column J, K & L Row 20 Column J, K & L Row 21 Column J, K & L Row 61 Column AS, AT, AU & AV Row 62 Column AS, AT, AU & AV Row 63 Column AS, AT, AU & AV Row 66 Column AS, AT, AU & AV Row 71 |
|
| Flows4 | Row 102 Column R Row 75 Column R, AJ & AL (Bug fix in total remove Sector) Row 76 Column R, AJ & AL (Bug fix in total remove Sector) Row 78 Column R, AJ & AL (Bug fix in total remove Sector) Row 80 Column R, AJ & AL (Bug fix in total remove Sector) Row 81 Column R, AJ & AL (Bug fix in total remove Sector) Row 83 Column R, AJ & AL (Bug fix in total remove Sector) Row 85 Column R, AJ & AL (Bug fix in total remove Sector) Row 86 Column R, AJ & AL (Bug fix in total remove Sector) Row 88 Column R, AJ & AL (Bug fix in total remove Sector) |
|
| Flows 1 | Row 97 Row 100 Row 75 Column R, AJ & AL (Bug fix in total remove Sector) Row 76 Column R, AJ & AL (Bug fix in total remove Sector) Row 78 Column R, AJ & AL (Bug fix in total remove Sector) Row 80 Column R, AJ & AL (Bug fix in total remove Sector) Row 81 Column R, AJ & AL (Bug fix in total remove Sector) Row 83 Column R, AJ & AL (Bug fix in total remove Sector) Row 85 Column R, AJ & AL (Bug fix in total remove Sector) Row 86 Column R, AJ & AL (Bug fix in total remove Sector) Row 88 Column R, AJ & AL (Bug fix in total remove Sector) |
|
| Flows3 | Row 102 | |
| F_2.00 | Change in Structure and shifting in formulas due to new datapoints 085 and 145 | |
| F_16.01 | Additional Formulas in data row 150 and 260 | |
| F_18.00 F_19.00 | Shifting in formulas due to changes in templates | |
| F16.07 | Addition of Formulas in datapoint row 150 | |
| BRSANALYTICS | Fix in P&L SubCategory check, auto-calculation had been removed | |
| FlowDeposits | Row 217 Column AW Bug in Formula Row 192 Column AW Bug in Formula |
|
| AL2/LD4 | Column CA and Column CB Interest Accrued Add condition for Interest Apportioning (Will effect only those clients who have P&L Interest Apportioning set to YES) |
|
| PL | Memo Items Interest Payable & Interest Receivable Row 438 – Row 465 Added condition for Interest Apportioning (Will effect only those clients who have P&L Interest Apportioning set to YES) |
|
| MIR2 | Fixes in Sections 4.3, 4.4, 4.5 to exclude Revolving Loans | |
| Flowloans | Row23, BB:BE – Change from Loans to CUBESET(Loans,Deposits) Row24 (all were applicable) - Change from Loans to CUBESET(Loans,Deposits) |
|
| FlowDeposits | Row 165 Column AT, AV & AW Row 21 Column AT |