sql server data warehouse: 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?

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

[quoted text, click to view]

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.


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

[quoted text, click to view]