Commercially Available Off The Shelf (COTS) Software

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

 

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.

 

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

 

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.

 

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: Calculation Editor View

The following figure shows the XBRL Designer Calculation editor. Here a user can create a Calculation by simply choosing a Mathematical operation icon and dropping it into the playpen and naming that calculation. The user can then add as many concepts as they wish to the calculation box, forming the required calculation. The calculation result can then be assigned to a derived data element/concept.

 

XBRL Designer: Formula Editor View

XBRL Designer also allows users to easily create complicated formulas via the XBRL Designer Formula Editor. Here a user can create a Formula by simply choosing a Mathematical operation icon and dropping it into the playpen and naming that calculation. The user can then add as many concepts as they require to the calculation box, forming the required calculation. The calculation result is then evaluated by one of several pre-built conditional operators assigning a Formula status of Success, Warning or Failure.

These formulas can be as complex or as simple as required, and can be written to both the metadata dictionary and/or the Taxonomy.

 

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.