MDX - SQL Server Analysis Services 2012 Cube Development - page 200

Let's also suppose that we only have one measure called Sales Amount. The cube
consisting of these dimensions will have one cell for each combination of Year,
Name, Color, and Country. To further simplify the example, we presume that the
cube only contains sales figures for two products, a green sweater and a pair of blue
jeans, in the United States and England for the years 2011 and 2012. The following
table should help us visualize the cube space:

Year Product Name Product Color Country Sales Amount

2011 Sweater Green USA 200000.00

2011 Sweater Green England NULL

2011 Jeans Blue USA 957000.00

2011 Jeans Blue England 150000.00

2012 Sweater Green USA 250000.00

2012 Sweater Green England 350245.00

2012 Jeans Blue USA 304892.00

2012 Jeans Blue England 384204.00