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 No | Title | Description |
---|---|---|
#972 | Facility Undrawn Amount | Fix in the Undrawn Amount in the FACS which was sometimes was not being refreshed correctly. |
#917 | Flows – Column Exchange Reval LCY | Setting of the column as an optional for clients who’s base rate is EUR |
#907 | EOPB – Column ProductType | Validation for column when client’s license is FINREP and not Core. |
#909 | EOPB – New Field APRC | Inclusion of a new column APRC in EOPB as part of core license |
#915 | Flows Data Source | Performance improvements on the flows data source |
- | EOPB.RelatedParty | Fix in auto Retrieval from CLTS |
#914 | Reclassifications | Issue when multiple dimensions change e.g. ResidencyStatus. This should not disallow reclassifications from being calculated |
#918 | Flows Reclassification change in Logic | Change 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 |
#916 | Flows on EOPF | Issue on calculated FLOWF - Resolved |
#911 | Reclassification Convenience Marker | Reclassification of Convenience Marker, similar to Sector / Nationality / Industry / TCM. To pull Convenience from on ACCS file in flows data sources, and to reclassify accordingly. |
#913 | TransactionDate in Flows | Removal of column from file as this was not being used by ETL. |
#883 | Preparation for LD7 changes in Joint Customers | New 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. | Structure | Description |
---|---|---|
BR06 | Addition 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 |
|
BR06 | Change 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 |
|
BR06 | Change 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. | Schedule | Description |
---|---|---|
- | LD2 | Removal of Repos from Loans due to Double Counting |
- | LD3 | Change in Columns E and F to have sector Banks instead of CREDIT_INST |
LR | Addition 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 |
|
L | Item 7.2 Addition of [Remaining Liabilities].[Interest accrued and unpaid other than deposits].[Debt securities] | |
Flows1 | Item 7.2 Addition of [Remaining Liabilities].[Interest accrued and unpaid other than deposits].[Debt securities] | |
L | Addition of Reclassification measure throughout Change from BT to Reclass in Cash |
|
Variable | Removal of Memo Items 5.1 to 5.3 as their categorisation is very client specific | |
AL1 | Change in brFlag_Reclass to use new Measure related to Reclassification | |
AS5 | Row 144- Incorrect Sector – changed to brSectorREM_NONMMF | |
AS5 | Section 2.2 – Nationality MALTA (some had MUMROW) | |
AS5 | Fix in 2.2 and 4.2 – Deducting from brSECTORGOVERNMENT instead of brSectorGOVTGEN | |
F_10.00 | rows 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 | |
AS5 | Fix in OTC Other formula row 320 (remaining rows) Change in sector from brSectorGOVTGEN to brSectorGOVERNMENT |
|
LD5 | Change in section 2 from OMFI to MFI | |
AL1 | Fix in 1.1.1.4 EURO as this was resulting in #VALUE | |
F_10.00 | Economic Hedges Formulas, made to use ACCS.EconomicHedges (instead of ProductType) | |
PL | Fix 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 |
|
PL | Change 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 |
|
LC | Change in 2.10.4 due to change in Structure | |
F_10.00 | Change in Column for Nominal Value *1000 for each value Minor tweak in Cells I39 and F39 |