In this example, a sample query is shown in a cube representation and a relational representation. The Query presents the Sales and Units measures by Geography (World and United States of America) for two products (Canoes and Tents) over three months (Jan., Feb., and Mar. 2002).
Only a single page of the data representation is shown. This page represents the Channel dimension with a value of All Channels.
The following table presents a cube representation of the sample query.
The following table presents a relational representation of the sample query. Notice that in the relational representation, all the dimensions (Geography, Product, and Time) appear as columns. There is an additional column at the end of the table for each of the measures (Sales and Units).