1 / 34

The Agile Financial Data Services Community of Practice: XBRL + SSOA + Semantic Web

The Agile Financial Data Services Community of Practice: XBRL + SSOA + Semantic Web. XBRL 14 th International Conference & Exhibition: Regulators Track Wednesday, December 6, 2006, Grand Ballroom A: 9 a.m. – 5:30 p.m. Hyatt Regency Philadelphia, PA Brand L. Niemann (US EPA), Co-Chair,

bakerpaul
Download Presentation

The Agile Financial Data Services Community of Practice: XBRL + SSOA + Semantic Web

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Agile Financial Data Services Community of Practice: XBRL + SSOA + Semantic Web XBRL 14th International Conference & Exhibition: Regulators Track Wednesday, December 6, 2006, Grand Ballroom A: 9 a.m. – 5:30 p.m. Hyatt Regency Philadelphia, PA Brand L. Niemann (US EPA), Co-Chair, Semantic Interoperability Community of Practice (SICoP) Best Practices Committee (BPC), Federal CIO Council and Brian Hankin, PricewaterhouseCoopers December 5, 2006 Updated for XML CoP Meeting, December 13, 2006

  2. Abstract • The “father” of the eXtensible Business Reporting Language (XBRL) embraces the Semantic Web as the way to do Extreme Financial Reporting. • The presenters agree, but suggests Agile Financial Data Services = XBRL + SSOA* + Semantic Web (RDF/OWL, SWRL, and SPARQL). • Financial data is one of the W3C’s Semantic Web Activity “flagship areas” (also life and health sciences and geospatial), so SICoP has been working with the XBRL CoP since early February 2006 on the AFDS CoP. • This presentation builds on the previous presentations at the 5th Semantic Interoperability for E-Government Conference and the 2nd SOA for E-Government Conference, especially experience with using XBRL in the SOA CoP Demonstration. * Semantic Service Oriented Architecture

  3. Five Steps For Moving Forward • 1. AFDS CoP Mission Statement • 2. CoP Membership List • 3. CoP Strategy • 4. Training Conference Call (with items 1-3 entered into the Semantic Wiki space) • 5. Commitments to collaboratively publish and edit trusted reference knowledge sources in the Semantic Wiki space.

  4. 1. AFDS CoP Mission Statement • A public-private partnership led by senior government and non-government co-chairs building on the excellent work of the XBRL CoP to architect (using the FEA DRM 2.0) and deliver (using SOA) agile financial data services that include XBRL and non-XBRL data sources across the network with security and reliability.

  5. 2. CoP Membership List • The membership will bridge across the XML, XBRL, SOA, and SICoP CoPs and include those participants in the series of pilot presentations as follows: • February 1 and 13, 2006, XBRL Seminar - International Consortium on Governmental Financial Management and Federal Deposit Insurance Corporation. • February 8-9, 2006, SICoP 4th Semantic Interoperability for E-Government Conference – Digital Harbor. • June 27, 2006, XBRL Event at the FDIC Conference Center – SICoP.

  6. 2. CoP Membership List • The membership will bridge across the XML, XBRL, SOA, and SICoP CoPs and include those participants in the series of pilot presentations as follows (continued): • September 19, 2006, Collaborative Expedition Workshop, Open Collaboration: Networking Financial Management Communities – XML CoP, XBRL CoP, SOA CoP, and SICoP (see slide 10). • October 10-11, 2006, 5th Semantic Interoperability for E-Government Conference – Cutter Consortium/VivioMind Intelligence and Digital Harbor. • October 30-31, 2006, 2nd SOA for E-Government Conference – SOA CoP Demo Participants

  7. 2. CoP Membership List • Some Names and Interest: • Charles Hoffman, UBmatrix, Inc.: • Help Update Last Chapter of Book. • Chris Ball, CGI Federal: • Writing IAC XBRL Roadmap White Paper. • William McCarthy, Michigan State University: • Developing Accounting Ontology. • Bruce Cahan, Urban Logic: • Thanks for your work and leadership in this area. Please plug me into the AFDS CoP.

  8. 2. CoP Membership List • Some Names and Interest (continued): • Chris Whalen, Institutional Risk Analytics: • This is certainly needed and welcomed. • Allyson Ugarte XBRL-US: • The FDIC are very impressed with the semantic interoperability technology and with Digital Harbor. • Brian Hankin, PCW: • Excellent presentation and would like to help with AFDS CoP with PWC Taxonomy and Exchange Package. • Sam Mok, CFO, Department of Labor: • I like AFDS because we need to call this something other than XBRL.

  9. 3. CoP Strategy • The AFDS CoP will select co-chairs, develop a charter and bylaws, and produce white papers, pilots, and conferences following the principle of “open collaboration with open standards”. The regular meetings will serve to educate and demonstrate the value of open community-, open standards-, open-architecture-based collaboration across the Federal and international financial communities to produce architectural patterns and multi-vendor solutions that can be used and reused.

  10. 3. CoP Strategy • AFDS Pilot to connect the "three principle dots" from the September 19th Workshop: • 1. The new Federal Law requiring improved public access to government financial data (agency spending) that OMB is deciding how to implement. (Federal Funding Accountability and Transparency Act of 2006 - S.2590) • 2. The Federal Enterprise Architecture's Data Reference Model 2.0 for description, context, and sharing of the three types of data (structured, semi-structured, and unstructured). • 3. The clear role for and benefit of XBRL in the previous two. Don Geiger talked about the 7,923 pages in the 25 CFO Act Agency PAR reports, mostly in PDF, which is not DRM 2.0-compliant, which is a great place to start showing how to make these reports DRM 2.0 - compliant using XBRL and developing the kind of taxonomy called for that could become an ontology.

  11. 3. CoP Strategy

  12. 3. CoP Strategy • Pilot Implementation of The Federal Funding Accountability and Transparency Act of 2006. • Continue to Support the Financial Management LoB. • Continue to Work with the SOA CoP and the Joint Task Force on SOA Governance. • Work with the XBRL CoP to Evolve XBRL to Work in SOAs and the Semantic Web. • Support Charlie Hoffman in the Revision of Chapter 21. Vision of the Semantic Web and the Inclusion of Semantic Web Standards in His Exercise Files.

  13. 4. Training Conference Call • Revelytix announced its Semantic Wiki (Knoodl) and Support for the New Vocabulary Management WG at the 5th Semantic Interoperability for E-Government Conference on October 11th: • FMS will continue its work with the FPAs to adopt uniform accounting and reporting standards and systems. FMS will develop a government-wide infrastructure to standardize definitions of federal accounting terms and their usage, and provide to agencies an interactive U.S. Standard General Ledger website and database. See report page 47. • The VMWG Training Conference Call Will Also Serve to Introduce the AFDS CoP to Semantic Wikis. • Watch for Announcement Open to All (December 4th Launch).

  14. 4. Training Conference Call http://knoodl.com

  15. 5. Commitments to Collaborate • The 2nd SOA for E-Government Conference, October 30-31, 2006, SOA CoP Demo Participants (see slides 16-17): • Data Access Technologies (Cory Casanave and Tom Digre) • Booz Allen Hamilton (Grant Boyd) • DynAccSys (Sonia Antypas) • Kapow (Kash Badami) • MetaMatrix (Chuck Mosher), and • Sun Microsystems (John Landers).

  16. 5. Commitments to Collaborate Dashboard Client Data Access Executable Model Business Intelligence (Reports/Dashboard) Web Service NEF Program (Manages Projects) Web Service Sun MicroSystems Employee (Reports Time) Web Service HR/Payroll - LoB (Allocates Time to Projects) Web Service Finance LoB (Calculates Costs) Web Service Web Form Contractor (Produces Invoices) DynAccSys Data Access Executable Model MetaMatrix Data Services Implementation

  17. 5. Commitments to Collaborate Use of XBRL

  18. 5. Commitments to Collaborate • An Integrated Approach to SOA Governance (Joint Task Force on SOA Governance): • ArchitecturePlus Seminar, December 19, 2006. • SOA: Initiatives and Perspectives in State and Local Government: • Collaborative Expedition Workshop, January 23, 2007. • Next Iteration of the SOA CoP Demonstration for 3rd SOA for E-Government Conference • Date to be announced.

  19. 5. Commitments to Collaborate • Issues in the Architecture: SOA and Semantic Web (November 16, 2006): • Rather Than Talk Abstractly Lets Use an Example of a Major Federal Government Program for Information Sharing That is Going Through this Evolution (File-Sharing and Data Architecture to Web Services in a SOA to Knowledge Computing) and How IT Management – Server Consolidation, Virtualization and Other Best Practices Come Into Play.

  20. 5. Commitments to Collaborate NIEM Roadmap Pilot

  21. 5. Commitments to Collaborate NIEM Roadmap Pilot Imagine that the Nodes, Subnodes, etc. could be for Organization, Threat Category, Persons of Interest, Intelligence Analysis, etc.

  22. 5. Commitments to Collaborate Content Management Services Knowledge • Department of Justice: • Bureau A • Person of Interest X • Threat Analysis 1 • Etc. • Etc. • Department of Homeland Security • Bureau B • Person of Interest Y • Incident Report 2 • Bureau C • Person of Interest Z • Interview Report 3 • Etc. Moreover, the level of integration that is possible today is evident in an ever-expanding array of online services in commercial endeavors and consumer products (e.g., eBay and Amazon.com). Surely, first responders should be able to share information and effectively communicate in emergency situations, when seconds count and lives are at stake. NIEM CONOPS, Page 6) NIEM Roadmap Pilot

  23. 5. Commitments to Collaborate • Agile Financial Data Services Community of Practice Pilot • Semantic Interoperability Community of Practice (SICoP) DRM 2.0 Semantic Wiki Pilot Project (November 13, 2006) • Table of Contents • Data Reference Model 2.0 Schematic Diagram Interface • Data Reference Model 2.0 Implementation Metamodel • Data Reference Model 2.0 Concept Maps • AFDS Metamodel for Ontology Building • Content Repurposed: • The Federal Funding Accountability and Transparency Act of 2006 • Department of the Treasury Fiscal Year 2005 Performance & Accountability Report—Highlights • Federal Deposit Corporation 2005 Annual Report • EPA’s FY 2005 Performance and Accountability Report • XBRL Pilot Project - Public Sector • Financial Reporting Using XBRL See next slide for functioning pilot.

  24. 5. Commitments to Collaborate Make everything DRM 2.0 –compliant, all the content, even the book sample, and make its XBRL files Semantic Web – compliant!

  25. 5. Commitments to Collaborate Can query for numbers. Tables are XML-based so can copy-and-paste structured data!

  26. 5. Commitments to Collaborate EPA Financial Statements have notes that include tables themselves!

  27. 5. Commitments to Collaborate EPA Financial Statements have extensive cross-referenced Notes!

  28. 5. Commitments to Collaborate • XBRL is a markup language that converts unstructured information to structured data and/or proprietary formats to an open standard, interoperable format. • XBRL-enabled software facilitates statistical analyses, aggregation, reporting, etc., with XBRL data. • Note: I strongly urge XBRL and OASIS to get to Google Spreadsheets ASAP about providing for import and export of XML-based standards and vocabularies (See update in slide 29). • Composite applications implementing DRM 2.0 are needed to work with XBRL and non-XBRL data sources across a network to do “smart – intelligent - interactive” information sharing applications. Brand Niemann , Increasing the Value and Timeliness of Business Information Using XBRL & DRM 2.0 Composite Applications, Slide 7: Positioning XBRL, XBRL Event at the FDIC Conference Center, Arlington, VA, June 27, 2006.

  29. 5. Commitments to Collaborate The wikiCalc program is a web authoring tool for pages that include data that is more than just unformatted prose. It combines some of the ease of authoring and multi-person editing of a wiki with the familiar visual formatting and data organizing metaphor of a spreadsheet. See http://www.softwaregarden.com/wkcalpha/

  30. 5. Commitments to Collaborate • For more information: • Brand Niemann: • SICoP Co-chair and EPA Data Architect • US Environmental Protection Agency • Niemann.brand@epa.gov • Brian Hankin: • Washington Federal Practice, Advisory Services • PricewatershouseCoopers • Brian.hankin@us.pwc.com • Wiki Pages: • http://colab.cim3.net/cgi-bin/wiki.pl?ExpeditionWorkshop/OpenCollaboration_NetworkingFinancialManagementCommunities • http://colab.cim3.net/cgi-bin/wiki.pl?AfdsCop • http://colab.cim3.net/cgi-bin/wiki.pl?SoaLobDemo

  31. 6. Update • Feedback from XBRL 14th International Conference and Discussions at XML CoP Meeting, December 13th: • Ernst & Young Brochure: XBRL – The Exchange of Interactive Financial Reporting Data. • See slides 33-34 for critique. • Internal Reporting Track when Don Geiger asked for participants in his pilot. • This is essentially a composite application which we have already successfully piloted with Digital Harbor. • Include content at http://www.fms.treas.gov/ and http://www.fsio.gov/ in AFDS CoP Pilot.

  32. 6. Update • Feedback from XBRL 14th International Conference and Discussions at XML CoP Meeting, December 13th (continued): • Hoffman's Tutorial on XBRL Dimensions. • I told him that I did both what his new Taxonomy Manager (map the taxonomy to markup the data table) and other vendor products do that deliver an interface to the financial data tables that the public and a CFO can use and showed that earlier in the morning Regulator Track. • Regulators Track (Afternoon) where I mentioned how Semantic Standards and Technology like Semantic Wikis can do what the FDIC and Treasury are doing. • Imagine what financial folks can do with XML markup, concept (taxonomy) generation, spreadsheet, etc. capability in Semantic Wikis.

  33. What is XBRL and how does it work? Note: This is just a small part of DRM 2.0 – recall slide 25. http://www.ey.com/global/content.nsf/International/XBRL-How_Does_It_Work

  34. What is XBRL and how does it work? • “…a family of taxonomies (dictionaries of terms)” • The term dictionary is better because the term taxonomy means something else to most. • “Therefore, recipients (of XBRL data) know all of the pertinent context of the data…” • It is just the table of financial data not the DRM 2.0 requirements. • “By tagging the data in XBRL, a computer can understand the same information that we can by reading the statement, something that is not possible with a paper financial statement or electronic file (Adobe PDF, HTML, or Spreadsheet).” • Adobe supports W3C standards for machine process-able data (XMP, SVG), XML was designed to make HTML machine processable, and spreadsheet data is machine process-able.

More Related