I have a cube that is showing measures that don't exist. Let me give an example. This example will include 3 dimensions, product, location, and time. The fact table measure will be sales.

Here are the distinct values if you were to write a sql query against the dimensionl model that feeds the cube.

Product Location Time Sales
A X 1/04 200
B Y 1/04 100

A X 2/04 300

In the cube, if you were to look at product by location for just 2/04, you would see:

Product Location Sales
All Loc 300
A X 300
Y

All Loc
B X
Y

How do you get rid of the zero's or combinations that don't exist?

Thanks,

Doug