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 NoTtitleDescription
-SQL2012 Application changeoverConversion and complete upgrade of the BRSANALYTICS application to work solely on SQL2012.
#1013Total Account Opening in FlowsThe 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 FileEnhancement in shifting of Price and True Movement from Opening to Closing line as required for correct reporting
#1016Exposure Value AdjustmentSome of the values for ExposureValueAdjustment were not copied over to the CRD Table correctly
#1020Toolbar ChangesInclusion of XBRL Conversion functionality in BRSANALYTICS Toolbar and change in some icons accordingly.
#1020XBRL Toolbar Enhancements• Automatically loading Validation sheet
• Displaying automatic progress in Toolbar
• HTML displaying of Error Log if process fails
#1025XBRL Toolbar EnhancementAddition of the following features:
• Validation without Rendering the Error
• Stopping the Process
• View Logs folder
• View Results folder
• View taxonomies folder
#1017Enhancement in Publishing to FolderWith 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
#1022Access to Credit Risk ModuleAccess to Credit Risk Module is now only available to Administrators only
#1024CRD – Accrued InterestFor 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
#1011Maintenance in Measure Type TableRemoval of old measure types from previous BRS v1 structure.
#1021CLTS.RatingShortInclusion of another Clients Rating field specifically for Short Ratings for COREP licenced customers.

Also accessible for the CRD UI and Pivots.
#1026XBRL Toolbar – Standalone VersionCreation of a toolbar version that is standalone without the BRS Banking functionality for none BRSANALYTICS Customers
#1023ExposureValueAdjustment in CRD TableAllocation of ExposureValue Adjustment (Impairment) needs to be split according to class ranking.
An Exposure Class ranking mechanism has now been included.
#1023Change in CRD ExecutionChange 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.StructureDescription
FINREPAdditions in P&L Structure due to latest MFSA taxonomy package
INC No.ScheduleDescription
Flows3R59 – Removal of TransactionalCurrencyEURO
Flows4R59 – Removal of TransactionalCurrencyEURO
#1015AL2
LD4
Fix in column CA to use BZ in the first month after End of Financial Year
#1015BRSANALYTICSNew Variable isPreviousMonthYearEnd
FlowLoansRow 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
Flows4Row 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 1Row 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)
Flows3Row 102
F_2.00Change in Structure and shifting in formulas due to new datapoints 085 and 145
F_16.01Additional Formulas in data row 150 and 260
F_18.00
F_19.00
Shifting in formulas due to changes in templates
F16.07Addition of Formulas in datapoint row 150
BRSANALYTICSFix in P&L SubCategory check, auto-calculation had been removed
FlowDepositsRow 217 Column AW Bug in Formula
Row 192 Column AW Bug in Formula
AL2/LD4Column 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)
PLMemo 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)
MIR2Fixes in Sections 4.3, 4.4, 4.5 to exclude Revolving Loans
FlowloansRow23, BB:BE – Change from Loans to CUBESET(Loans,Deposits)
Row24 (all were applicable) - Change from Loans to CUBESET(Loans,Deposits)
FlowDepositsRow 165 Column AT, AV & AW
Row 21 Column AT