How Do I Represent An OLAP 4D Cuboid?
<p>I am going through the exercise posted below. I don't quite understand how to represent the 4th dimension on paper. If it was just customer, date, product that will be straightforward. Do I have to rollup on something in order to get the fourth dimension? </p>

<p>I was going to Drill down to product-cosmetics, dice on time (to get everything after Jan 2010) and slice on cosmetics. </p>

<blockquote>
  <p>Suppose a market shopping data warehouse consists of four dimensions:
  customer, date, product, and store, and two measures: count, and avg
  sales, where avg sales stores the real sales in pounds at the lowest
  level but the corresponding average sales at other levels.</p>
  
  <p>Starting with the base cuboid [customer, date, product, store], what
  specific OLAP operations (e.g., roll-up student to department (level))
  should be performed in order to list the average sales of each
  cosmetic product since January 2010? Explain your answer.</p>
</blockquote>