XBRL flat table mapping system and method

• US 9,292,544 B2
• Filed: 10/11/2013
• Issued: 03/22/2016
• Est. Priority Date: 03/17/2011
• Status: Active Grant

• Current Assignee: XBRL Cloud Incorporated
• Original Assignee: XBRL Cloud Incorporated
• Inventors: Binstock, Cliff, Milnes, Brian
• Primary Examiner(s): GORTAYO, DANGELINO N
• Application Number:
  US14/052,500
• Publication Number:
  US 20140040322A1
• Time in Patent Office: 893 Days
• Field of Search: 707/602, 707/803, 707/690, 707/756, 707/790, 707/792, 707/796, 707/802, 707/809, 707/812
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]

Abstract

XBRL data may be automatically mapped back and forth between an XBRL instance an set of automatically generated flat tables, where each table represents the projection of a single hypercube.

Claims

1. A computer-implemented method for mapping eXtensible Business Reporting Language (“

XBRL”

) data to a flat table, the method comprising;

obtaining, by the computer, an XBRL linkbase describing relationships among a plurality of XBRL concepts;

identifying, by the computer, an XBRL hypercube to which at least some of said plurality of XBRL concepts are attached as XBRL measures;

identifying, by the computer, a ubiquitous dimension-like XBRL element associated with said XBRL hypercube and a set of one or more non-ubiquitous dimension-like XBRL elements defined in said XBRL hypercube, said ubiquitous dimension-like XBRL element being ubiquitous among XBRL-structured data;

initializing, by the computer, a tabular data structure including a value column for storing facts, a concept column for storing fact-associated concepts, a ubiquitous-dimension column, and one or more non-ubiquitous-dimension columns;

generating, by the computer, a data map mapping said XBRL measures of said XBRL hypercube to said concept column, mapping said ubiquitous dimension-like XBRL element of said XBRL hypercube to said ubiquitous-dimension column, and respectively mapping said set of one or more non-ubiquitous dimension-like XBRL elements of said XBRL hypercube to said one or more non-ubiquitous-dimension columns;

storing said data map and said tabular data structure;

obtaining XBRL instance data comprising a plurality of facts and associated metadata;

using said data map, selecting from said XBRL instance data a plurality of hypercube-attached facts that are respectively associated with any one of said plurality of XBRL measures and that are explicitly and implicitly associated with exactly said set of one or more non-ubiquitous dimension-like XBRL elements; and

using said data map, populating said tabular data structure with a plurality of rows corresponding respectively to said plurality of hypercube-attached facts.

2. The method of claim 1, further comprising providing said populated tabular data structure for display to a user.

3. The method of claim 1, wherein populating said tabular data structure comprises, for each of said plurality of hypercube-attached facts:

adding a row to said tabular data structure;

populating said value column of said added row with a current hypercube-attached fact;

determining a fact-associated measure of said plurality of XBRL measures as being associated with said current hypercube-attached fact;

populating said concept column of said added row with said fact-associated measure;

determining a fact-associated ubiquitous metadata value that is associated with said current hypercube-attached fact and that corresponds to said ubiquitous dimension-like XBRL element;

using said data map, populating said ubiquitous-dimension column with said fact-associated ubiquitous metadata value;

determining one or more fact-associated non-ubiquitous metadata values that are associated with said current hypercube-attached fact and that respectively correspond to said set of one or more non-ubiquitous dimension-like XBRL elements;

using said data map, respectively populating said one or more non-ubiquitous-dimension columns with said one or more fact-associated non-ubiquitous metadata values.

4. The method of claim 3, wherein determining said one or more fact-associated non-ubiquitous metadata values comprises:

determining that said XBRL instance data does not explicitly associate said current hypercube-attached fact with a metadata value corresponding to at least one of said set of one or more non-ubiquitous dimension-like XBRL elements;

obtaining a hypercube definition defining said XBRL hypercube, said hypercube definition including a default value corresponding to said at least one of said set of one or more non-ubiquitous dimension-like XBRL elements; and

implicitly associating said default value with said current hypercube-attached fact.

5. The method of claim 4, further comprising making said default value identifiable as having been implicitly associated with said current hypercube-attached fact.

6. The method of claim 1, further comprising:

identifying among said plurality of XBRL concepts a plurality of implicitly-attached concepts that are implicitly attached to an implicit empty hypercube that is associated with said ubiquitous dimension-like XBRL element;

initializing a second tabular data structure including a second value column, a second concept column, and a second ubiquitous-dimension column; and

updating said data map to further map said plurality of implicit measures of said implicit empty hypercube to said second concept column, and to further map said ubiquitous dimension-like XBRL element of said implicit empty hypercube to said second ubiquitous-dimension column.

7. The method of claim 6, further comprising:

selecting from said XBRL instance data a plurality of implicitly-attached facts that are respectively associated with any one of said plurality of implicit measures; and

using said data map, populating said second tabular data structure with a plurality of rows corresponding respectively to said plurality of implicitly-attached facts.

8. The method of claim 7, further comprising providing said populated second tabular data structure for display to a user.

9. The method of claim 7, wherein populating said second tabular data structure comprises, for each of said plurality of implicitly-attached facts:

adding a row to said second tabular data structure;

populating said second value column of said added row with a current implicitly-attached fact;

determining a fact-associated implicit measure of said plurality of implicit measures as being associated with said current implicitly-attached fact;

populating said second concept column of said added row with said fact-associated implicit measure; and

determining a fact-associated ubiquitous metadata value that is associated with said current implicitly-attached fact and that corresponds to said ubiquitous dimension-like XBRL element.

10. The method of claim 6, wherein identifying said plurality of implicitly-attached concepts comprises:

identifying a set of explicit XBRL hypercubes, including said XBRL hypercube, to which any of said plurality of XBRL concepts are attached as XBRL measures; and

identifying among said plurality of XBRL concepts a plurality of unattached concepts that are not attached to any of said set of explicit XBRL hypercubes.

11. The method of claim 6, wherein identifying said plurality of implicitly-attached concepts comprises:

identifying a set of explicit XBRL hypercubes, including said XBRL hypercube, whose definitions are mirrored in said XBRL linkbase; and

identifying among said plurality of XBRL concepts a plurality of unattached concepts that are not attached to any of said set of explicit XBRL hypercubes.

12. A computer-readable, non-transitory storage medium having stored thereon instructions that, when executed by a processor, configure the processor to:

obtain an XBRL linkbase describing relationships among a plurality of XBRL concepts;

identify an XBRL hypercube to which at least some of said plurality of XBRL concepts are attached as XBRL measures;

identify a ubiquitous dimension-like XBRL element associated with said XBRL hypercube and a set of one or more non-ubiquitous dimension-like XBRL elements defined in said XBRL hypercube, said ubiquitous dimension-like XBRL element being ubiquitous among XBRL-structured data;

initialize a tabular data structure including a value column for storing facts, a concept column for storing fact-associated concepts, a ubiquitous-dimension column, and one or more non-ubiquitous-dimension columns;

generate a data map mapping said XBRL measures of said XBRL hypercube to said concept column, mapping said ubiquitous dimension-like XBRL element of said XBRL hypercube to said ubiquitous-dimension column, and respectively mapping said set of one or more non-ubiquitous dimension-like XBRL elements of said XBRL hypercube to said one or more non-ubiquitous-dimension columns;

store said data map and said tabular data structure;

obtain XBRL instance data comprising a plurality of facts and associated metadata;

using said data map, select from said XBRL instance data a plurality of hypercube-attached facts that are respectively associated with any one of said plurality of XBRL measures and that are explicitly associated with exactly said set of one or more non-ubiquitous dimension-like XBRL elements; and

using said data map, populate said tabular data structure with a plurality of rows corresponding respectively to said plurality of hypercube-attached facts.

13. The non-transitory storage medium of claim 12, wherein the instructions that configure the processor to populate said tabular data structure further comprise instructions configuring the processor to, for each of said plurality of hypercube-attached facts:

add a row to said tabular data structure;

populate said value column of said added row with a current hypercube-attached fact;

determine a fact-associated measure of said plurality of XBRL measures as being associated with said current hypercube-attached fact;

populate said concept column of said added row with said fact-associated measure;

determine a fact-associated ubiquitous metadata value that is associated with said current hypercube-attached fact and that corresponds to said ubiquitous dimension-like XBRL element;

using said data map, populate said ubiquitous-dimension column with said fact-associated ubiquitous metadata value;

determine one or more fact-associated non-ubiquitous metadata values that are associated with said current hypercube-attached fact and that respectively correspond to said set of one or more non-ubiquitous dimension-like XBRL elements;

using said data map, respectively populate said one or more non-ubiquitous-dimension columns with said one or more fact-associated non-ubiquitous metadata values.

14. The non-transitory storage medium of claim 12, wherein the memory stores further instructions that further configure the processor to:

identify among said plurality of XBRL concepts a plurality of implicitly-attached concepts that are implicitly attached to an implicit empty hypercube that is associated with said ubiquitous dimension-like XBRL element;

initialize a second tabular data structure including a second value column, a second concept column, and a second ubiquitous-dimension column; and

update said data map to further map said plurality of implicit measures of said implicit empty hypercube to said second concept column, and to further map said ubiquitous dimension-like XBRL element of said implicit empty hypercube to said second ubiquitous-dimension column.

15. A computing apparatus for mapping eXtensible Business Reporting Language (“

XBRL”

) data to a flat table, the apparatus comprising;

a processor and a memory storing instructions that, when executed by the processor, configure the apparatus to;

obtain an XBRL linkbase describing relationships among a plurality of XBRL concepts;

identify an XBRL hypercube to which at least some of said plurality of XBRL concepts are attached as XBRL measures;

identify a ubiquitous dimension-like XBRL element associated with said XBRL hypercube and a set of one or more non-ubiquitous dimension-like XBRL elements defined in said XBRL hypercube, said ubiquitous dimension-like XBRL element being ubiquitous among XBRL-structured data;

initialize a tabular data structure including a value column for storing facts, a concept column for storing fact-associated concepts, a ubiquitous-dimension column, and one or more non-ubiquitous-dimension columns;

generate a data map mapping said XBRL measures of said XBRL hypercube to said concept column, mapping said ubiquitous dimension-like XBRL element of said XBRL hypercube to said ubiquitous-dimension column, and respectively mapping said set of one or more non-ubiquitous dimension-like XBRL elements of said XBRL hypercube to said one or more non-ubiquitous-dimension columns;

store said data map and said tabular data structure;

obtain XBRL instance data comprising a plurality of facts and associated metadata;

using said data map, select from said XBRL instance data a plurality of hypercube-attached facts that are respectively associated with any one of said plurality of XBRL measures and that are explicitly or implicitly associated with exactly said set of one or more non-ubiquitous dimension-like XBRL elements; and

using said data map, populate said tabular data structure with a plurality of rows corresponding respectively to said plurality of hypercube-attached facts.

16. The apparatus of claim 15, wherein the instructions that configure the apparatus to populate said tabular data structure further comprise instructions configuring the apparatus to, for each of said plurality of hypercube-attached facts:

add a row to said tabular data structure;

populate said value column of said added row with a current hypercube-attached fact;

determine a fact-associated measure of said plurality of XBRL measures as being associated with said current hypercube-attached fact;

populate said concept column of said added row with said fact-associated measure;

determine a fact-associated ubiquitous metadata value that is associated with said current hypercube-attached fact and that corresponds to said ubiquitous dimension-like XBRL element;

using said data map, populate said ubiquitous-dimension column with said fact-associated ubiquitous metadata value;

determine one or more fact-associated non-ubiquitous metadata values that are associated with said current hypercube-attached fact and that respectively correspond to said set of one or more non-ubiquitous dimension-like XBRL elements;

using said data map, respectively populate said one or more non-ubiquitous-dimension columns with said one or more fact-associated non-ubiquitous metadata values.

17. The apparatus of claim 15, wherein the memory stores further instructions that further configure the apparatus to:

identify among said plurality of XBRL concepts a plurality of implicitly-attached concepts that are implicitly attached to an implicit empty hypercube that is associated with said ubiquitous dimension-like XBRL element;

initialize a second tabular data structure including a second value column, a second concept column, and a second ubiquitous-dimension column; and

update said data map to further map said plurality of implicit measures of said implicit empty hypercube to said second concept column, and to further map said ubiquitous dimension-like XBRL element of said implicit empty hypercube to said second ubiquitous-dimension column.