XBRL Power Suite
Maximum Compliance, Maximum Adoption

SQL Power's Regulatory platform provides the optimal medium for collecting, managing, mining and reporting against standardized electronic content worldwide.

 

XBRL Power Suite is an eSignature-ready Supervision Management Framework that's completely multilingual. The solution integrates easily into existing regulatory infrastructures to unify de-centralized operations, and streamline important regulatory oversight functions. The platform has been field-proven by Canadian as well as international regulators.

The XBRL Power Suite's dynamic rules-based architecture allows business users to easily update an organization's Taxonomy in order to reflect the most recent regulatory policy or legislative changes. The solution automatically renders Web-Forms/Returns from the latest taxonomy, and cascades Taxonomy changes throughout the system, without any need for re-coding. This reduces the dependency on outside consultants or IT for ongoing system maintenance. It fully insulates the regulator and the filing entities from XBRL's complexities, while delivering all the advantages of a complete end-to-end XBRL based regulatory platform - ensuring maximum adoption, transparency, flexibility and compliance.

SQL Power's real-time XBRL Analytics platform is the most powerful XBRL Business Intelligence (BI) platform on the market, delivering a pre-built data mart solution that is Taxonomy agnostic (no ETL changes required) and a BI tool in MicroStrategy that provides all Business Intelligence requirements including: standard reports, ROLAP cubes, Data Mining - predictive and regression modeling, Mobile Dashboards and ad-hoc reporting.

Built organically from the ground up specifically to satisfy complex and evolving financial regulatory requirements, SQL Power's zero-footprint solution is establishing the pattern for disclosure in the 21st century - the preeminent blend of regulatory expertise and enterprise-class software engineering.

XBRL Power Suite: Components


XBRL Power Suite Components and Integration

SQL Power's end-to-end Regulatory solution offers the highest level of automation to Regulators and their regulated subscriber entities: a subscriber simply logs in via the internet and submits its business information or corporate financial filings via a secure, intuitive submission form dynamically rendered by an XBRL taxonomy (or business rules dictionary).

The submission is then validated in real time, certified, converted and stored as XBRL for easy analysis, management and distribution. The solution permits regulatory bodies to collect high quality financial data quicker, and in an electronic standardized way - ultimately accelerating financial analysis and improving communications between regulatory agencies.

Zero-footprint thin-client software

Zero software downloads and zero investment is required at the subscriber level; in fact, very little training if any is necessary. Even smaller, less sophisticated clients can output XBRL instance documents without any previous knowledge of the standard. The system also supports web services for loading and verifying existing XBRL documents, and offers an optional conversion module for CSV, XML and fixed length files.

Best of all, when revisions to the taxonomy are required, or when policy or legislative changes occur, a business user can drag and drop XBRL components using XBRL Designer and publish the new returns. Forms, analytics and all other application components are updated automatically with one touch, effectively future-proofing your organization.

Components

SQL Power's zero-footprint platform is based on a low-risk, modular architecture to enable the collection, processing, storage and analysis of supervisory, solvency and statistical data. The core components of the platform are:

  1. XBRL Forms and XBRL Power EAS thin-client platforms form the building blocks for the user experience,
  2. XBRL Designer, a business-user lead tool for taxonomy and returns creation,
  3. XBRL Analytics pre-built reporting and analytical solution,
  4. and at the core of these modular applications is the industry's highest performing and most scalable XBRL Processing Engine (XPE).

These application components can be purchased individually or grouped into a fully integrated end to end solution.

 


XBRL Designer
XBRL taxonomy optimization at the business user level


XBRL Designer is a rules-based, metadata driven GUI design facility that gives the business user complete control over Data Collection and validation specifications. It enables "self service" for Regulators in the same way XBRL Forms enabled "self service" for filers two years earlier. It demystifies XBRL Taxonomy Design and allows Regulators to rollout their Data Collection requirements in days instead of months.

XBRL Designer puts Taxonomy design back into the hands of the Regulator, at the business user level - simplifying and streamlining the Data Collection design process and allowing regulators to quickly react to changing legislation, standards and policies without IT or 3rd party intervention.


XBRL Forms
Financial data capture, validated against the taxonomy in real-time


XBRL Forms provides an easy-to-use, web-based front end for users to submit financial information and verify the validity of their submission. The processing engine also provides taxonomy and instance document validation and conversion to XBRL.

With the taxonomy identified, the application renders a set of taxonomy-driven screens and schedules to facilitate the data capture of high quality financial information. XBRL Forms validates each filing in real time against the taxonomy, certifies the return and loads it directly into the XBRL Analytics database. With XBRL Forms, Regulators move beyond compliance by effectively removing the burden and expense of generating XBRL filings from the filing organization, thus encouraging immediate adoption of the new filing standard.


XBRL Power EAS
Command control - secure portal to productivity


Serving as command control for the entire platform, XBRL Power EAS provides the enterprise-level web services required (such as security, collaboration, scheduling, notifications, user management, taxonomy management and document management) for fully-integrated, end-to-end XBRL data collection and analysis. It seamlessly integrates the individual components of the XBRL Power platform to provide a single, secure access point for all users. The integral hub of SQL Power's end-to-end XBRL platform, the XBRL Power EAS 'thin client' runs in any modern web browser, making it easy to use, easy to deploy and instantly accessible for all users within your organization.


XBRL Analytics
True Data Mining/Analytics combined with sophisticated financial reporting for maximum disclosure and transparency


XBRL Analytics bundles SQL Power's proven ETL technology with pre-built MicroStrategy reports, graphs and dashboards (including mobile versions) to deliver regulatory business intelligence value day one.

Standardized electronic data "content" loaded into XBRL Analytics enables intra and cross-sectored analysis and data mining for supervisory purposes. XBRL Analytics supports regulatory processes for macro-prudential supervision (i.e. benchmarking, identifying outliers, etc.) and peer rankings within an industry category or across market sectors. Standardization of data "content" also enables easy collaboration among other regulators, and in particular facilitates group-wide analysis as well as solvency calculations under an extended supervision framework.

XBRL Analytics comes with pre-defined standard reports, as well as web and mobile dashboards. Additional ad-hoc reports and custom standard reports and dashboards can also be developed internally or by SQL Power consultants to deliver a comprehensive and collaborative end-user reporting environment.

XBRL Analytics supports Stream Analytics or "Operational Intelligence" which analyzes against real-time (not low-latency) data as it streams into a regulator's systems. Stream analytics applies fairly static queries against otherwise very dynamic data - we might think of analyses around fraud detection running against every credit card, claim or other transaction streaming into an organization.

 

XBRL Power Suite: Components and Deliverables

Benefits

SQL Power's end-to-end, real-time platform is a simple but comprehensive XBRL solution that removes the onus of creating XBRL instance documents from the regulated entities and ensures maximum compliance and adoption.

  • Rules-based, metadata-driven GUI design functionality puts the regulators and policy makers back in control, allowing them to quickly change the Taxonomy (data collection rules) to respond to changing trends and monitoring requirements in mere days- ultimately future proofing the organization.
  • Enables easy collaboration among other regulators, and in particular facilitates group-wide analysis as well as solvency calculations under an extended supervision framework.
  • A comprehensive and fully-integrated XBRL solution provides the optimal medium for controlling, mining and reporting against standardized electronic content.
  • A Zero-Footprint (thin client) forms-based XBRL solution removes the onus on the filing organizations - increasing adoption and compliance, while insulating the filer against the complexities of XBRL.
  • SQL Power's pre-built Analytics Data Mart comes bundled with MicroStrategy, and delivers instant reports, ROLAP cubes, Data Mining, Mobile Dashboards and an ad-hoc Business Intelligence environment.
  • Standardized electronic "content" enables direct system-to-system information sharing between filing entities, Central Banks and other regulatory agencies, and minimizes error rates as information moves from regulated sources through to the regulators analytical software via straight through processing (STP).

 

Applications

  • Regulators & Central Banks Read more
  • Credit Risk Management in Commercial Lending Read more
  • Capital Markets Investment and Securities Regulation Read more
  • Governments, Statistical and Central Health Authorities
  • Issuers to investors "corporate actions"
  • Other Data Collection organizations

 

While the SEC and many Central Banks have mandated the XBRL standard, until now the onus has typically been on Financial Institutions (FI) or Public Issuers (the filing entities) to incur the substantial expense involved in complying with these mandates.

We are essentially reversing that model - a subscriber simply logs in via the internet and submits its business information or corporate financial filings via an intuitive submission form rendered by a standard or custom taxonomy. The submission is then validated in real time, certified, converted and stored as XBRL for easy analysis, management and distribution. The solution permits regulatory bodies to collect high quality financial data quicker, and in an electronic standardized way, ultimately accelerating financial analysis and improving communications between regulatory agencies.

SQL Power has developed a flexible set of integrated XBRL-based applications and tools used to deploy complete end-to-end, real-time solutions for government and market regulators as well as commercial enterprises - turnkey in nature and battle-tested by Canadian Regulators.

Schedule a Live Demo with SQL Power

If you'd like to learn more about the XBRL Power Suite, contact us today to schedule a live demonstration.