A Message to Our Esteemed Customers
Thursday 9th November 2017
We have released a new build as part of our continual product development cycle; BRSANALYTICS V2.8.1 is now available for installation.
Provided below is a list of new items available as product fixes and / or enhancements.
Please feel free to get in touch with one of our representatives to book an appointment to update your current setup. Updates typically take approximately 1.5 days per server 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 current setup once we receive confirmation of your request to upgrade.
Fixes and Enhancements in the Application:
|#1029||EOPI / FLWI||New End of Month process for Investments|
|#1031||BRS Toolbar||Minor Toolbar enhancements to ensure correct deployment of certain DLLs during installation
To disable interaction with Excel during publishing to reduce errors being encountered by users.
|Tool for Empty Sets||Internal creation of tool to extract empty sets from the UBPartner Taxonomy Packages|
|#1043||BRS Toolbar||Improvement in mechanism to safeguard situation where toolbar loses its database settings.|
|#1034||XBRL Java Updates||Improvement in Toolbar mechanism to support picking of Java update folder automatically.|
|#1050||Contractual Maturity Dates||Expansion of the number of dates in the Contractual Maturity Table to support assets with a maturity date of 100 years. This has been increased upto 31/12/2124|
|#1054||SQL Changes for FINREP Sector Groupings||UPDATE [BRSANALYTICS_DW].[dbo].[D_Sector]
SET [Group_7] = 'OFC'
WHERE Label LIKE 'B27%'
SET [Group_7] = 'GOVT'
WHERE (Label LIKE 'B1%') OR (Label LIKE 'B232%')
SET [Group_7] = 'CENTB'
WHERE (Label = 'A1')
SET [Group_7] = 'CRDIN'
WHERE (Label LIKE 'A21%')
SET [Group_7] = 'OFC'
WHERE (Label LIKE 'A22%')
SET [Group_7] = 'NFC'
WHERE (Label LIKE 'B231%')
SET [Group_7] = 'HOUSE'
WHERE (Label LIKE 'B24%')
SET [Group_7] = 'HOUSE'
WHERE (Label LIKE 'B26%')
|#1053||Business Rules||In the scenario when a business rule crashes e.g. on Process 15, the process has been improved to show this failure.|
|These were priorly automatically calculated fields however to improve flexibility these have changed to allow one to calculate these from the business rules and cater for different scenarios.|
|#1037||CurrencyTransaction CHF||Update in the way Switzerland is handled for CurrencyTransaction due to double counting in BR06
SET Group_3 = 'OTHERS'
WHERE Label = 'CHF'
|-||DCS Support||Additional functionality and Data Source Definition fields added to support the full process of DCS population of data.|
|#1040||DCS Anonimisation||Inclusion of Anonimisation function over the following fields: • Name • Surname • Entity Name • ID • Address 1,2,3 • Phone • Email|
|#1051||DCS Additional Fields||Following communications with the DCS team, an additional 2 fields have been added: ACCS.TempHighBalance and DCS.OtherDEF|
|#1049||DCS Validation Messages||When using the DCS functionality, for validation messages, the column names are now being used throughout.|
|#1048||DCS Validation Log||When using the DCS validation of templates, a more visual display is available to show on which level of validation the checks failed or passed.|
|#1047||DCS Automatic||DCS Submission process now supports a user to submit a non fully validation report if the user prefers.|
|#1030||Multiple EOP / FLW Files||Initial work to support multiple EOP / FLW files for clients with millions of EOP lines.|
|#1035||BRS Toolbar Convert to Pivot Table||For FINREP this would sometimes not work correctly due to the structure naming convention. Fixes in the approach to ensure conversion.|
Insert Pivot Table
|By Default, when a user inserts a new pivot table this will include the following defaults:
• Reporting Currency Filter
• Reporting Month Filter
• CoA Filter
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.1
Changes in Core Structure / Fixes in Formula Files:
|AS11||Change in measure to be Market Value instead of Balance|
|Flowloans||Row 26/27, 68/69 – Change in Convenience Indicator|
|BR06||Change in File Format to XLSB.|
|LD7||Addition of DCS variable in BRSANALYTICS sheet (for flexibility in using either CLTS.DCS or ACCS.DCS indicator)|
|F_4.04||Fix in Collective Impairment , Impaired Asset should be NO|
|Inclusion of Undrawn amounts in Loan Commitments and Liabilities > Deposits (Undrawn Amounts)|
|F_07.00||Fixes in Column 100 – removed Impaired Asset = YES|
|F_19.00||Fixes in Columns 060 and 010|
|F_09.01||Fixes in 010-080|
|FINREP||Change in File Format to XLSB|
|FINREP Part I & II||Change in Previous Period to be the start of the year|
|F0.01||Fix to tally Row39 with F04.04|
|AL8||Fix in Columns U to W, measure fixed from Limit to Undrawn|
|Flows2||Fix in AI 53, change from Liabilities to Assets|
|F_19.00||Update in Loan Commitments Given Row340|
|F_03.00||Fix in 010,100|
|F20_04||Fix in 030 to exclude credit risk FV change|
|F05.00||Fix in sheet to have GrossCarryingAmount – ImpairedProvision|
|F07.00||Fix in col 070 to have GrossCarryingAmount - ImpairedProvision|
|Flowloans||S27 – Removal of Accounts and Contracts from Extended Credit|
|Flows4||Fix in AL48 – from YES to OTHER|
|F_02.00||Split of Additions and Reversals such that reversals have a negative balance.|
|F_10.00||Row 300, 310, 320 added several IF ERROR change in placement (to be on the split sections) + Minor fixes.|
|FINREP||Part 1 now includes a ‘clean’ BRSANALYTICS sheet with only variables required for Part 1.
New Variables for the Sectors.
|F_04.03||Row 050 fixes due to change in sectors.|
|F_02.00||Row 420, *-1 correction.|
|F_16.07||Column 020, Row 145 *-1 correction.|
|F_01.01||Tweak in R280 to deduct the absolute value to cater for negative values.|
Changes in Documentation:
|DSD||Updates to Cater for DCS new fields|
|Toolbar User Guide||New Toolbar guide for DCS functionality|