A Message to Our Esteemed Customers
Thursday 17th November 2016
By way of an update regarding ongoing releases, new enhancements and bug fixes in the product, we shall be providing regular notices on new releases as they are made available.
BRSANALYTICS V2.7.1 is now here. 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 day per server including a health check. Please 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 |
---|---|---|
#937 | Payments Sector Mappings | Sectors in Payments file were always mapping to NONE |
#934 | Minor issue in flows Warning ‘RECF_TT’ | With certain file / flows calculation, an error “Flows are throwing an RECF TT warning. TT is not a valid reclassification type” was being displayed. |
#931 | Issue with XLSM Macro for CoAs | Fixed in latest macro files. This is related to the version of windows being used. Solution is to edit Macro References by removing Microsoft XML v6 and adding a reference to c:\windows\system32\msxml3.dll |
#953 | Exposing of Fields in Pivot | Following Fields exposed: CLTS.Sector CLTS.Nationality CLTS.Industry |
#941 #942 #954 #952 | ExposureClass | Various Scripts for ExposureClass |
#949 | Clients new Field CustomerType | new field CustomerType to accept text (mostly for text ENTITY / INDIVIDUAL) Accessible from CRD UI for ExposureClass Classification |
#947 #948 | Bonds File | (1) Hardcoding to LIABILITY (instead of ASSET) (2) Fix in issue when uploading file (3) This was ignoring the last line in the file |
#946 | sql EXECUTE on Publishing | an issue was identified with security permissions where some users where not allows to publish Resolution: Added the db_executer role in the System Database. If problem occurs on another user: - Open the BRSANALYTICS_System Database > Security > Users - Find the user in question - Under the Database Membership Roles, grant the db_executor role (usually user wil have db_datareader and db_datawriter. These should be kept) |
#939 | Lock 'Published' Dropdown in UI | Tweak in User Interface to lock on Published as is used throughout all customer |
#945 | Generate File Header | Tweaking for all AccountReference to be automatically set to Text |
#944 | Flows File – Missing Validation | If the VALUETYPE mismatches that of the EOPB, no warning was given and the movement was not allocated to the account |
#940 | Pivot Table Including Filtered Items | When a new pivot table is created using the toolbar, by default this was including the filtered items in the totals row. This setting is now disabled by default. |
#943 | Generate BRS File | Generating a BRS File using the toolbar fails if there were extra populated columns in the excel sheet (e.g. in Manual Adjustments File) |
#935 #932 | Flows linked to Rating and Holding | Due to AS11 and AE4, we needed to link Rating and Holding with Flows |
#958 | CRD Indicator | Fix in FullySecured on Immoveable Property |
#960 #964 | SBSA – No of Units | No of Units was not being displayed correctly within the SBSA sheet as this was rounding to the nearest thousand |
#962 | Holding Label | Previously if a new Holding label was added is added, this needed to be added in the database otherwise this is removed with a warning. The application now automatically caters for new holding labels and automatically assigns OVER10/UPTO10 accordingly. |
#965 | Flows Price Movement Calculation | On calculated flows, logic has been added to calculate the price movement for the AFS Securities, FVTPL, HFT and Equity if MarketValue is found for previous and current month. |
#968 | Flows Movement (from File) | If there was no closing then the movement from flow file was being lost |
#962 | Holding Label | If a new holding label is found, this will automatically add it within the label and classify it as UPTO10 or OVER10 |
#959 | AccruedInterestLCY | New column for Accrued Interest LCY such that if it is left empty it will work it out as today but if a value is provided it will retain that value |
#963 | Movement and Reval on Reclassified values | When a value was reclassified, this was showing the movement and Reval on the incorrect line i.e. of Opening – this has been rectified. |
#957 | ConnectedCustomer | Extension to the current CLTS.ConnectedCustomers functionality to accept a list of values |
#961 | CUBESET Convert to pivot | Fix in toolbar for convert to pivot on cubeset formulas |
#969 | Related Party in EOM | EOP Crashed when the EOPA Related Party was NONE and the CLTS Related Party was NULL |
#956 | CRD SME Supporting Factor | From the CRD UI, one can now access @PARTY.SMESupportingFactor |
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.7.4 .
Changes in Core Structure / Fixes in Formula Files:
INC No. | Structure | Description |
---|---|---|
#967 | Core | Minor change in label for Liabilities L5010040000, L5010050000 for Income Expenses (were labelled income). This does not effect br06 reporting. |
INC No. | Schedule | Description |
---|---|---|
AL1 | Cell K78 & L78 Nationality ROW to MUM Row 45 and Row 77 Remove Industry Group 3 as SPs are those with Sector Household and NACE not household. Row 20 Deduct Pub Non Market Units Bug fix Cell H46 & I46 |
|
AL4 | Row 16 include NACE A0200 (AGRIC) | |
AL5 | Bug Fix O44 | |
AL6 | Row 17 include NACE A0200 (AGRIC) | |
AS1 | Row 20 Fix bug in Sector | |
AS2 | Column M Change Sector to All Government Row 256 – Row 261 Included formulas and fixed Other Countries not specified elsewhere |
|
AS5 | Fixes to all sheet | |
AE1 | Cell J14 change Nationality to brNationality Cell J256 add formula for EIB Cell J260 bug fix |
|
LD8 | Row 15 include NACE A0200 (AGRIC) | |
AE3 | IFERROR Column C | |
LR | Row 35 & 36 Other n.e.c. removed the AI measure as this is already being added in the top part of the LR schedule. | |
LS2 | Bug fix Row 20 and Row 47 Bug fix in Sector Row 32 and Row 59 |
|
L | Add Sector Credit Institutions to Row 202 & Row 203 | |
AL9 | Row 22 & Row 34 Pick Remaining Households including the Sole Proprietors | |
Flowloans | Row67 – Revolving Loans and overdrafts to exclude double counting of revolving overdrafts | |
Flowdeposits | Rows of Transferrable Deposits to use new flow dimension | |
CL | Reclassifications Section | |
AE2 | Fix in sheet due to mistake by CBM in row hiding | |
Flows3 Flows4 | Fix in Remaining Liabilities Section due to some double counting (e.g. Row 102/103) | |
Flowloans | Fix in column Banks (as this was taking only MFI which was not accurate) and of which:NonBanks | |
AL9 | Reclassifications (Column M and N) | |
AS9 | Fix in M63 | |
MIR1 | No formula in N41 F91 & F92 Bug fix in if error condition I91 & I92 Bug fix in if error condition F95, F96, F99 & F100 include Account Type 'OTHERS' for Cards I95, I96, I99 & I100 include Account Type 'OTHERS' for Cards |
|
MIR2 | Bug Fix F63 & J63 Bug Fix F77 & J77 Bug fix E52, E53, E54 Bug fix I52, I53, I54 New Formulas in G122 & G123 (APRC) New Formulas in K122 & K123 (APRC) |
|
PL | Addition of new variable to calculate sections in P&L where sector splitting is problematic E135 Add Sector in formula Interest Receivable Apportioning in Cells E43, E46, E50, E53, E68, E69, E74, E75, E80, E82, E83, E84, E85, E86, E87, E88, E92, E94, E95, E96, E97, E98, E99, E100 Interest Payable Apportioning in cells E131, E134, E138, E141, E150, E153, E157, E160, E166, E167, E168, E169, E170, E171, E172, E183, E188, E189, E190, E191, E192, E193, E194, E205 |
|
AL12 | Fix all schedule to pick up cards only (Account Type 'OTHERS') | |
FINREP F20.04 | Fix in F20.04 210/010 and 230/101 to include IFERROR | |
FINREP F18.00 | Fix in row 22 to include Collateral for Commercial Property | |
FlowDeposits | Fix in column Banks (as this was taking only MFI which was not accurate) and of which: NonBanks Colum AN and AQ | |
MIR1 | Fix in IFERRORS for I92 | |
AL8 | Addition of IFERRORS for liability types | |
Flows1 Flows 4 | Fix in Remaining Assets | |
FlowLoans | Row52/Row38, Loans to Loans + Deposits Cell AR57/BK57 removal of Convenience indicator |
|
Flows3 | Fix in BB58, AY57 Row 59 other n.e.c |
|
Flows4 | Row59, AL95 – Removal of Sector Row 100 |
|
LH | Fix in Row24 | |
LR | Addition of new Variable brLiabilityLoansDeposits Fix in Schedule In section 1.3 Remaining Liabilities > Interest accrued and unpaid other than deposits due to incorrect bracket placement |
|
AE1 | Fix in Columns H and J. | |
AE3 | CUBESET to have Shares and Other Equity and Units | |
AL1 | Fix in 3.2 | |
AE4 | Column H should not have been deducting from Column K | |
CE | Minor tweaking on subcategories | |
FINREP F18.00 | Added Cash Balances to Cell Col 030, Row 080 | |
FINREP F20.04 | Added Cash Balances for Col 010 Row 140 and Row 150 | |
FINREP F19.00 | Fix in Row 140 using Colalteral Code IMMOV_PROP_COM (instead of industry) Fix in Col 070, Row 140 (Total now matches F20.04) |
|
FINREP F06.00 FINREP F04.03 FINREP F20.04 FINREP F20.07 | Modifications as follows to have Accumulated Depreciation as a negative value: • F06.00 Column 020 • F04.03 Column 040 • F20.04TOT and all Country Sheets – Column 030 • F20.07TOT and all Country Sheets – Column 020 Creation of new packs using the MFSA revised version as at Sept 2016 |
|
Flowloans | Row52 (ROW section) Row52 (SPE Section) |
|
Flowdeposits | Fix in Section 7.4 and 8.4 to deduct from repos Fix in reclassification for repos Fix in section 1.4 and 2.4 (Deduct from repos) Fix in column AY – incorrect sector (Double Counting) Fix in AT202 to use parent item deposits |
|
Flows3 | Fix in Row 30 (MT Section) Fix in Cells F29,30,31 (GenGov Govt) Fix in Row 43 Fix in Equity -> ROW exclude MMF Fix in AJ59, AL59 |
|
Flows4 | Fix in Equity -> ROW exclude MMF Fix in Row 58 Fix in Remaining Liabilities Section 5, Adition of Remaining Liabilities > Int. Accrued * unpaid on deposits incl. loans and Section 5.2 |
|
AS2 | Fix in Column F, H, J with ResidencyStatus NONE to exclude double counting of section 2.238 | |
AS5 | Fix in 5.1.1 | |
LR | Fix in 1.3 | |
L | Tweak in Accrued interest section | |
AR | Tweak to use BTot for certain CoA items | |
PL | Fix in SubCategory 6.1.2.1 | |
#760 | brHistoricConn | Introduction of a new Connection Variable to facilitate the use of the Current cube Changes in AL2, Column AX and AY, BR and BS Changes in LD4, Column AX and AY, BR and BS LC Cell E48 PR Sections with StartofPreviousPeriod AT E15, E23, H15, H23 CE Section 1 |
Flowloans | Fix in Formulas S68,S69, X68,X69,Y68,Y69,AR68,AR69,AW68,AW69,AX68,AX69 |
|
AL2 and LD4 | Column BZ, Btot measure for Other Unallocated assets> Interest due on Loans/ Deposits | |
Flows3 | Column AM – SectorBANKS instead of MFI | |
Flows3 Flows4 | Row59, fix in TMAI line too use remaining Assets > Other n.e.c Row100, Addition of TMAI for Int. accrued and unpaid on deposits incl. Loans Row97, Addition of TMAI on Int. Accrued and unpaid on deposits incl. Loans |
Message brought to you by the BRSANALYTICS Team
For more information call us on +356 2149 0700