I think there are many works over Java-based server Mondrian, in which MDX-based OLAP operators have been created to apply multidimensional analysis over data (Ex.: LMDQL, GeoMDQL, both are PhD thesis from Federal University of Pernambuco, Brazil). I’m going to explain this topic through the four OLAP operator that I have implemented for Forensic LMDQL…
I’ve been thinking about a financial OLAP system based on XBRL/XML/Json documents (free and open source) , in which components based on Front-End advanced technologies are implemented. The state of the art of this kind of system (free and open source) is based on MDX queries (ex.: Forensic LMDQL, [if you know another one, please let…
The XQuery that I’m using to get the element name through its label name (which is contained in Label Linkbase) is following: xquery version ‘3.0’; declare namespace link=’http://www.xbrl.org/2003/linkbase’; declare namespace xlink=’http://www.w3.org/1999/xlink’; distinct-values(doc(“db/fb-20120630_lab.xml”)//link:linkbase/link:labelLink/ link:label[contains(text(),”Less accumulated depreciation and amortization”)]/@xlink:label) Result: us-gaap_AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment_lbl You have to do a simple treatment and then: us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment. * The “fb-20120630_lab.xml” file was utilized in…
Aiming to implement a OLAP system over XBRL native document, some XML queries (XQuery) were important which I want to shared in this post. This following queries can be interesting when the developer wish to get some data, which are within XBRL taxonomy (I mean, XBRL native documents). 1. Catching all elements of a XBRL…
This work was develped with Prof. Paulo Caetano, PhD. It has been accepted at IADIS ICWI’14 in Porto, Portugal. Abstract: The Information Technology has led many countries to adopt technologies based on internationally accepted standards for the disclosure of their financial statements. The XBRL technology is adopted to represent financial data (instances) and its semantics…
This work was develped with Prof. Paulo Caetano, PhD. It has been accepted at IEEE EDOC’14 in Ulm University, Germany. Abstract: The current status of Information Technology has prompted several countries to adopt technologies based on internationally accepted standards for the disclosure of their financial statements. In order to facilitate data exchange and increase the transparency of financial information…
Abstract Geographic Information Systems (GIS) deal with virtual localization of real objects. The geographic data insertion in the semantic of the financial data allows the using of a tooling which utilizes geographic data with analysis tool. A financial analysis tool based on geovisualization allows accountants or auditors notice tendencies and criticalities in virtual maps. A…
Software Engineering 