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" }