Zero amounts in cube not showing up as zero - Chri

We were having the same problem.  I think it has something to do with
Floating point values.

We solved the problem by going to the BIDS and on the "Cube Structure" tab
Changing the Source datatype of the measure to be a datatype of "Currency"

Our values were then showing up correctly.
Hope that helps.

Zero amounts in cube not showing up as zero - louvi

I have a relational ss2k5 datawarehouse with dimension and fact tables
that I used to create an Analysis Services 2005 cube using the
wizard.  One of the measures shows amounts that should be zero as
2.27373675443232E-13.  When I check the datawarehouse and add up the
amounts from the rows that make up the measure, they definitely total
to zero.  The field in the datawarehouse is defined as numeric(15,2).
Does anyone know how Analysis Services arrives at this number and what
can I do to make it pick up the zero amounts correctly in the cube?
This happens for several measure amounts that should be zero.  They
all reflect this same number and  I can't seem to find what they have
in common that would cause this.

Zero amounts in cube not showing up as zero - louvi

Chris,

Thanks very much.  That worked for me.