XBRL Power Suite
Maximum Compliance, Maximum Adoption

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

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

SQL Power's zero-footprint solution offers the highest levels of automated filing 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 taxonomy. 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:

XBRL Forms and XBRL Power EAS thin-client platforms form the building blocks for the user experience,
XBRL Designer, a business-user lead tool for taxonomy and returns creation,
XBRL Analytics pre-built reporting and analytical solution,
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.

Benefits

SQL Power's zero-footprint 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 Read more
The Canadian Regulatory community as well as many Central Banks worldwide are turning to SQL Power for their standardized forms-based architecture - built on ISO and XBRL standards - to automate the collection of business information and corporate financial filings. Our end-to-end forms-based XBRL solution augments the collection process and substantially reduces the processing/review effort.

Learn more about XBRL for Banking Supervision and Solvency Regulation
Credit Risk Management in Commercial Lending Read more Read more
SQL Power's zero-footprint solution gives commercial lenders a faster, standardized method to collect high-quality financial data from their borrowers and ultimately accelerate financial analysis.

Learn more about XBRL for Credit Risk Management
Capital Markets Investment and Securities Regulation Read more Read more
SEC Filers: Publicly Traded Issuers

While the SEC and many Central Banks have mandated the XBRL standard, until now the onus has typically been on the Publicly Traded Issuers to shoulder the expense of in sourcing an expensive XBRL build, in order to comply with these mandates.

SQL Power has essentially reversed that model with the XBRL Power Suite. This web-based solution allows the Issuer to log in, file their returns on line, certify against the US GAAP XBRL taxonomy in real-time and submit to the SEC via Straight Through "system to system" Processing (STP) for financial analysis and distribution. It even offers the publicly traded issuer "last minute" ad-hoc taxonomy extensions on the fly. Issuer to Investor related Corporate Actions Announcements are also supported against the ISO 20022 Taxonomy.
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.