I'm connecting to a cube that has a measure called sales.
If I browse the cube in anlysis manager, I will see null
values where they should be. However, when I connect to
the cube from excel, it places a 0 in the cell that should
be null. I looked at all of the table options and found
no way to exclude the 0 and show null. The problem comes
in because I want to average. Any ideas?