A Message to Our Esteemed Customers

Monday 20th June 2016

As part of our continual product development cycles, we have just released a new build and BRSANALYTICS V2.7.2 is now available for installation.

Provided below is a list of new items available as product fixes and / or enhancements.

Please 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 to 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 NoTitleDescription
#972Facility Undrawn AmountFix in the Undrawn Amount in the FACS which was sometimes was not being refreshed correctly.
#917Flows – Column Exchange Reval LCYSetting of the column as an optional for clients who’s base rate is EUR
#907EOPB – Column ProductTypeValidation for column when client’s license is FINREP and not Core.
#909EOPB – New Field APRCInclusion of a new column APRC in EOPB as part of core license
#915Flows Data SourcePerformance improvements on the flows data source
-EOPB.RelatedParty Fix in auto Retrieval from CLTS
#914ReclassificationsIssue when multiple dimensions change e.g. ResidencyStatus.
This should not disallow reclassifications from being calculated
#918Flows Reclassification change in LogicChange in Logic for reclassification calculations:

Reclassifications on CALCULATED FLOWS:
Internally to remove: To Remove the following fields from Flows:
Rating, Exposure Nationality, Exposure Party as these are not required

• On change of ANY dimension, keep splitting of flows on two rows (previous month vs current month), as per old logic
• If reclassification flag is enabled, populate the reclassification measure on the movement records
• For calculated flows (i.e. not file), then deduct the reclassification measure from the movement

To add a new dimension called Reclassification Type, which points to the Measure Type table. This will flag on which dimension reclassification has occurred:
E.g:
RECF_I Industry
RECF_IN Industry + Nationality
RECF_N Nationality
RECF_S Sector
RECF_SI Sector + Industry
RECF_SIN Sector + Industry + Nationality
RECF_SN Sector + Nationality
RECF_T TCM
RECF_C Convenience
(Makes use of the new dimension)


As per incident #911, reclassification is to consider Sector, Nationality, TCM and Industry, as well as ACCS.Convenience


Reclassifications on FLOW FILE:
As per calculated
NOTE: If the GL or VALUETYPE is changed from one month to the other, no Reclassification is calculated, otherwise this would require a change in the Movement value in order to match with the regulation’s formula of:

Ft = (St-St-1) - Ct - Vt – Et

Where Ft = Flow
St = Stock end of period
St-1 = Stock end of previous period
Ct = Reclassification adjustment
Vt = Revaluation adjustment
Et = Exchange Rate adjustment
#916Flows on EOPFIssue on calculated FLOWF - Resolved
#911Reclassification Convenience MarkerReclassification of Convenience Marker, similar to Sector / Nationality / Industry / TCM. To pull Convenience from on ACCS file in flows data sources, and to reclassify accordingly.
#913TransactionDate in FlowsRemoval of column from file as this was not being used by ETL.
#883Preparation for LD7 changes in Joint CustomersNew functionality to assist customers in filling in LD7 related to JointCustomers. The product file currently remains as is for the time being.

New field JointCustomers added to the ACCS file. Optional, length 250, default NONE. This will include all the Joint Customers (comma delimited) including the main account holder.

A new package is required which will go through the number of joint account holders and apportion the data in EOPB accordingly by dividing the number equally between the account holders, saving it in a new fact. Only Liabilities for EOPB need to be picked in the DCS logic. The package does not require any file. The fact will have the following columns:
ProcessID
Time_MemberID
AccountProduct
GLAccount
CurrencyReporting
CurrencyTransaction
Nationality (Update from CLTS)
Sector (Update from CLTS)
ValueType
ValueBucket (To be recalc based on apportioned balance)
Party
Entity
Version
MeasureType (set to DCS)
Balance
AccruedInterest

Changes in BRSCoreStructure / FINREPCoreStructure

INC No.StructureDescription
BR06Addition as follows:

Remaining Liabilities > Int. accrued and unpaid other than deposits
Remaining Liabilities > Int. accrued and unpaid other than deposits > Debt Securities
Remaining Liabilities > Int. accrued and unpaid other than deposits > Others
BR06Change in PL Structure

Remapping required of the following as child elements of HTM/HFT/AFS/FVTPL:
P0101050100 Interest Receivable on Securities other than shares Treasury Bills
P0101050200 Interest Receivable on Securities other than shares Other Gov
BR06Change in PL Structure:

Remapping required of :
P0201020100 Trading gain/(loss) on foreign exchange dealings
 P0103030600 (as this is a Non-Trading Profit)
"[Chart of Accounts].[CoA].[All].[BRS CoA].[Profit and Loss].[Trading Profits].[Non-Interest Income].[Other non-interest income].[Trading gain on FX]" changed to "[Chart of Accounts].[CoA].[All].[BRS CoA].[Profit and Loss].[Non-Trading Profits].[Non-Interest Income].[Other non-interest income].[Trading gain on FX]"

P0201020200 Other foreign exchange gain/(loss)
 P0103030700 (as this is also a Non-Trading Profit)
Changed from "[Chart of Accounts].[CoA].[All].[BRS CoA].[Profit and Loss].[Trading Profits].[Non-Interest Income].[Other non-interest income].[other fx gains]” to "[Chart of Accounts].[CoA].[All].[BRS CoA].[Profit and Loss].[Non-Trading Profits].[Non-Interest Income].[Other non-interest income].[Other FX gains]"

Changes in BR06 / FINREP Formula File

INC No.ScheduleDescription
-LD2Removal of Repos from Loans due to Double Counting
-LD3Change in Columns E and F to have sector Banks instead of CREDIT_INST
LRAddition of [Remaining Liabilities].[Interest accrued and unpaid other than deposits].[Debt securities] in Section 2.1 and 2.1.1

Addition of Remaining Liabilities].[Interest accrued and unpaid other than deposits]– Item 1.3
LItem 7.2 Addition of [Remaining Liabilities].[Interest accrued and unpaid other than deposits].[Debt securities]
Flows1Item 7.2 Addition of [Remaining Liabilities].[Interest accrued and unpaid other than deposits].[Debt securities]
LAddition of Reclassification measure throughout
Change from BT to Reclass in Cash
VariableRemoval of Memo Items 5.1 to 5.3 as their categorisation is very client specific
AL1Change in brFlag_Reclass to use new Measure related to Reclassification
AS5Row 144- Incorrect Sector – changed to brSectorREM_NONMMF
AS5Section 2.2 – Nationality MALTA (some had MUMROW)
AS5Fix in 2.2 and 4.2 – Deducting from brSECTORGOVERNMENT instead of brSectorGOVTGEN
F_10.00rows 56-60: when deducting T-Bills, for Chart of account, a higher level is required (i.e. "[Chart of Accounts].[CoA].[All].[BRS COA].[ASSETS].[SECURITIES OTHER THAN SHARES].[HELD TO MATURITY].[ HTM_Treasury Bills]") In 4.2.1 , 4.2.3 and 4.2.4 in the deductions within the brackets I changed the – to + as the deduction is in one whole bracket otherwise it would had ended up adding
AS5Fix in OTC Other formula row 320
(remaining rows) Change in sector from brSectorGOVTGEN to brSectorGOVERNMENT
LD5Change in section 2 from OMFI to MFI
AL1Fix in 1.1.1.4 EURO as this was resulting in #VALUE
F_10.00Economic Hedges Formulas, made to use ACCS.EconomicHedges (instead of ProductType)
PLFix in 1.4.2.2 to match 1.4.1.2
Fix in 6.2.1.3,6.2.2.3 – Removal of *-1
Fix in 6.2.2.2, 6.2.1.2 – Inclusion of *-1
Fix in 6.1.2.1 – Inclusion of a deduction
PLChange in 1.4.1.1, 1.4.2.1 due to change in Structure

Change in 4.4.2, 4.4.4 and Memo Item 6.5 due to Change in Structure
LCChange in 2.10.4 due to change in Structure
F_10.00Change in Column for Nominal Value *1000 for each value
Minor tweak in Cells I39 and F39