Example - Your Prototype Sales Model, on Paper
You can create an initial dimension map on paper,
to make sure you have identified all of the dimensions, levels, and
categories needed in your PowerCube. The measures to be associated
with this dimensional hierarchy are Sales, Order Qty, Cost, and Discount.
You map the dimensions of your prototype as follows:
| Order date | Products | Locations |
|---|---|---|
| Year | Product Group | Region |
| Quarter | Product Class | Office |
| Month | Product Name | Sales Rep |
| Product No |