Extensible Business Reporting Language

The Christopher Cox modernization commission proposes that companies provide their financial statements to the Commission and on their corporate Web sites in interactive data format using the eXtensible Business Reporting Language (XBRL). A statement on Page 29 of the PDF states that the decision about this request becoming compulsory was to have been decided on December 15th, 2008.

XBRL was derived from the XML standard. It was developed and continues to be supported by XBRL International, a collaborative consortium of approximately 550 organizations representing many elements of the financial reporting community worldwide in more than 20 jurisdictions, national and regional.

The proposal is a significant one for Mr. Cox as he is a proponent of modernization and the use of current technology to reduce business and government expenses. His legacy will be the promotion of “interactive data” and modernization of SEC filings through the use of XBRL.

Mr Cox has decided to retire at the end of President Bush’s term. During Mr. Cox’s tenure, the regulator has convinced over 8,000 companies to use XBRL in various types of filings. Large international organizations such as Proctor and Gamble and Pepsi file with GAAP and IFRS, are using XBRL, and are on the very pro XBRL bandwagon.

About the only criticism I have about Mr. Cox’s plan is the timeline. CFOs balked at the aggressiveness of the schedule that SEC proposed. SEC wants them to aim for concrete results for 2010.

Sharing SharePoint and Unified Communications

Microsoft SharePoint is the platform for portal-based collaboration and document management/enterprise content management (ECM). The product also works tightly with Windows Workflow Foundation (WF) and Unified Communications (UC), both Microsoft technologies that will be described in detail later on. This integration provides great visibility for workflows related to documents and document libraries, and improving collaboration through the “presence” and “click to communicate” features.

Today, SharePoint is the universal portal technology for the Dynamics portfolio; for example, in Dynamics AX 2009, the AX Enterprise Portal (formerly Axapta Enterprise Portal) is now based on SharePoint. The portal was devised from the standard SharePoint design experience, whereby a gallery of Dynamics AX Web parts is now available, making it very simple to bring to the surface Dynamics AX data (with the inherent AX security model enforced) on SharePoint portal pages.

In addition to Web parts, other strategies for SharePoint integration are its Business Data Catalog (BDC) Web Services feature (currently used within Microsoft Dynamics GP [evaluate this product] and Dynamics CRM [evaluate this product]), and data binding (within Dynamics AX). It is likely that BDC services will grow further in importance, and we should expect a broad Microsoft Dynamics consistency around this feature.

The abovementioned UC technology provides the ability for applications to identify users’ “presence” and enable “click to communicate” capabilities. Via Microsoft Office Communications Server 2007, Dynamics AX 2009 and Dynamics CRM 4.0 currently work with UC (which is envisioned for the upcoming Dynamics ERP releases too). For example, whenever a user sees a person in the application screen, he/she can also see a presence indicator showing if they are “out of the office”, “in a meeting”, “on a call”, or “available”. By clicking on the indicator, a user gets to pick the preferred method to communicate with them with a single click, whether it might be via email, instant messenger (IM), or phone, if the company has the computer telephony integration (CTI) capabilities.

The Microsoft Dynamics team is working together with the UC team to develop even more advanced scenarios that bring people closer to the processes represented in their applications. One such possible scenario, “Call Center of the Future”, was showed at Convergence 2008 during Steve Ballmer’s keynote speech. Expected scenarios for the next version of UC platform will revolve around how to factor in application embedding, advanced in-context collaboration scenarios, and blending UC and business process management

Microsoft’s Underlying Platform Parts for Enterprise Applications

Innovation is now surfacing as a result of integration between the Microsoft Visual Studio.NET (VS.NET) development platform and SQL Server. Namely, there is now the ability to launch Precision Report Designer and maintain the Dynamics AX semantic models in VS.NET and to pass the data in a closed-loop manner to and from Dynamic AX logic models. These models can in turn look into the Dynamics AX database (SQL Server) via database secure views. The future development will make these currently static models dynamic for report-customization purposes.

Along similar lines will be the use of Microsoft SQL Server Analysis Services (SSAS), whereby all Dynamics role centers within the user experience (UX) project (mentioned in Part 1) will feature embedded contextual business intelligence (BI). Currently, Dynamics AX 2009 has the cube generation capability, whereby analytics perspectives have been added to the business logic model, and which can generate Data Source Views (DSV’s) and Online Analytic Processing (OLAP) cubes. The future research and development (R&D) forays will likely enable the round-trip (between VS.NET and SQL Server) advanced features that will require similar features to the abovementioned reporting tools.

As a little caveat, these native reporting and analytics features will not be automatically available to the users of the proprietary Microsoft Dynamics NAV C/Side database (about half of the install base) and Dynamics AX Oracle instances. For Dynamics NAV customers using the older C/Side database, most of them upgrade to SQL Server when they move to a new NAV version anyway, while Dynamics AX users on Oracle can access the new reporting and analytics features by adding SSRS and SSAS to their deployment. Still, Microsoft will, for the foreseeable future, honor the ongoing support for these databases alongside its SQL Server.