solutions overview on processing and rendering errorerror...
Post on 22-Apr-2020
6 Views
Preview:
TRANSCRIPT
SolutionsSolutions overviewoverview onon processingprocessing andand renderingrenderingSolutions Solutions overviewoverview on on processingprocessing and and renderingrenderingerrorerror messages relative to the new Eurofiling messages relative to the new Eurofiling taxonomytaxonomy for FINREP rev2for FINREP rev2
Derek De Brandt on Derek De Brandt on behalfbehalf of XBRL Europeof XBRL EuropeLondon, March 30, 2011London, March 30, 2011London, March 30, 2011London, March 30, 2011
IntroductionIntroduction
Eurofiling is an open joint venture of the XBRL network of theEuropean Banking Authority (f.k.a. Committee of European Banking
) ll b h ll k h ldSupervisors) in collaboration with XBRL Europe, as well as stakeholdersas banks, solutions providers, academy and individuals. Deliverables areData Models, XBRL taxonomies, know-how and materials for COREP andFINREP Frameworks.
Case
Reported facts are represented in the so-called “templates”, recognizable in a tabular way in eg. MS Excel
A series of “templates” belong together in a so-called “framework”
The framework has been modeled in a so-called “Data Points Matrix Schema”, the basis for the taxonomy
The taxonomy will contain formulae to facilitate inter- and intra-template validation checksThe taxonomy will contain formulae to facilitate inter and intra template validation checks
Question
Do you have any component or solution to visualize or render errors resulting from XBRL Formula validation, and
potentially correlating these error messages to cells in the “templates”?
March 30, 2011 2Derek De Brandt | COREP/FINREP Harmonization
AnswersAnswersAnswersAnswers
(ordered alfabetically)
1 Aguilonius1. Aguilonius
2. Fujitsu
3. Invoke
4. Iris
5. Reporting Standard
6. Ubmatrix
Derek De Brandt | COREP/FINREP Harmonization 3
Derek De Brandt | COREP/FINREP Harmonization 4
Server-side implementationStandard Oracle databaseXBRL Processor
Derek De Brandt | COREP/FINREP Harmonization 5
Derek De Brandt | COREP/FINREP Harmonization 6
Data are retrieved from the databaseand displayed in the Excel template
Derek De Brandt | COREP/FINREP Harmonization 7
p y p
After validation, XBRL errors areconnected to cells in the table
Derek De Brandt | COREP/FINREP Harmonization 8
Valid instances can be sent to the regulator
Derek De Brandt | COREP/FINREP Harmonization 9
March 30, 2011 10
OverviewOverview
Reporting Institutions COREP/
FINREPTaxonomy
Mapdefinition
Supervisor(exp. Eurofiling)
Download fromCOREP/FINREPwebsite
Data Matrix(Excel as Form)
TemplateI
Formuladefinition
Distribute
SheetInstanceCreator
InstanceSystemInstance Submit
Reduce impact of taxonomyReduce impact of taxonomy change:change:l h dl h d ff bYou can only handle the difference by
GUI tools.Excel
Formula Editor
Sheet MappingDesignerProgram included
d
•Input by Excel•Check by rule - find errors if any exist
File to be madeby supervisor
in Product
Define validation/ calculation rules
All Rights Reserved ©
March 30, 2011 11
All Rights Reserved © Fujitsu Limited 2011
InterstageInterstage XWandXWand –– Support Excel as Support Excel as an an inputinput
Enable to generate instance from ExcelEnable to generate instance from Excel
March 30, 2011 12
All Rights Reserved © Fujitsu Limited 2011
InterstageInterstage XWandXWandLoadingLoading Excel Excel spreadsheet spreadsheet intointo thethe tooltoolgg pp
Prepare the Completed Prepare the Completed SpreadsheetSpreadsheet
ImportingImporting thethe spreadsheetspreadsheetintointo thethe tooltoolSpreadsheetSpreadsheet intointo thethe tooltool
The data in Excel spreadsheet areCompleted Excel spreadsheet
pfeed into the tool
March 30, 2011 13
All Rights Reserved © Fujitsu Limited 2011
Other LineupOther Lineup
XWand Sheet Mapping Designer
Define map between cell an concept for Sheet Instance Creator.
XW d F l Edi
Enable to create formula by GUI.
XWand Formula Editor
Interstage XWand also supports “Web Form Generator” same as this scheme.
All Rights Reserved ©
March 30, 2011 14
All Rights Reserved © Fujitsu 2011
InterstageInterstage XWandXWandFindingFinding ErrorsErrors: : ValidateValidate & & CheckCheck by by RulesRulesgg yyShow error value in Excel viewShow error value in Excel viewYou can update the data in this viewYou can update the data in this viewR l i h d ith R l i h d ith S iS i //R tiR ti I tit iI tit i ith t E l Mith t E l M
If there is an error for formula:
Rule is shared with Rule is shared with SupervisSupervisoor/r/ReportingReporting InstitusionsInstitusions without Excel Macro.without Excel Macro.
The errorrelated cells are high-lightedhigh-lighted
The error message The error message which you defined is shown
All Rights Reserved © Fujitsu Limited 2011
March 30, 2011 15
16
Vendor: InvokeVendor: InvokeS l ti I k XBRL S itS l ti I k XBRL S itSolution: Invoke XBRL SuiteSolution: Invoke XBRL Suite
• XBRL Designer: creation of templates to prepare the user vision of the taxonomy
• XBRL Writer: web user interface to create or modify XBRL instances
• XBRL Reader: web user interface to publish XBRL informationpublish XBRL information
• XBRL Validator: XBRL validation and Formulae validation
March 30, 2011 17
XBRL ValidationXBRL ValidationXBRL ValidationXBRL Validation
• XBRL Validation in real time to generate both user friendly vision and technical answer
• One validation with 2 types of messagesO e a dat o t types o essages
1st : a user friendly vision (errors highlighted in templates)
2nd : a technical answer for batch validation (XML schema)2 : a technical answer for batch validation (XML schema)
• Direct link between XBRL validator and the templates thanks to the native XBRL spreadsheet
18
XBRL Formula validation: error handling and XBRL Formula validation: error handling and i (1/2)i (1/2)messaging (1/2)messaging (1/2)
Illustration based on the FINREP taxonomyIllustration based on the FINREP taxonomy
f i dlUser friendlyvision:Wrong cellsare direcltyhighligted intog gthe templates(severalsheets in case of inter documentsdocuments validation)
Technical( lanswer (also
available in XML format)
19
XBRL Formula validation: error handling and XBRL Formula validation: error handling and i (2/2)i (2/2)messaging (2/2)messaging (2/2)
Illustration based on the FINREP taxonomyIllustration based on the FINREP taxonomy
Direct linkbetween the XBRL Validatorand the cellsi i tin error intothe template
20
XBRL rendering XBRL rendering –– rendering rendering linkbaseslinkbasesIllustration based on FINREP taxonomyIllustration based on FINREP taxonomyAutomated preparation of templates used for error messagingAutomated preparation of templates used for error messaging
Renderinglinkbases:automatedautomatedpreparation of templates
21
IRIS Business Services Indian ImplementationIRIS Business Services Indian ImplementationIRIS Business Services, Indian ImplementationIRIS Business Services, Indian ImplementationPartial Integration in Bank Regulatory ReportingPartial Integration in Bank Regulatory Reporting
IRIS iDEAL Tool (Internal Data Extraction, Aggregation & Loading)
- Bridge between bank’s internal data systems and reporting templates
Map regulatory taxonomy with banks internal systems
Linking the CBS (Core Banking System) directlyg ( g y ) y
Creating an intermediate data base, with data points as required
Aggregate data from multiple sources
Aggregate data stored in multiple formats
Design schedulers for periodic retrieval or collection of data
Validate the data based on taxonomy/customised rulesValidate the data based on taxonomy/customised rules
Populate reporting templates or directly generate instance document
23
IRIS IRIS iDEALiDEAL
24
Error Handling & Exception Reporting Error Handling & Exception Reporting ERROR TRACKING
Business Rules Validations Formula Links Bases with l l tiBusiness Rules Validations
1. Preset tolerances defined
calculations
2. Analytical ratios set up
3. Company specific business ratios/ validations
4 C i th th4. Comparisons – month on month or year on year
5. Comparisons – country / industry standards/ regulatory
6 Dash boards with red/yellow/ green flags as per deviations from norms6. Dash boards with red/yellow/ green flags as per deviations from norms
7. Risk area/ values identified & present as a call out for review
Level I: File verificationConformation to std instance doc Level II: Taxonomy verification
Regulatory compliance Level III: Business rulesFormula link bases
25
BenefitsBenefitsBenefitsBenefits
1. Streamlines and automates the process of business data collection.
2. Elimination of manual entries for preparing regulatory filings,2. Elimination of manual entries for preparing regulatory filings, zero touch creation of regulatory reports
3. One data can be used for different reports with one time t itagging
4. Data overlaps can be identified hence one data will be sourced only a single time thereby ensuring data consistencyy g y g y
5. Business rules overlay for enduring accuracy6. Can be customised for generation of internal MIS7. Pre Integration with Infosys CBS, Finnacle
26March 30, 2011
27March 30, 2011
Reporting Standard / Case SolutionRS F l (V lid ti E i ) 100% i l d- RS Formula processor (Validation Engine) 100% implemented.
Will be implemented and running in production for the Peru SBS (Peru Banking Supervisor)
After validation isAfter validation is complete, this button produces a validation report in Excel. But at
API level it uses a i i t fgeneric interface
allowing the creation of validation reports in PDF, eMail, Word, Excel
or any other format. y
Reporting Standard / Case SolutionThe taxonomy is being created using Data Point Schema from BR-AG and Reporting Standard Taxonomy Builder, from Excel files
Reporting Standard / Case Solution
- Custom error messages are possible
• Using the Generic expression message labels 1.0 specification (Internal Working Draft of the FWG).g
• Using additional labels linked as generic resources to the assertions being executed.Si lif i th f ti th t d th• Simplifying the process of creating the taxonomy and the error messages by using Reporting Standard DTS Language Definition implemented in XBRL. Excel formulas modifies the parameters of th i t ti i d i t i di t d i E lthe instructions as required using parameters indicated in Excel sheets.
• The XBRLValidationReport object is the source of the Validation p jReport on any consumer format (PDF, Word, Excel, HTML, Email, etc…)
31
Edgar Online Inc.Edgar Online Inc.UBmatrix™ Processing Engine Formula SupportUBmatrix™ Processing Engine Formula SupportUBmatrix Processing Engine Formula SupportUBmatrix Processing Engine Formula Support
•UBmatrix XPE - Complete XBRL Validation p•XBRL 2.1 spec compliant (Full Calculation trace) •XBRL Dimensions 1.0 and Aggregations (WD)•XBRL Formula 1.0 (including CR10)
StandardTaxonomies
ExtensionTaxonomies
ExtensionFormulae
TransformationStyle Sheets
( g )
•Software Developer Kit (XPE API) •Support for both .Net and Java
XSLTFormulaXMLXBRL•Fully integrated XBRL compliant
formula validation and processing
•Summary and detailed execution reports
XSLTFormulaXBRLFRTA
Validate Verify Render
InstanceDocuments
y p
•Ability to render multi-lingual messages from the taxonomy (CR10)
P b j t•Proven by major customers•US SEC, Banque de France, Ministry of Finance BelgiumR t B ild F l lid ti f US SEC Fili
ValidationReports
CalculationReports
FormulaeReports
•Report Builder – Formula validation of US SEC Filing guidelines
Edgar Online Inc. Edgar Online Inc. UBmatrixUBmatrix™™ Report BuilderReport Builder Formulae & TemplatesFormulae & TemplatesUBmatrixUBmatrix™ ™ Report Builder Report Builder –– Formulae & TemplatesFormulae & Templates
•Microsoft Office based XBRL environment•Drag and Drop mapping of XBRL elements
•Easily view and navigate the taxonomy
•Inline XBRL supportInline XBRL support
•Developers APIs•Pre-mapped Eurofiling Excel templates
•Reduces errors, can be quality checked beforehand
•Real-time taxonomy validation•Real time taxonomy validation prevents users from:
•Tagging incorrect combinations of items and dimensions
•Tagging same item multiple times with inconsistent values
•Integrated XBRL formula validation using XPE (including CR10)•Integrated US SEC Filing Manual Validation Rules (XBRL Formulae)•Integrated US SEC Filing Manual Validation Rules (XBRL Formulae)•Capability to support Global Filing Manual or Local Rules
UBmatrix™UBmatrix™ Error Message HandlingError Message HandlingUBmatrix™ UBmatrix™ –– Error Message HandlingError Message Handling
• Error correlationXPE & RBME id d t il d t t• XPE & RBME provide detailed trace reports
• RBME provides element tracking back to cells
• Full debug trace of execution available
• Parameterised and local language support for error messages• e.g. Ministry of Finance Belgiume.g. Ministry of Finance Belgium
• Manage error handling and messaging via grouping formulae and their execution
Can dynamically attach formulae in XPE and RBME• Can dynamically attach formulae in XPE and RBME
• Breakdown formula execution according to submitter and report type (Banque de France)
St d lid ti (Mi i t f Fi B l i )• Staged validation: (Ministry of Finance Belgium).• Check correctness first, e.g. No duplicated
elements in an XBRL Instance• Then check accuracy e g A = B + C knowing• Then check accuracy, e.g. A = B + C, knowing
that there are no duplicates.
ThankThank youyou forfor youryour attentionattentionderek.debrandtderek.debrandt@@xbrlxbrl--eu.orgeu.org
Derek De Brandt | COREP/FINREP Harmonization 35
top related