Zero Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thecoolguy@gmail.com - 26 Jan 2006 21:33 GMT

I am building a fact table containing 6 measures. For about 90% of the
rows, 3-4 measures will be zero. What is the best data type to use for
the measures?

Reply to this Message

Jéjé - 27 Jan 2006 02:33 GMT

what are your values when its a non zero value?
focus on the larger number you have to store, not the smallest one.

>I am building a fact table containing 6 measures. For about 90% of the
> rows, 3-4 measures will be zero. What is the best data type to use for
> the measures?

Reply to this Message

David Lundell - 28 Jan 2006 13:35 GMT

Will your measures be zero or null (absence of data -- no sales that day)?

If it is null then your cube will be smaller since Analysis Services does
not calculate and store the measures when it is null. If it is zero than
Analysis Services will calculate and store the data in the cube.

Signature

David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David@MutuallyBeneficial.com

>I am building a fact table containing 6 measures. For about 90% of the
> rows, 3-4 measures will be zero. What is the best data type to use for
> the measures?

Reply to this Message