How do you exclude data that doesn't exist?

[dubell]

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

[Island1]

Doug:

Take a look at my articles on nulls, etc. I deal with the stuff to which you refer within several contexts.

http://www.databasejournal.com/article.php/1459531

Get back with any remaining questions, and I'll try to help.

B*