Commercially Available Off The Shelf (COTS) Software

XBRL DESIGNER:
Business-user Friendly Do-It-Yourself Taxonomy and Returns Design Management

 

Traditionally, Taxonomy design required skilled XML programmers or XBRL specialists to prepare taxonomies by specifying detailed concepts, groups, dimensions, calculations, and validation rules.

XBRL Designer is a rules-based, meta-data driven GUI design module that now gives business users complete control - streamlining taxonomy design and XBRL Formula creation, as well as the returns definitions and Data Collection design process. XBRL Designer allows business managers and regulators to quickly react to changing legislation, standards and policies without IT or 3rd party intervention.

XBRL Designer enables "self service" at the business level in the same way XBRL Forms enabled "self service" for filers three years earlier. It demystifies XBRL Taxonomy Design and allows an organization to accelerate the rollout of complex Data Collection templates, often in hours or days instead of months.

 

XBRL Designer

Detailed Functionality

  • No XBRL knowledge required
  • Java web start application launched from EAS
  • Security and updates handled through EAS integration
  • Metadata-driven data return design solution
  • Metadata Management
  • Create metadata items such as data elements, groupings, dimensions etc.
  • Stored and fully versioned in a database
  • Formula / Rule Management
  • Design calculations and formulas for the population of a data element
  • Create rules for fatal errors and warnings using simple or complex formulas to improve data quality
  • Return Design and Management
  • Design schedules and their form layouts for information returns with an easy drag and drop interface from the defined metadata
  • Generates XBRL Forms configuration file and XBRL Taxonomy

 

UBmatrix Taxonomy Designer: Advanced Taxonomy Design

For advanced XBRL users, XBRL Designer comes bundled with UBmatrix Taxonomy Designer. This COTS software is less business-user-friendly (requires XBRL expertise) but better suited to creating new taxonomies from scratch - as opposed to XBRL Designer which is ideal for business users who need to maintain and manage existing taxonomies.

UBmatrix Taxonomy Designer Features:

  • Full flexibility Taxonomy Design and Editing
  • Extending Existing Taxonomies
  • Validating your Taxonomy
  • Taxonomy Concepts
  • Dimensions
  • Calculations
  • Formulas (Business Rules)
  • Instance Document editing and validation

XBRL Designer: Integration

XBRL Designer takes the complexity out of XBRL. It integrates with all the other XBRL Power suite components through the Enterprise Application Suite (EAS) web portal which provides an entry point for the user into every solution component. User authentication and security is managed through EAS, allowing organizations flexibility in securing solution design components and building workflow processes.

XBRL Components

 

Metadata Management

XBRL Designer has an extensive and easy-to-use Metadata Management facility, providing the following high-level features:

  • Intuitive, easy to use, graphic user interface that allows for rapid browsing and searching of the metadata objects (including the use of wildcards) and the identifying of relationships between objects
  • Creating, editing, and expiring metadata objects via easy-to-use drag & drop graphic user interface (no XBRL knowledge required)
  • Core metadata objects include concepts, groupings, dimensions, calculations, formulas, taxonomies, returns, and schedules
  • Core metadata objects are fully extensible using label and reference metadata objects, making the scope of metadata management flexible to the organization's need
  • Metadata objects are validated against the XBRL processing engine to ensure they are valid XBRL objects
  • Users can add an unlimited number of comments about metadata objects
  • Metadata objects are defined based on key attributes to eliminate the possibility of duplicate objects being created
  • All metadata objects are stored in a database repository, providing a single version of the truth
  • All metadata objects have their own lifecycle with full retention of historical user changes and comments
  • Existing XBRL Taxonomies can be imported into the metadata repository
  • Reporting on metadata objects is available from XBRL Analytics

 

Formula Management

XBRL Designer offers a Formula Management facility, providing the following high-level features:

  • Calculations (summations) and Formulas (complex equations) are created through an intuitive drag and drop graphical user interface
  • The user selects objects from the metadata repository and the operators and functions necessary to construct calculations and formulas
  • Formulas are validated against the XBRL processing engine to ensure they are valid XBRL objects
  • Users can add an unlimited number of comments about calculation and formula metadata objects
  • Calculations and Formulas are metadata objects stored in the metadata repository with their own lifecycle (with full retention of historical user changes and comments
  • Formulas can be bound to a dimension through a filter identifying which dimension members apply to the formula
  • Existing calculations and formulas can be opened and used as a template for new calculations and formulas
  • XBRL Formulas can be imported and exported into the metadata repository
  • Reporting on calculation and formula metadata objects is available from XBRL Analytics

 

Return Management

XBRL Designer offers a Forms Designer to manage return definition, providing the following high-level features:

  • Returns are created through an intuitive drag and drop graphical user interface where the user selects objects (such as data elements, dimensions, documentation, calculations and formulas) from the metadata repository
  • Data elements can be grouped together creating their own grouping object for reuse
  • Browsing and searching functions allow the user to rapidly find the desired metadata objects
  • Calculations and formulas can be defined as a rule or as an outcome that feeds into a data element
  • An unlimited number of schedules can be added to a return
  • Schedules are organized into a hierarchy
  • Users can add an unlimited number of comments about return and schedule metadata objects
  • Returns and schedules are metadata objects stored in the metadata repository with their own lifecycle (with full retention of historical user changes and comments)
  • Objects on the schedules can be formatted and renamed as desired by the user
  • Existing returns can be opened and used as a template for new returns
  • Existing schedules can be copied as a starting point for new schedules
  • Return definitions and XBRL Taxonomies are exported for use by XBRL Forms, XBRL Analytics or any other taxonomy-consuming application
  • Reporting on return and schedule metadata objects is available from XBRL Analytics

 

Creating Metadata Management Components and Rules

XBRL Designer: Concept Editor View

XBRL Designer allows non-technical users to create concepts, calculations, dimensions and formulas and to add them to the Metadata Dictionary and/or taxonomy - allowing them to easily evolve the required Data Collection data elements and associated validation rules without needing to learn XML or XBRL.

The following figure shows the XBRL Designer Concept editor. Here a user can create and assign attributes to the various data collection elements (concepts). These concepts can then be used for end-user data entry or as part of a calculation or formula.

All created objects can be stored in the Metadata Dictionary or written directly to the Taxonomy.

 

XBRL Designer: Formulas, Assertions & Calculations

The following figure shows the XBRL Designer Assertion editor. A user can create a Formulas, Assertions and Calculations by simply inserting concepts and opertations, and assigning the result to a derived data element/concept.

 

Creating the Forms/Return Layout

XBRL Designer: Form Design View

XBRL Designer also allows non-technical users to access pre-defined Taxonomy components (such as concepts, calculations and dimensions) from the Metadata Dictionary or an existing taxonomy and drag-and-drop them into the Forms layout playpen. Each page in the Forms Layout playpen represents a schedule and the collection of all schedules form a Return.

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.