Seeing the Power of Dimensional Queries
Wednesday, May 28, 2014 at 02:33PM
Charlie in Becoming an XBRL Master Craftsman

I put together some example dimensional-type queries using the functionality of  You can see and walk through the queries here, or if you want you can download this Excel spreadsheet which executes the queries and populates the Excel spreadsheet with the query results.

While Query 5 which shows a breakdown of assets by business segments is the sexiest example (see the results below), by working through all the examples you can start to see some issues you need to keep in mind when querying information across reporting entities.

(Click to view larger image)

Here is the result of another query of the business segments of the S&P 500. (This is the actual query syntax.)

I am not going to go into any more detail, you can fiddle with the examples on your own (all run on the DOW 30 so you don't need a subscription to the service).

One thing I will point out is how you can manage the reality that some filers have a dimension (or [Axis] they are also called), some do not, and sometimes different dimension-defaults are used by different filers.  Walk through the examples and you can see how you can manage all of that using the query.

Article originally appeared on Intelligent XBRL-based structured digital financial reporting using US GAAP and IFRS (
See website for complete article licensing information.