In AS2000, split the measures you want to retain null behavior and eliminate
the rows from your fact table.
In AS2005, set the null handling behavior on each measure to retain.
--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
"GB" <v7v1k3 (AT) hotmail (DOT) com> wrote
805 (AT) clgrps13 (DOT) ..
Quote:
Hello:
I have a lot of NULL values in data fact table for measure column
which is Numeric data type. When I created a cube, it showed me
0 value instead of NULL. Could you give me a hint how to preserve
NULL value for the measure in a cube?
Thanks,
GB |