This section presents sample queries for a number of representative use cases.

Queries are presented in the text-based syntax for clarity. For the purposes of these examples, we assume that we have sales transaction data with records consisting of the following fields (properties or dimensions):

{ TransId, ProductType, Amount, Year, Quarter, Region,
  SalesRep, Customer }

such as:

{ TransId = 1, ProductType = "Widget", Amount = 100.00,
  Year = 2009, Quarter = "09Q1", Region  = "East",
  SalesRep = "J. Smith", Customer = "Customer1" }


Copyright © Legal Notices