A Message to Our Esteemed Customers

We have released a new build as part of our continual product development cycle; BRSANALYTICS V2.8.4 is now available for installation.

This release addresses critical work on the cube performance and we encourage all customers to update to this version (kindly refer to the relevant section below for further information)

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 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.TitleDescription
#1068Group EntitySubstantial internal changes to support Group Entities
#1069Change in SBSAPartyName has been removed from SBSA (so this will no longer update the CLTS Description)
-PartyTotalFurther tweaking in PartyTotal for RETAIL classification
#1071Count of AccountsIn order to improve processing time of the historical cube, the Count of Accounts has been limited to be calculated with the following dimensions:
• Industry
• CurrencyTransaction
• ValueType
• Party
• ValueBucket
• Sector
• Nationality
• Entity
• TenorTermToMaturity
• Time
• GLAccount
• BranchCode
• NewBusiness
• TenorContractualMaturity
• CurrencyReporting
• ValueBucketTotal
• NewBusinessInQuarter
• ZeroBalance
#1071Count of ClientsIn order to improve processing time of the historical cube, the Count of Clients has been limited to be calculated with the following dimensions:
• CurrencyTransaction
• Valuetype
• ValueBucket
• Sector
• Nationality
• Entity
• Time
• GLAccount
• BranchCode
• CurrencyReporting
• ValueBucketTotal
• ZeroBalance
-Collateral FlagIn order to improve processing time of the historical cube, the Count of Clients has been limited to be calculated with the following dimensions:
• CurrencyTransaction
• Valuetype
• ValueBucket
• Sector
• Nationality
• Entity
• Time
• GLAccount
• BranchCode
• CurrencyReporting
• ValueBucketTotal
• ZeroBalance
-New Business in QuarterTweaking in New Business in Quarter due to cube processing performance.

e.g. if you uploaded data for February and then re-upload new data for January, the new business in quarter indicator for February is not accurate as February data would need to be re-uploaded.
#1072Group ConsolidationTo add a separate process 'Group Consolidation' when uploading the Group transactions. New file naming convention EOPGYYYYMMDD
#1073Publishing EnhancementDepending on brEntity being used when publishing FINREP, if a subsidiary is selected (i.e. not ALL) then the LEI from the Entity database is selected. Otherwise the default Entity is selected from the Settings table.
#1070ACCS Impairment ClassificationThe default should be ‘NONE’ rather than ‘NO’
#1074Days Past Due GroupIf the account is not in the ACCS file, the 'Days Past Due Group' is not being defaulted to 'NONE' but to blank
#1076ToolbarISOCodesInclusion of GABON (GA) as per latest UBPartner templates for 2018 Q1
#1078
#1079		BRSPublishingUpdate in ToolbarISOCodes split to include F_20.07.1 and fix in the BRSPublishing sheet in FINREP Part II
#1077Nationality UpdateUpdate in Nationality table, Group4 to pick up ‘Other Countries’ x28
-DCS UpdatedUpdate in Schema and Files:

Depositor Details
• IdentityCountryOfIssue: changed from 3 to 2 characters
• IdentityNumber: changed to mandatory

Contact Details
• Country: changed from 3 to 2 characters
• MainPhone: changed from 12 to 50 characters
• AlternatePhone: changed from 12 to 50 characters

Deposit Details
• DepositCategory: changed to mandatory
• ExchangeRate: changed to not mandatory
• EURPledgedAmount: added
• OTH: removed
• THB: removed
#1080SBSAFix in SBSA due to issue when uploading following tweaking in platform
#1075Collateralised AmountReview in calculation due to certain scenarios when this resulted in div by zero error
#1074Days Past Due GroupIf the account was not in the ACCS file, the 'Days Past Due Group' was not being defaulted to 'NONE' but to blank

Changes in Core Structure / Fixes in Formula Files:

INC No.StructureDescription
BR06Inclusion of IFRS9 instruments
FINREPInclusion of IFRS9 instruments
INC No.ScheduleDescription
#1068AllChanges in all formulas to include brEntity
Inclusion of variable brSRB – EOPB.ResidencyStatus inclusion of SRB
brSPE and EOPB.ResidencyStatus SPE has been retained for Captives (resident_2)

- Check that no SPE + NFC combination (as this is not reportable in the schedules)
AL2brSRB for row 263, Inclusion of formulas where required
AChange in formulas due to removal of AFS/HTM/HFT row 4.2.1 / 4.2.2 / 4.2.3
Row 2.4 / 3.4.1 / 3.4.2 / 5.2
AS5All formulas affected to read from Amortised Cost CoA rather than HTM
AS6All formulas affected to read from FVOCI CoA rather than AFS
AS8All formulas affected to read from AMC / FVOCI rather than HTM/AFS
LD4brSRB for row 263, Inclusion of formulas where required
PLChanges to the following formulas:
4.1.6 FVOCI
4.1.7 AMC
4.3.1 AMC
4.3.5 FVOCI
5.4.2 AMC
5.4.3 FVOCI
6.1.3.3 AMC
6.1.3.4 FVOCI Debt Instruments
6.1.3.5 FVOCI Equity Instruments
6.2.3.2 AMC
6.2.3.3 FVOCI Debt Instruments
6.2.3.4 FVOCI Equity Instruments
PLMemo 2.3 – Error in formula causing #N/A
8.2 AMC
8.3 FVOCI
10.3 FVOCI
FINREPNew Packs due to new Chart of Accounts – New formulas throughout
F_05.01
F_07.01		ACCS.ProjectFinanceLoan use
FINREPRenaming of Sector variables (removal of REM_ naming convention which was only required for BR06)
FINREPRemoving of Collateralised Flag as this was not required
FINREPInclusion of all formulas to include brEntity
FINREPRemoval of brVersion
F_07.01Tweaking of Formula row 280
FINREPFix in brPreviousPeriod for automatic calculation
FINREP IIAddition of GABON as per latest dropdown

Changes in Documentation:

DocumentDescription
DSDEOPB.ResidencyStatus inclusion of SRB
DSDAddition of EOPG – Group Consolidation