Analysis of financial and business information based on interactive data
View Patent ↗Systems and methods are provided for analysis of financial and business information based on interactive data, such as XBRL data. According to one embodiment, a method is provided for mapping extended taxonomy elements to base taxonomy elements. A list of base taxonomy elements is displayed on a display device. A taxonomy map is displayed on the display device. The taxonomy map includes information regarding one or more extended taxonomy elements of a reporting entity that are not mapped to any base taxonomy elements. Responsive to one or more user input events corresponding to a selection of a base taxonomy element and corresponding to a request to map an extended taxonomy element to the selected base taxonomy element, the compatibility of the selected base taxonomy element with the extended taxonomy element is validated. If the compatibility is affirmed, then an association is formed between the extended taxonomy element and the selected base taxonomy element.
1. A computer-implemented method comprising:
receiving, by a folio module of a reporting/analysis application integrated with a spreadsheet application, information regarding a user selection event identifying a plurality of taxonomy objects to be imported into the reporting/analysis application;
responsive to the user selection event, retrieving by the folio module, business data corresponding to the plurality of taxonomy objects from a plurality of data sources, including a first data source containing financial reporting (FR) level information and a second data source containing general ledger (GL) level information;
generating and displaying an aggregated result, by the folio module, within a single cell of a spreadsheet representing a combination of at least a portion of business data retrieved from the first data source and a portion of business data retrieved from the second data source; and
wherein the reporting/analysis application and the spreadsheet application are implemented in one or more processors and one or more computer-readable storage media of one or more computer systems, the one or more computer-readable storage media having instructions tangibly embodied therein representing the reporting/analysis application and the spreadsheet application that are executable by the one or more processors.
2. The method of claim 1 , wherein the spreadsheet application comprises Microsoft® Excel.
3. The method of claim 1 , wherein the first data source comprises one or more Extensible Business Reporting Language (XBRL) instance documents.
4. The method of claim 1 , further comprising storing a summary of the business data in an XBRL document.
5. A program storage device readable by a computer system, tangibly embodying a program of instructions executable by one or more processors of the computer system to perform method steps for aggregating information from multiple data sources, said method steps comprising:
receiving information regarding a user selection event identifying a plurality of taxonomy objects to be imported into the reporting/analysis application;
responsive to the user selection event, retrieving business data corresponding to the plurality of taxonomy objects from a plurality of data sources, including a first data source containing financial reporting (FR) level information and a second data source containing general ledger (GL) level information; and
generating and displaying an aggregated result within a single cell of a spreadsheet representing a combination of at least a portion of business data retrieved from the first data source and a portion of business data retrieved from the second data source.
6. The program storage device of claim 5 , wherein the spreadsheet application comprises Microsoft® Excel.
7. The program storage device of claim 5 , wherein the first data source comprises one or more Extensible Business Reporting Language (XBRL) instance documents.
8. The program storage device of claim 5 , further comprising storing a summary of the business data in an XBRL document.