Xbrl database mapping system and method

A computer-implemented method for mapping eXtensible Business Reporting Language (“XBRL”) data to a multidimensional database (“MDDB”) comprising an MDDB fact table and a plurality of MDDB dimension tables, the MDDB fact table comprising a plurality of MDDB measure columns and a plurality of MDDB dimension columns corresponding respectively to the plurality of MDDB dimension tables, the method comprising:

• obtaining an XBRL instance document comprising a plurality of multidimensional business facts structured according to a plurality of XBRL measures and a plurality of XBRL dimensions;
• obtaining, by the computer, a data map mapping each of said plurality of XBRL dimensions to a corresponding one of the plurality of MDDB dimension tables, said data map further mapping each of said plurality of XBRL measures to a corresponding one of said plurality of MDDB measure columns;
• and
• using said data map, populating said MDDB with said plurality of multidimensional business facts.

A computer-implemented method for mapping a multidimensional database to an eXtensible Business Reporting Language (“XBRL”) hypercube, the method comprising:

• obtaining, by the computer, the multidimensional database, the multidimensional database comprising a fact table and a plurality of dimension tables, said fact table comprising a plurality of compound primary keys corresponding to a plurality of rows, each row having a plurality of non-dimension column values corresponding to a plurality of non-dimension columns, each primary key comprising a plurality of dimension column values corresponding to a plurality of dimension columns;
• declaring, by the computer, an XBRL network corresponding to said fact table;
• declaring, by the computer, an XBRL hypercube associated with said XBRL network, said XBRL hypercube comprising a plurality of XBRL dimensions and a plurality of XBRL measures, said plurality of XBRL dimensions mapping respectively to said plurality of dimension columns, said plurality of XBRL measures mapping respectively to said plurality of non-dimension columns;
• and
• for each of said plurality of rows, the computer:
• generating an XBRL context mapped to a given compound primary key of a given row;
• and
• adding to said XBRL hypercube a plurality of measure:fact pairs associated with said generated XBRL context, each of the plurality of measure:fact pairs having a measure corresponding to a given non-dimension column of said plurality of non-dimension columns, and having a fact corresponding to a non-dimension column value corresponding to the given non-dimension column and the given row.