|
Home > Archive > MS SQL Data Warehousing > January 2006 > Zero Values
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| thecoolguy@gmail.com 2006-01-26, 4:53 pm |
| 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.
<thecoolguy@gmail.com> wrote in message
news:1138311183.681121.235500@z14g2000cwz.googlegroups.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?
>
| |
| David Lundell 2006-01-28, 9:23 am |
| 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@MutuallyBenefi
cial.com
<thecoolguy@gmail.com> wrote in message
news:1138311183.681121.235500@z14g2000cwz.googlegroups.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?
>
|
|
|
|
|