Logo Banner
Cubes

Data Explorer Suite collects data from the QuickBooks database and arranges it into separate multi-dimensional data Cubes defined by their included dimensions and measures.  Each cube provides a unique flexibility in reporting and analysis.  Depending upon the Cubes licenesed you may have access to one or more of the following Cubes:

A cube is defined by the Dimensions available and the data detail level it provides. 

For example, the Sales Cube reports Sales transactions collected from Invoices, Sales Receipts and Credit Memos for each customer, item and time period. Therefore, the level of detail is the Sales Line Item and the primary dimensions are the Customer, Item, Time and Measure dimensions. 

Each of these dimension can be placed upon a data table view as a row or a column.  Individual dimensions can be placed as rows or columns or multiple dimensions can be nested on a row or a column. 

Dimension not on a row or column can be placed upon the Slicer Bar as criterion members or to provide context. 

The Data Table View below shows selected members of the Item Dimension as rows and selected members of the Measures Dimension as columns with the year 2012 of the Time Dimension and the customer type Commerical of the Customer Dimension filtering or providing context for the data.

Sales Cube View

In similar ways, dimensions can be axes on graphs and charts.

 

Dimensions

As mentioned, each cube has one or more dimensions included for categorization and analysis of the relevant data.  No cube has all dimensions derivable from the QuickBooks data.  Dimensions are used to drill into the data or to select specific items from a dimension.  The following is a typical list of the dimension that can be extracted from the data in QuickBooks:

  • Account Dimension
  • Class Dimension
  • Customer Dimension
  • Employee Dimension
  • Item Dimension
  • SalesDocs Dimension
  • Sales Rep Dimension
  • Time Dimension
  • Transactions Dimension
  • Vendor Dimension
  • Measures Dimension

 

Hierarchies

Each dimension can contain one or more hierarchies.  A hierarchy is a specific ordering of the attributes a dimension contains. 

For example, the Item list as defined by QuickBooks contains all the products or items which can be referred to.  Items can be parents of other items to create additional categorization.  So one DES hierarchy of the Item Dimension, the Item Hierarchy, allows for a drill down from an Item parent to its children. 

Each level of a hierarchy can contain totals and subtotals for the chosen measures.

Item Hierarchy in Item Dimension Item Dimension Item hierarchy with top level parent All Item and child level parents Hardware and Wood Door.

Another Item Dimension hierarchy is the Type hierarchy which categorizes items by the type attribute assigned within QuickBooks.